Database-1-System I.pdf

TERTIARY AND VOCATIONAL EDUCATION COMMISSION
COMMON WRITTEN EXAMINATION

All rights reserved.
Tertiary and Vocational Education Commission
NVQ Level 05 –Semester I
Information & Communication Technology

Database System I K72T001M01 Three Hours


Answerany four (04) questions.



Question 01
1.) List and explain any four advantages of DBMSover File Management system.(Marks07)
2.) Explain the following terms briefly. (Marks 12)
a). Attribute
b). Entity
c). One-to-many relationship
d). primary key
3.) What is logical data independence and why is it important? (Marks 06)

Question 02
1) Suppose you are given a relation R= (A,B,C,D,E) with the following functional
dependencies: {CE →D,D→B,C →A}.
a) List all candidate keys of R. (Marks 03)
b) Identify the best normal form that R satisfies (1NF, 2NF, or 3NF).(Marks 03)

2.) Describe the characteristics of a table in third normal form (3NF). (Marks 04)

3) Examine the table shown below. (Marks 15)

staffNo branchNo branchAddress name position hoursPerWeek
S4555 B002 City Center Plaza, Ellen Assistant 16
Seattle, WA 98122 Layman
16 – 14th Avenue, Ellen
S4555 B004 Assistant 9
Seattle, WA 98128 Layman
City Center Plaza, Dave
S4612 B002 Assistant 14
Seattle, WA 98122 Sinclair
16 – 14th Avenue, Dave
S4612 B004 Assistant 10
Seattle, WA 98128 Sinclair

(a) Why is this table not in 2NF? (Marks 03)