Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To remove the anomalies found in Q1, you should break down the table in Question 1 into 4 new tables. (30 points). Show those 4
To remove the anomalies found in Q1, you should break down the table in Question 1 into 4 new tables. (30 points). Show those 4 tables.
Use a format similar to the table above (i.e., column names in the heading & data in multiple rows)
This will be your tables
CUSTOMER: 3 columns + 3 rows
COURSE: 4 columns + 3 rows
ROOM: 2 columns + 2 rows
ENROLLMENT: 3 columns + 5 rows
\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline CustlD & CustName & CustPhone & CourseNum & CourseName & RoomNum & \( \begin{array}{c}\text { Rom_capacit } \\ \mathrm{y}\end{array} \) & Fee & Score \\ \hline 1000 & Smith & 7426123 & 201 & Pythan & R 200 & 50 & $20 \\ 0 \end{tabular}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