Patty approaches you about a problem she has managing all of her
spreadsheets. She has placed a bunch of information about her business in a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13951-access-too-much-data-spreadsheet-create.html
huge spreadsheet that looks like this:
╔═════════╦═════ ══╦═════╦══════╦ ═════╦══════╦═══ ══╗
║ Custome ║ Address ║ City ║ State ║ Zipcode ║ Phone ║
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13951
Store ║
║ Name ║ ║ ║ ║
║ ║ ║
*═════════╬═════ ══╬═════╬══════╬ ═════╬══════╩═══ ══╣
║ Job ║ Description ║ City ║ State ║ Zipcode ║ Job
Notes ║
║ No. ║ ║ ║ ║
║ ║
*═════════╬═════ ══╩═════╬══════╩ ╦════╩═╦════════ ══╣
║ Payroll Date ║ Payroll ║ Check No. ║ Amount ║
Employee ║
║ ║ Classification ║ ║
║ ║
*═════════╬═════ ════════╬═══════ ╬══════╬════════ ══╣
║SSN ║ Employee ║ Title ║ Rate ║
Check Date ║
║ ║ Number ║ ║
║ ║
╚═════════╩═════ ════════╩═══════ ╩══════╩════════ ══╝
She needs a better solution. This is too much data, and it is too
complicated to maintain in a spreadsheet. Patty came back to you again
because you are so handy with computers. You are thinking about using a
database, but first, you must conceptualize the business problem in a way
that makes sense to a database.
What entities do you see here, and what relationship do you see among
entities?
What are the attributes of the entities?
What are the domains of values that could be stored under each attribute?
EqualacornLady
equalacornlady@yahoo.com 
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
