You have been assigned to a new development team. A client is requesting a relat

Question

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: Table(s) needed Fields for each table 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. > 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.

Explanation / Answer

Following tables would be needed to keep the given information:

In the given table in question, we can see that the tax has been calculated on a rate of 8.3% constant.. hence the tax rate can be kept in properties and tax can be calculated at run time using the invoices table.. Similarly, total amount for the invoice can also be calculated at run time… So these fields will not be present in the table

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.