Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions

Question

as HighPerforming (out of which

Answered: 1 week ago