Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Question: We are going to model inventories that people may create. Draw an ER diagram that depicts the following situation. You must show all
Database Question:
We are going to model inventories that people may create. Draw an ER diagram that depicts the following situation. You must show all relevant entity sets, relationship sets, attributes and key constraints participation A person has a name and a unique personal id. People may be associated with (Live at) one or more addresses. Each address may be associated with one or more people. An address consists of a street address, a city, and a state. The combination of these attributes is unique for a given address. A person may create one or more inventories. Each inventory is created by one person on a specified date. An inventory has a name and a unique inventory id. Each inventory document is about one address. Each inventory is stored at an address. An address may store multiple inventories. Each inventory contains inventory items (I-items). An I-item has a unique inventory id, a value, and a room identifier indicates where the item is located). A piece of furniture has a description (such as table). A building has a description (such as garage) and number of rooms A vehicle has a color. Each piece of furniture, building and vehicle are I-items. An insurance company is located at one or more addresses, has a name and a unique insurance id. An I-item may be insured by exactly one insurance company. An insurance company may insure many I-items. Every I-item is owned by one or more people. People may own multiple I-items. There is a date that tells when a person bought an I-item that he ownsStep 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