Course: Database-I (3410) Semester: Autumn 2018
Level: BS (CS) Total Marks: 100
Pass Marks: 50
ASSIGNMENT No. 1
Note: All questions are compulsory. Each question carries equal marks.
Q. 1 (a) What is the difference between data and information? Elaborate different types of data that we need to store. (20)
(b) Define database and database management system.
(c) Describe the advantages of database approach over the legacy filing system.
Q. 2 Differentiate the following: (20)
(a) Generalization and Categorization
(b) Entity and Relationship
(c) Strong Entity and Week Entity
(d) Data and Metadata
Q. 3 The figure below shows a class list for AIOU. Convert this user view to a set of 3NF relations. Assume the following: (20)
a) An instructor has a unique location.
b) A student has a unique major
c) A course has a unique titl
Allama Iqbal Open University
Class List – Spring 2013
| |||
Course Code: 1431
Course Title: Fundamental of Computers
Instructor Name: ABC
Instructor Location: R-0001
| |||
Student ID
|
Student Name
|
Major
|
Grade
|
25210
|
AA
|
SE01
|
A+
|
23735
|
BC
|
DF02
|
B+
|
27265
|
CD
|
SE03
|
C+
|
27399
|
DE
|
DB04
|
D+
|
...
|
...
|
...
|
...
|
Q. 4 Draw E-R Model for the following scenario: (20)
A university offers a variety of programs at different levels, e. G., graduate, post graduate, etc. A large number of courses are offered in each program. Each course may have one or more courses as prerequisites. A faculty member teaches one or more courses and one course may be taught by more than one faculty members. The model should be able to preserve the complete information about the courses. The model should be able to preserve the complete information about the courses, programs and faculty members.
Q. 5 (a) Define logical database model. What are its types? Explain it in detail with the help of suitable examples. (20)
(b) Define physical database design. Explain its main components and major objective in detail.
Post a Comment