- 28 Sep, 2020
- 0 Comments
- 1 Min Read
ERD
Objectives
1. Produce an ERD in 3NF from source documents and client input.
2. Demonstrate initial table, first, second, and third normal forms by showing the database tables as they exist in each of the three normal forms
3. Merge ERD’s from different views to create one ERD of the final solution
Requirements
Given the source documents and company description create a database design demonstrating the concept of normalization, showing all the attributes as they exists in the initial table, 1NF, 2NF and 3NF. You will do this for each of the three views and create an ERD for each view in 3NF, as well as the final merged ERD.
The Company
Stuff B Gone is a company that sells customers items for them. In return for this service they collect a fee for each item they sell for the customer. Currently Stuff B Gone sells customers items through physical stores, Facebook groups/Marketplace, and Kijiji.
As an incentive to thank repeat customers, they have a reward program where customers can get discounts on their consignments.
In order to provide the best experience for the customers, all staff are able to take training where they can improve their skills.
Consignment Agreement View (8 marks)
• A Consignment agreement is the information that Stuff B Gone collects from the customer to be able to sell their items for them.
• While the customer will receive the full selling price of their items they are charged by Stuff B Gone for their services. The amount that Stuff B Gone charges for selling the customers items for them depends on the category the item is in. For example, if the category cost for an item is $2.00 then the charge will be $2.00 to sell that item for the customer. Examples of Categories are electronics, jewellery, etc…
• Line # identifies each item on a particular consignment.
• Start Price and Low Price are the starting selling price for the item and Low Price is the lowest price that the customer is willing to sell the item for.
• Only one staff member works on a consignment.
• A customer is only of one type (individual, business, charity, etc…)