1. A manager manages a single store. A store always has a single manager. Based
ID: 3587938 • Letter: 1
Question
1. A manager manages a single store. A store always has a single manager. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.
2. Some classrooms can have a variety of equipment like projector, smart board, and video player. Other classrooms do not have any equipment. The college would like to track each piece of equipment based on it's current location. New equipment is placed into a room immediately. Each piece of equipment is in only one room at a time. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.
3. A video store stocks movie DVDs. Consider the ERD below. Assume COPY 187654 is a valid copy. What can you determine about the statement "COPY 187654 contains the first three Star Wars movies".
This statement could be true based on the ERD.
This statement could NOT be true based on the ERD.
4. A video store stocks movie DVDs. Consider the ERD below. Assume COPY 98745 is a valid copy. What can you determine about the statement "COPY 98745 is new and doesn't contain any movies".
This statement could be true based on the ERD.
This statement could NOT be true based on the ERD.
5. The ERD below is the initial design to track volunteers and the events they are assigned to. What can you determine about the statement "The volunteer named Jason Hanson has been assigned to 3 events".
This statement could be true based on the ERD.
This statement could NOT be true based on the ERD.
This statement could be true based on the ERD.
This statement could NOT be true based on the ERD.
ory. Has EQUIPMENT Aaagred TD EQUIPMENT Aasgnxi To STORE EQUIPMENT Assyw To--. STORE EQUIPMENT Acegnod Te--b MANAGER Has STORE MANAGR Works On HasExplanation / Answer
1. Option 4
Since it has one to one relation Option 4 is correct.
2. Option 4
Since Equipment assign to only one room at a time, so this condition satisfies with option 4.
3. This statement could NOT be true based on the ERD.
Because one Movie might have One or more copies . But each copy will have seperate ID. Based on this assumption the given statement is false because one copy ID can't have 3 movies.
4. This statement could NOT be true based on the ERD.
Because if copy ID exists there must be one copy of Movie.
5. This statement could be true based on the ERD.
Because according to the ER Diagram 0 or more Events has 0 or more Volunteers.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.