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

Why do you go for sorting your query results, Why do you go for sorting you...

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Cartesian product, If R1 and R2 are two relations or functions, then the re...

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Describe the concepts of structural semantic data model, Question 1 List a...

Question 1 List and explain various Normal Forms. How BCNF differs from the Third Normal Form and 4th Normal forms? Question 2 Describe the concepts of Structural Semantic Da

What are ways of finding out derived attributes, What are ways of finding o...

What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update

Method of analyzing association traversal, Analyzing Association Traversal ...

Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,

Compare the two log based recovery schemes, Compare the two log-based recov...

Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost.    Ans:  There are two types of log based recovery techniques: deferred update

Define the term- actors and data stores, Define the term- Actors and Data...

Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

Define about the stored procedure, Define about the Stored Procedure - ...

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Data base design, how to design a bakery business in data base

how to design a bakery business in data base

Explain the need of parallel database, Probelm: a) In the context of OO...

Probelm: a) In the context of OODBMS, define the following terms with appropriate examples. (i) Object class. (ii) Abstract class. (iii) Aggregation. (iv)

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