Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercises on Normalization Given the relation and functional dependencies; Example: STUDENT ( StudentNo , Name, PrimaryMajor, School ) FDs: StudentNo - > Name, PrimaryMajor, PrimaryMajor
Exercises on Normalization
Given the relation and functional dependencies;
Example: STUDENT StudentNo Name, PrimaryMajor, School
FDs: StudentNo Name, PrimaryMajor, PrimaryMajor School
Candidate key is StudentNo, as if we know StudentNo we can find all other attributes from it
The original relation is in NF There are no partial FDs so it is in NF at least. It is not in NF as
there is a transitive FD StudentNo PrimaryMajor School
NF relations:
STUDENT StudentNo Name, PrimaryMajor
MAJOR PrimaryMajor School
Given the following relation and functional dependencies:
a Identify the candidate keys and partial functional dependencies among attributes If any
b Explain which NF the relation is in
c Convert the relation into a relation or set of relations in at least NF
Q ENROLS StudentNo Name, UnitCode, UnitName, Grade
FDs: StudentNo Name
UnitCode UnitName
StudentNo, UnitCode Grade
Q Each loan application is by one customer but each customer may make many applications
ApplicNo Customer Address Date Appr
X JoeBlog Perth
X Vicki Sydney
Y JoeBlog Perth
Converting the table to a relation
Q: Given the following table:
Part No Description Vendor Address UnitCost
Logic Chip Fast Chips Perth
Smart Chips Sydney
Memory chip Fast Chips Perth
Quality Chips Sydney
Smart Chips Sydney
a Convert this table to a single relation called PARTSUPPLIER in first normal form. Illustrate the
relation with the same sample data.
b List the functional dependencies in PARTSUPPLIER and identify the candidate keys
c Convert PARTSUPPLIER to a set of relations in at least third normal form.
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