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
Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

What is the function of IO/M signal in the 8085? It is a status signal. It is used to differentiate among memory locations and I/O operations. When this signal is low (IO/M = 0

Determine the Strong and Weak Entity Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and a

What is an Operand? The data on which the operation is to be performed is known as an Operand

1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

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

Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager