Use Draw.IO https://www.draw.io/ to create an ERD based on the following information:• The RDBMS would be required to support the mall’s entire information system.• After data was stored in an RDBMS, it would provide a variety of archival andinformation services to PCM.• Database design must enable a product to be categorized, subcategorized, andsearched in three ways:1. Search products by categories.2. Search products individually by name or Product ID.3. Search products by stores.• The database must support the following six entities:1. Employees2. Stores3. Product categories4. Product subcategories5. Products (generally)6. Store products (products sold at a store).Identify the following:A. Primary KeysB. Foreign KeysC. Attributes- At least 5 per entityD. 1:N relationships
Use Draw.IO https://www.draw.io/ to create an ERD based on the following information:
• The RDBMS would be required to support the mall’s entire
• After data was stored in an RDBMS, it would provide a variety of archival and
information services to PCM.
•
searched in three ways:
1. Search products by categories.
2. Search products individually by name or Product ID.
3. Search products by stores.
• The database must support the following six entities:
1. Employees
2. Stores
3. Product categories
4. Product subcategories
5. Products (generally)
6. Store products (products sold at a store).
Identify the following:
A. Primary Keys
B. Foreign Keys
C. Attributes- At least 5 per entity
D. 1:N relationships
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 6 images
