Question
Consider the table: STUDENT (Number, Name, Dorm, RoomType, DormCost, Club, ClubCost, Sibling, Nickname) Assume that students pay different dorm costs, depending on the type of
Consider the table:
STUDENT (Number, Name, Dorm, RoomType, DormCost, Club, ClubCost, Sibling, Nickname)
Assume that students pay different dorm costs, depending on the type of room they have, but that all members of a club pay the same cost. Assume that students can have multiple nicknames.
a. State any multivalued dependencies.
b. State the functional dependencies.
c. Transform this table into two or more tables such that each table is in BCNF and in 4NF.
State the primary keys, candidate keys, foreign keys, and referential integrity constraints.
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
DB2 11 The Database For Big Data And Analytics
Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler
1st Edition
