Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help to fill in the following questions based on normalisation Examine the relation given below which contains data about students enrolled in various courses

Need help to fill in the following questions based on normalisation

image text in transcribed
Examine the relation given below which contains data about students enrolled in various courses during a specific year. Carefully analyse the relation and answer the following questions: Stud_ID LName FName Crse_ID Crse_Name Grade | Lect_ID |Lect_Lname Lect_Fname Lect_Office Semester 001 Rose Johnson ENGO1 ENGLISH A LOO1 Ruger john 102 Sem1 001 Rose Johnson GERO1 GERMAN B L002 Findling Holger 101 Sem2 002 Anthony Joshua ENGO1 ENGLISH A L001 Ruger John 102 Sem1 002 Anthony Joshua GERO1 GERMAN B L002 Findling Holger 101 Sem2 003 May Parker GERO1 GERMAN A L002 Findling Holger 101 Sem2 004 Susanna Grant ITA01 ITALIAN B L003 Fresco Luise 103 Sem2 Table 1 a) In what level of normalisation is the above relation (Table 1)? Identify the primary key attributes. Briefly justify your answer. b) Identify all the dependencies using a dependency diagram. c) Using the data shown in Table 1 derive a set of relations in third normal form (3NF). Clearly explain each step of normalisation - 1NF, 2NF, and 3NF. Show all primary keys in each relation with a solid underline and foreign keys with a dashed underline. d) Draw an Entity Relationship Diagram (ERD) from the 3NF relations and include all attributes, primary keys, foreign keys, cardinality, and participation

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

Calculus I With Integrated Precalculus

Authors: Laura Taalman

1st Edition

1464153027, 9781464153020

More Books

Students also viewed these Mathematics questions