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 data models, What are data models? Explain it detail? Entity ... What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

Phase 1 Individual Project, How do I begi How do I begin

Determine the object-oriented design process, An object-oriented design pro... An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

What is a cascading update, What is a cascading update? Referential int... What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar

Conversion of er diagram to relational database, Conversion of entity sets:... Conversion of entity sets: I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R pri

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp... Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Oracle fusion middleware, Oracle Fusion Middleware: Key Skills: Consul... Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

Domain constraint, Domain Constraint It shows that each attribute in a ... Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

4, explain the level architectures of the database management system explain the level architectures of the database management system

Transaction states, The following variant of the primary copy asynchronous-... The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat