Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Question

stretch8302
stretch8302 


11. 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 Attachments
Tags Clarifications

Answers

Dentist Database

dickersonka
dickersonka 



Attached is the 3NF dentist database schema. Attachments
Dentist.txt (1 K) Download Preview
Household(HouseholdNum, HouseholdName, Street,

Screenshots
Purchase Answer