Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

7. Explain why retirees may be valuable as part-time employees.

Answered: 1 week ago

Question

3. Provide advice on how to help a plateaued employee.

Answered: 1 week ago