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 stored and derived attributes, What are stored and derived attribu... What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Keys, #questiontypes of keys examples.. #questiontypes of keys examples..

Explain the systems development life cycle, Explain the systems development... Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se

What is indexed sequential file organization, What is indexed sequential fi... What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing

Define object-oriented database, Question : Object-Oriented Database (O... Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Distributed and client server databases, Distributed And Client Server Data... Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

How does the system cope up with a record crash, How does the system cope u... How does the system cope up with a record crash when recovery is going on after the first crash? Ans:  In a system the undo and redo operations are needed to be idempotent to c

What is specialization, What is Specialization? Specialization: Special... What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

Why is database redesign necessary, Why is database redesign necessary? ... Why is database redesign necessary? Database redesign is essential for two reasons. First, redesign is essential both to fix mistakes made during the initial database design. S

Example of grant create session to mca12, Example -GRANT CREATE SESSION TO ... Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi