How to approach the database design question

In other words they represent the real primary key

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: is, identify the primary keys (try and avoid simply assigning an arbitrary primary key like “StoreID”. These kinds of keys are actually candidate keys. In other words, they represent the real primary key. For example, which table is better below? Left or right hand side? I think Left. 17. It is expected that you need to revise your design at least two or three times as you try to “fit” each piece of data into the various tables you have. So please do NOT use a pen (or go into the details too soon) as there will be lots of erasing (editing)! 18. I sincerely hope this document helps you do very well in the assignment. Good luck! Copyright © May 2007 – William Tan, Sauder School of Business Page 3 of 3...
View Full Document

This note was uploaded on 01/26/2014 for the course COMM 335 taught by Professor Y.m.cheung during the Fall '12 term at UBC.

Ask a homework question - tutors are online