Question: Need help with these ERD diagrams got confused doing it To do this part of the homework, FIRST determine the entities. Then, look at the
Need help with these ERD diagrams got confused doing it

To do this part of the homework, FIRST determine the entities. Then, look at the respective ERDs shown in the book (for #2, 3, & 4 below). Once you see how relationships are depicted there, then attempt to re-draw the original ERD to account for the change suggested in each question. # 11 from Ch. 5, Pg. 174 of your text 1. 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. HoushaldName, Street, City, State, PostalCode, Balance, PatietNum PatientNans, (ServiceCode, Description, Fee, Date) The following dependencies exist in the Patient table: PatientNum HouseholdNum. HousholdName, Street, City, State, PostalCode, Balance, PatientName HouseholdNum HouseholdName, Street, City, State, PestalCode, Balance SeoiceCodeDescription, Fee PatientNum. SeviceCode ? Date # 12 from Ch. 5, Pg. 174 of your text 2. Using your knowledge of the college environment, 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. CourseNum Description, Term, Grade))
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
