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 is a virtual table that draws its data from the result, What is a virt... What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.

Define functional and multivalued dependencies, Define functional and multi... Define functional and multivalued dependencies.       Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at

What is the main goal of raid technology, What is the main goal of RAID tec... What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Which method of access uses key transformation, Which method of access uses... Which method of access uses key transformation? A Hash method of access uses key transformation.

Explanation on data sharing, Explanation on Data Sharing? Explanation on Data Sharing?

Illustrate the deployment diagram, Illustrate the Deployment Diagram A... Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

#title using the invoice, using the invoice table shown below,write the rel... using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Explain the disadvantages of using dbms, Explain the disadvantages of using... Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

On laod, how to write a in a text and load it on mysql how to write a in a text and load it on mysql

Relationships, Let us first describe the term relationships. What Are Re... Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic