How to approach the database design question

That is a figure out which data item goes to which

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: would be your answer? I don’t know boss?) 11. From above, you see that you have to do two things at the same time. That is, a. figure out which data item goes to which table and, b. what is the connectivity between the entities – is it one-to-one, one-tomany, or many-to-many? It might be helpful to refer to my online tutorial on WebCT at this point. 12. From the steps above, you might discover you need to create other tables. 13. E.g. if we need to track calls, then we need another table for Calls and have it in a one-to-many relationship with the Clie...
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 The University of British Columbia.

Ask a homework question - tutors are online