Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an Enhanced ER diagram for the below scenario. Identify entities including supertypes and subtypes, attributes of each entity, relationships, keys, and the minimum and
Draw an Enhanced ER diagram for the below scenario. Identify entities including supertypes and subtypes, attributes of each entity, relationships, keys, and the minimum and maximum relationship cardinalities. Amazon Online wants to record details about the following important entities and their attributes: PRODUCT: ProdID (identifier), PDesc, Color, and Price. PACKAGE: PackID (identifier), Weight, and Destination. A PRODUCT may be contained in a PACKAGE or may not be in the PACKAGE. But, a PACKAGE must contain one or more PRODUCTS. The Quantity attribute is recorded every time a PRODUCT is contained in a PACKAGE. A PACKAGE has different types. Some of them are: DRY_GOODS with a MaxExpire attribute, and EQUIPMENT with a Dimension attribute. A package may or may not be one of these subtypes. However, a package can only be a member of exactly one subtype
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