The following data is to be used in developing a new database system for a ficti
ID: 2659109 • Letter: T
Question
The following data is to be used in developing a new database system for a fictitious company:
Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why not? Identify what data should be included in each table.
The following data is to be used in developing a new database system for a fictitious company: Customer name Customer address Date of purchase Amount of purchase Item purchased Quantity purchased Salesperson Invoice number Item number Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why not? Identify what data should be included in each table.Explanation / Answer
CUSTOMER TABLE
Customer Name
Customer Address
Date of Purchaase
Amount of Purchase
STOCK TABLE
Invoice NO.
Item Purchased
Quantity Purchased
SALE DETAIL
Invoice no.
Sales Person
Item no.
INVOICE No. is present in all the tables so that relationship can be established among each tables. Another reason is that Invoice no. are always unique.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.