How to approach the database design question

This is because each client record can only appear

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: table means the client can only ever call you ONCE in their lifetime association with your company. This is because each client record can only appear once in the Client table (ClientID is the primary key and call date and time becomes a one to one relationship). See below. Ask yourself this question: if the client calls again, where do I put this information? Obviously, the table Client is the WRONG table to place DateOfCall (some students might say, “I’ll just over-write the previous entry.” But what if your boss asks you, “how many times have this client called us before?” What...
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