BCS 260 Lecture Notes - Lecture 4: Third Normal Form
Document Summary
#3 says to add in service_fee (propertyid, serviceid, Description in two places, amount in two places and propertyid in all three tables. Look at data above, and note that (property, service and the date) determine amount. Yes, but usually only if we have multiple overlapping composite candidate keys. We run a brand that franchises three different kinds of restaurants (pizza, burger, mexican). We have rules about who can open our restaurants where. We sell the right to a town to a person, and that gives them the exclusive right to open one, two or all three of the cuisines in the town. They can also pay for another town and open more restaurants elsewhere. We have a database that records the restaurants we have: (franchisee*, town, cuisine, a sequence number**) ** the sequence number is the number of this restaurant belonging to that franchisee.