Question 1: The table below contains sample data department whose primary key is Dept_No, and suppose that we extend it by including the Dlocations attribute as shown in DEPATMENT table. We assume that each department can have a number of locations (As given in Dlocations column).
DEPARTMENT
Dept_Name Dept_No Dmgr_id Dlocations
Research 10 331009596919 { Islamabad, Multan, Lahore }
Administration 4 331005678451 { Karachi }
Headquarters 1 331015685741 { Peshawar }
Convert this table to a relation in first normal form (1NF).
Question 2: Consider the following relation
COURSE INSTRUCTOR
COURSE
ID COURSE
TITLE INSTRUCTOR
NAME INSTRUCTOR LOCATION
IS 350 Database Mgt Codd B 104
IS 465 System Analysis Parsons B 137
Acctg 201 Fund Acctg Miller H 310
Mktg 300 Intro Mktg Mick B 212
The relation is in Second normal form (2NF) and there are modifications and deletion anomalies exist. You are required to convert it into third normal form (3NF).
Posts
No comments:
Post a Comment