437Midterm_Fall2006_T1_solution

Relational database design and normalization total 20

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (Total 20 marks) Consider the following scenario. You have just been hired by Land and Water British Columbia Inc (LWBC) a corporation owned by the Province of British Columbia to manage crown land (among other duties) in British Columbia. You were given access to a Microsoft Excel spreadsheet (above) and asked to maintain the spreadsheet as part of your employment duties. This spreadsheet, you were told, contains information about Crown land available for sale in B.C. You are looking of course at fictitious data only for Vancouver and Burnaby (above) but all cities in BC are on this spreadsheet and they are identical in structure and nature to Vancouver and Burnaby. There are no buildings or other assets standing on these lots of land. (Continue on next page) COMM 437 Mid-Term Exam (Fall 2006 Term 1) Page 5 of 7 Required: 1. Prepare (draw) the relational database design that will replace this spreadsheet in FIRST NORMAL FORM, making sure that you, a. Identify the primary key. [5%] City, Lot_number b...
View Full Document

Ask a homework question - tutors are online