The table belowcontains sample data department whose primary key is Dept_No, and
ID: 3616020 • Letter: T
Question
The table belowcontains sample data department whose primary key is Dept_No, andsuppose that we extend it by including the Dlocations attribute asshown in DEPATMENT table. We assume that each department can have anumber 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
INSTRUCTORLOCATION
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. Youare required to convert it into third normal form (3NF).
Dept_Name
Dept_No
Dmgr_id
Dlocations
Research
10
331009596919
{ Islamabad, Multan, Lahore }
Administration
4
331005678451
{ Karachi }
Headquarters
1
331015685741
{ Peshawar }
Explanation / Answer
Dept_Name
Dept_No
Dmgr_id
Dlocations
Research
10
331009596919
Islamabad
Research
10
331009596919
Multan
Research
10
331009596919
Lahore
Administration
4
331005678451
Karachi
Headquarters
1
331015685741
Peshawar
Please RateDept_Name
Dept_No
Dmgr_id
Dlocations
Research
10
331009596919
Islamabad
Research
10
331009596919
Multan
Research
10
331009596919
Lahore
Administration
4
331005678451
Karachi
Headquarters
1
331015685741
Peshawar
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.