Course: Database-I (3410) Semester: Autumn 2018 Level: BS (CS) solved assighnment

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.

You may like these posts