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 primary key, What is Primary key? Primary Key - Primary key i... What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

Difference among a primary index and a secondary index, What is the differe... What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Domains, A domain is a set of permissible values that can be given to an at... A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

Define and differentiate among ordered indexing and hashing, Define and dif... Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every

Why were functional methods fashionable in early days, Why were functional ... Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

List some instances of collection types, List some instances of collection ... List some instances of collection types? a) sets b) arrays c) multisets

Write query to insert data in student table, Consider student (std_id, std_... Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Ordering of tuples, In a relation, tuples are not inserted in any definite ... In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

One to many - relationship cardinality, One-to-many : An entity in A is rel... One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

What is management system, What is Management System? A management syst... What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet