Question: I have given the table from Assignment 1 Property ID rightarrow Property Name, Type, Street, City, Zip (The PropertyID will provide the general address or

I have given the table from Assignment 1 Property ID rightarrow Property Name, Type, Street, City, Zip (The PropertyID will provide the general address or the property and the Type) Service ID rightarrow Description (The Service D defines description) Property ID, Service ID, ServiceDate rightarrow Amount (PropertyID and ServiceID will determine the amount charged to the customer) We also assume that there could be two buildings in different areas with same name. Also even if the building names are same they may be of different types. Based on above functional dependency normalize the above table. Clearly show first, second and third normal form
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
