crete a data base relationship model

Entity:

1. Students;
2. Professors;
3. Dormitories buildings;

Attributes of students:

1. Name;
2. Address;
3. Dorm;
4. Room number;
5. Stu dent advisors;

Relationship ratios:

1. One to One- student to advisor;
2. One to Many (1: N)-advisor to students;
3. Many to Many (n: M)- students to their advisors;

Foreign keys

This is the referencing relation of the column i.e. student advisor

Primary keys

They identify the column i.e. the Sname.

Assumptions

1. Only single attributes are mentioned for the database because the database is made by single attributes
2. Concepts represented by entity, relationship or attributes type  are represented by capital letters
3. Key property (k) types which is a attribute of property (p) can be determined by P and vice versa
4. Verticals line separate the  main attributes of the relation
5. Each attributes is an atomic; a distinct line attributes
6. Each of the tuples carry single phone numbers of both students and advisors

Posted Date: 2/21/2013 1:21:07 AM | Location : United States

Ask an Expert

Related Discussions:- Relational schema, Assignment Help, Ask Question on Relational schema, Get Answer, Expert's Help, Relational schema Discussions

Write discussion on Relational schema
Your posts are moderated

Write your message here..

Related Questions

What are domain constraints, What are domain constraints?  A  domain is... What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

What are the disadvantages of file processing system, What are the disadvan... What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Need website hacking security test, We want have a website; we need to test... We want have a website; we need to test the security of our website. You need to: -Try to bypass our security by simulate a website hacking -Try some hack Techniques like

Illustrate the fifth normal form, Fifth Normal Form (5NF) These relatio... Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

Define one-way associations using pointers, One-way Associations If an... One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d... Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

What do you mean by an execution plan, What do you mean by an execution pla... What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

IT Assignmnet, i need help for assignment .. i need help for assignment ..

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

ERD, The entity type STUDENT has the following attributes: Student Name, Ad... The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o