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

Write a program within embedded sql to associative relation, Write a progra...

Write a program within embedded SQL to associative the total trip expenses of the salesman named ‘John' for the relations. EXEC SQL BEGIN DECLARE SECTION; long total_expenses;

Field, examples of fields in a database

examples of fields in a database

Key to represent relationship between tables is called, Key to represent re...

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

Explain pipelining, Explain pipelining.        Ans: In order to describ...

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Database recovery and security, Database Recovery And Security Introdu...

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage...

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

Can you scan double-sided documents and remove blank pages, Can you scan do...

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

Data flow diagram of structured analysis and design, From SAD to OOAD (Stru...

From SAD to OOAD (Structured Analysis and Design (SAD) to Object Oriented Analysis and Design (OOAD). We will find here how we can map various models in SAD to different model

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