Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions