Question: Please help me check if this answer for a database assignment is correct. Your cousin is opening a used clothing store, where items are sold

Please help me check if this answer for a database assignment is correct. Your cousin is opening a used clothing store, where items are sold on
consignment. He needs a database to track the store inventory items. When an item
is sold, the amount of the consignment (25% of the sales price) and the person to
whom it should be paid will be recorded.
Create a set of tables for the company in 3NF. Represent your answer in DBDL.(i.e.
give table name and fields. Underline the primary key.) Draw an entity-relationship
diagram. (10 pts.)
Person (PersonID, NameID, AddressID, PhoneID)
Item (ItemID, DescriptionID, ConsignorID, PriceID)
Sale (SaleID, ItemID, SaleDateID, SalePriceID)
Identify any assumptions you made that will assist in my understanding of your
solution. (Must be included)
Please help me check if this answer for a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!