تم الحل ✓
categoryقواعد البيانات وإدارة البيانات
schoolبكالوريوس
event_available2026-07-15
السؤال
Transcribed Image Text:
ABC department store keeps information on departments, products, and employees.
•
For each department, the department ID, name and office phone extension are stored.
7 For each employee, the employee ID, and name are stored.
3
B
.
W
•
•
.
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) for the data model described above. Ensure that any
M:N relationships are resolved and all attributes are atomic. Use appropriate prefixes for all attributes.
check_circle الجواب — حل مفصل خطوة بخطوة
hourglass_top
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.