ABC department store keeps information on departments, products, and employees. For each department, the department ID, name and office phone extension are stored. For each employee, the employee ID, and name are stored. A department can have many employees and each employee can be assigned to multiple departments. Each department is managed by one employee. Each department sells many products and each product is sold by only one department. Products can be shoes, clothes, or other miscellaneous. The product ID and price are stored for each product. No additional data is stored for the miscellaneous products. For all shoes, shoe type, shoe color and shoe size are also stored. For all clothes, the season (one of: winter, spring, summer, year-round) is stored. Clothes can be shirts, pants or dresses. For shirts, collar size, sleeve size and type are stored. For pants, waist size, length and type are stored. For dresses, size, and type are stored. Draw the Crow’s foot ERD (including all attributes, PKs, FKs, and subtypes/supertypes as appropriate) for the data model described above. Ensure that any M:N relationships are converted to 1:M. Assume that name is atomic. Use appropriate names for all attributes.
ABC department store keeps information on departments, products, and employees. For each department, the department ID, name and office phone extension are stored. For each employee, the employee ID, and name are stored. A department can have many employees and each employee can be assigned to multiple departments. Each department is managed by one employee. Each department sells many products and each product is sold by only one department. Products can be shoes, clothes, or other miscellaneous. The product ID and price are stored for each product. No additional data is stored for the miscellaneous products. For all shoes, shoe type, shoe color and shoe size are also stored. For all clothes, the season (one of: winter, spring, summer, year-round) is stored. Clothes can be shirts, pants or dresses. For shirts, collar size, sleeve size and type are stored. For pants, waist size, length and type are stored. For dresses, size, and type are stored. Draw the Crow’s foot ERD (including all attributes, PKs, FKs, and subtypes/supertypes as appropriate) for the data model described above. Ensure that any M:N relationships are converted to 1:M. Assume that name is atomic. Use appropriate names for all attributes.
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 2.11CP
Related questions
Question
ABC department store keeps information on departments, products, and employees.
- For each department, the department ID, name and office phone extension are stored.
- For each employee, the employee ID, and name are stored.
- A department can have many employees and each employee can be assigned to multiple departments.
- Each department is managed by one employee.
- Each department sells many products and each product is sold by only one department.
- Products can be shoes, clothes, or other miscellaneous.
- The product ID and price are stored for each product. No additional data is stored for the miscellaneous products.
- For all shoes, shoe type, shoe color and shoe size are also stored.
- For all clothes, the season (one of: winter, spring, summer, year-round) is stored.
- Clothes can be shirts, pants or dresses.
- For shirts, collar size, sleeve size and type are stored.
- For pants, waist size, length and type are stored.
- For dresses, size, and type are stored.
Draw the Crow’s foot ERD (including all attributes, PKs, FKs, and subtypes/supertypes as appropriate) for the data model described above. Ensure that any M:N relationships are converted to 1:M. Assume that name is atomic. Use appropriate names for all attributes.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage