Relational schema, Database Management System

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







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
Related Questions
Use the IRIS dataset that comes with Weka to compare the classification performance of the following algorithms. 1. NaiveBayesSimple 2. MultiLayerPerceptron J48 (

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

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Which database level is closest to the users? External database level is closest to the users.

basic structure of xml

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out


Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t