August 1999
DB212 : DATABASE MANAGEMENT SYSTEMS

QUESTION 3

Total Marks: 20 Marks

 Click here to access other questions

Click to access
SUGGESTED SOLUTIONS
for Question 3
(a) What is the Relational Database Model? Briefly explain the different components of the model.

 

 [7]
(b) The figure below shows a grade report that is produced at the end of each semester for students at a college. Prepare an Entity Relationship Diagram for the Grade Report. You may assume that each course is taught by just one instructor.

 

King Arthur's College
Grade Report
Spring Semester 1997
Name : John Smith
Campus address : 25 Lancelot Crescent		 Student Id: 961005123
Major: Computing
Course Id Title Instructor Instructor Location Grade
IS 350

BN 670

 DB Management

Systems Design

 Wood

Clarence

 C100

A102

 A

B

 

 [9]
(c) Derive the corresponding relations for the Entity Relationship Diagram you have given in part (b).

 

 [4]