Mid-term Part 2 - Written Analysis CSCI 1320 Database Fundamentals 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 your one page MS Word pdf report include the following: 1. Table(s) needed 2 Fields for each table (list 'primary key field' first) 3. Add a page footer with your full name, date prepared, and filename Name at least 7 additional fields. Which field or fields shown below do not belong in a table? Explain why. Identify the primary key for each table by underlining. Draw the tables showing relationships between tables. i.e. E-R diagram (joins between tables, relationships). 23' > > :3 Develop 3 questions to ask client at your face-to-face meeting next week that will assist in rening the prototype. LastName FirstName lnvoiceDate lnvoiceltem Quantit Price Tax Total 131432012 3000 3249 12FIOI2012 Dinin Table 1000 1083 121232012 Book Shelf 20-75 270.75 I3Em- 121232012 131410012 20-75 270.75