Relational Database Exercise:
You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future.
You received an email from the client with the list shown below. Currently, this list tracks their daily business. To prepare for the meeting with the client, you develop a first draft prototype.
In a one page MS Word report include the following:
1. Table(s) needed
2 Fields for each table
Name at least 7 additional fields.
Which field or fields shown below do not belong in a table? Explain.
Identify the primary key for each table.
Draw the tables showing relationships between tables.
Develop 3 questions to ask client at your face-to-face meeting next week that will assist in refining the prototype.
|
LastName
|
FirstName
|
InvoiceDate
|
InvoiceItem
|
Quantity
|
Price
|
Tax
|
Total
|
|
Shire
|
Robert
|
12/14/2012
|
Antique Desk
|
1
|
3000
|
249
|
3249
|
|
Goodyear
|
Katherine
|
12/10/2012
|
Dining Table
|
1
|
1000
|
83
|
1083
|
|
Tierney
|
Doris
|
12/23/2012
|
Book Shelf
|
1
|
250
|
20.75
|
270.75
|
|
Anderson
|
Donna
|
12/22/2012
|
Desk Lamp
|
1
|
45
|
3.74
|
48.74
|
|
Shire
|
Robert
|
12/14/2012
|
Antique Chair
|
2
|
125
|
20.75
|
270.75
|