Relational schema, Database Management System

Assignment Help:

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

Related Discussions:- Relational schema

Data dictionary, how to prepare a data dictionary for online examination sy...

how to prepare a data dictionary for online examination system for certified courses?

Explain about foreign key, What is Foreign Key Foreign Key: Sometimes...

What is Foreign Key Foreign Key: Sometimes we may have to work with an attribute that does not have a primary key of its own. To recognize its rows, we have to use the primar

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.

What is null, What is NULL? Simply NULL means not in value.

What is NULL? Simply NULL means not in value.

Explain the structured decomposition, Differentiate between the object orie...

Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas

What are the features of embedded sql explain, What are the features of emb...

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu

What are the storage types, What are the storage types? The storage typ...

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Explain displaying an er schema as an er diagram, Explain the conventions f...

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

Copy data from one database to another database, Copy Data from One Databas...

Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd