Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q2: Describe and illustrate the process of normalizing the below table to 3NF. State any assumptions you make about the data shown in this table.

image text in transcribed

Q2: Describe and illustrate the process of normalizing the below table to 3NF. State any assumptions you make about the data shown in this table. [15 Marks] s_ids_fname S_Iname S_address D_name D_id |D_HOD C_id C Name Tid T Name T_Address Designation Grade Si Ali Khan Lahore CS S2 Sara Ahmad Lahore CE D1 Dr. Zulfiqar Habib C1 Database Systems 11 Dr. Sana Lahore Assistant Professor A C5 Software Engineering T2 Dr. Ali Karachi Assistant Professor B+ C3 Artificial Intelligence T3 Dr. Hamid Islamabad Associate Professor B- D2 Dr. Ejaz Ansari C1 Database Systems T1 Dr. Sana Lahore Assistant Professor B- C2 Networking T4 Dr. Asad Sialkot Associate Professor B C4 JOOP T5 Ms. Rabia Sialkot Lecturer B+ |D3 Dr. Ghulam Rasool |C6 Professional Practices|T7 Mr. Tayyab Peshawar Lecturer JA S3 Ayaz Mazhar Lahore SE S4 Saima Rana Islamabad CE C7 Data Structures T8 Ms. Tuba Lahore Lecturer A- C8 OOAD T9 Ms. Maryiam Lahore Lecturer B+ D2 Dr. Ejaz Ansari C1 Database Systems T1 Dr. Sana Lahore Assistant Professor B- C5 Software Engineering T2 Dr. Ali Karachi Assistant Professor B C3 Artificial Intelligence T3 Dr. Hamid Islamabad Associate Professor A- C10 Automata T6 Ms. Mahrukh Lahore Lecturer B+ D1 Dr. Zulfiqar Habib C2 Networking T4 Dr. Asad Sialkot Associate Professor A D3 Dr. Ghulam Rasool |C8 2009 T9_Ms. Maryiam Lahore Lecturer B- S5 Anees Mirza Faisalabad CS S6 Maria Nazeer Sialkot SE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions