Question
to further demonstrate your knowledge of normalization, assume that a proposed (badly structured) relation for the University Database database has the following structure. matricNo name
to further demonstrate your knowledge of normalization, assume that a proposed (badly structured) relation for the University Database database has the following structure. matricNo name sex moduleTitle modulestartDate performance flatNo address 00/5021 Mcleod, A F BITS 27/09/01 Pass F001 6 lady Lane, Paisley 00/4647 Smith, J M Software Dev. 01/10/01 Pass F001 6 lady Lane, Paisley 01/4670 Owen, M F FDBS 27/09/01 Fail F002 28 New Str, Paisley 01/4765 Smith, J M OOAD 01/10/01 Pass F003 28 New Str, Paisley 00/5021 Mcleod, A F FDBS 27/09/01 Pass F001 6 lady Lane, Paisley 00/4647 Smith, J M FDBS 27/09/01 Fail F001 6 lady Lane, Paisley Identify the functional dependencies represented in this relation and demonstrate the process of normalizing this relation into 3NF relations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started