You are working for a certain county and you want to convert the records of the county's
Question:
You are working for a certain county and you want to convert the records of the county's register of real property sales to an electronic database.
i. The county has several municipalities (towns, villages, cities, etc.), and for each one you want to store a name, a type (city, township, borough, etc.) and date of incorporation.
ii. Each municipality has numerous buildings, each of which is identified by a block number and lot number (each building within a given municipality has a unique combination of block number and lot number). For each building, you want to store a street address, zip code, and the year in which it was constructed. Assume that you do not have access to a zip code table.
Assume so far we have:
Assume so far we have:
Now additionally consider the following:
iii. Each building may have been sold many times; for each sale, you want to record its price, date, and the name of the person or company the building was sold to (you record owners' names using a single, long "name" field because some owners are corporations).
How do you add part iii. to the existent DB?
Add fields ?price?, ?seelingDate?, ?buyersName? to table BUILDING | ||
Create a new table SALE to store the information about each sale, and create the following relationship: [BUILDING] M---[]--- M [SALES] | ||
Create a new table SALE to store the information about each sale, and create the following relationship: [BUILDING] 1---- M [SALES] | ||
Create a new table SALE to store the information about each sale, and create the following relationships: [BUILDING] 1---- M [SALES] and [MUNICIPALITY] 1---- M [SALES] |