G
Guest
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
huge spreadsheet that looks like this:
â•”â•â•â•â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•â•â•¦â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•—
â•‘ Custome â•‘ Address â•‘ City â•‘ State â•‘ Zipcode â•‘ Phone â•‘
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
(e-mail address removed)
spreadsheets. She has placed a bunch of information about her business in a
huge spreadsheet that looks like this:
â•”â•â•â•â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•â•â•¦â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•â•¦â•â•â•â•â•â•—
â•‘ Custome â•‘ Address â•‘ City â•‘ State â•‘ Zipcode â•‘ Phone â•‘
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
(e-mail address removed)