Question
2. Create an ER Diagram for the following scenario ( 20 Points ) A website selling socks needs a database created. They have suppliers that
2. Create an ER Diagram for the following scenario ( 20 Points ) A website selling socks needs a database created. They have suppliers that are unique by corporation ID. The suppliers also have a name, address, and phone. They have a derived attribute of total sales. There are many different models of socks available. Each sock style has an attribute called color, a model #that is partially unique by supplier, each sock model also has total sales. A supplier offers many types of socks, but a model of sock can only be offered by one supplier. If a sock model does not have a supplier then it cannot exist on its own. Materials are unique by material id. Materials also have a name. Each sock model can be made up of many materials, but must have a relationship with at least one material. Each material can be used by 0 to many models. The sock/material relationship has a percentage of how much material is used in the sock. Tax information is unique by Federal tax ID but also a state tax identifier. Each supplier has one and only one Tax Information, and the Tax Information likewise is related to only one supplier.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started