Question 1: The table below contains sampledata department whose primary key is
ID: 3616051 • Letter: Q
Question
Question 1: The table below contains sampledata department whose primary key is Dept_No, and suppose that weextend it by including the Dlocations attribute as shown inDEPATMENT table. We assume that each department can have a numberof 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 aremodifications and deletion anomalies exist. You are required toconvert 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
As per cramster Policy only one question per post,,
Please submit another thread for the second question
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.