QuestionQuestion

Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household.

Patient (HouseholdNum, HouseholdName, Street, City, State, Zip, Balance, PatientNum, PatientName, (ServiceCode, Description, Fee, Date) )

The following dependencies exist in the Patient table:

PatientNum → HouseholdNum, HouseholdName, Street, City, State, Zip, Balance, PatientName
HouseholdNum → HouseholdName, Street, City, State, Zip, Balance
ServiceCode → Description, Fee
PatientNum, ServiceCode → Date

The following exercises are based on the Premiere Products database.

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice) ).

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

question 1 :
Patient (HouseholdNum, HouseholdName, Street, City, State, Zip, Balance, Patient-Num, PatientName, (ServiceCode, Description, Fee, Date) )

3rd form :
Patient( PatientNum, HouseholdNum, HouseholdName, Street, City, State, Zip, Balance, PatientName, ServiceCode)...

By purchasing this solution you'll be able to access the following files:
Solution.pdf.

$13.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats