The table belowcontains sample data department whose primary key is Dept_No, and
ID: 3616064 • 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).
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
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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.