1. 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.

2. A league can have 16 teams. A league needs at least one team to get started. Each team belongs to one and only one league. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

3. A museum may have a variety of art objects. It may have any number of paintings or it may have no paintings at all. Each painting is located at a single museum. However over time a painting can be loaned to other museums and this needs to be tracked. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

4. A bank employee works at a bank branch office. Different offices are open on different days and times. For scheduling flexibility an employee could be assigned to any of several branch offices over time. A branch office is not created until an employee is ready to work there. Branches are of different sizes so some branches have one employee and some branches have many employees. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

5. A professional player is initially drafted and signed by a single team. Over time that player can be traded and signed by other teams. In addition, a team can have anywhere from 1 to 60 players. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

6. A league can have 16 teams. A league needs at least one team to get started. Each team belongs to one and only one league. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

7. 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.

8. 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.

9. 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.

10. 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.

11. 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.

12. Consider the ERD below. Assume John Doe is a valid employee and AZ Construction is a valid project. What can you determine about the statement "John Doe works on only the AZ Construction project. He is the only employee on this project"?

	This statement could NOT be true based on the ERD.
		This statement could be true based on the ERD.

13. Tunes R Us creates CDs containing music. Consider the ERD below. Tommy Tuple is a valid recording artist. What can you determine about the statement "Tommy Tuple has recorded 2 different CDs."

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

14. Consider the ERD below. Assume "Databases as Art" is a valid book. What can you determine about the statement "The author for Databases as Art is unknown so no author will be used for this book."

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

15. Consider the ERD below. Assume John Doe is a valid employee and AZ Construction is a valid project. What can you determine about the statement "John Doe works on only the AZ Construction project. He is the only worker on this project"?

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

16. Consider the ERD below. Assume John Doe is a valid employee. What can you determine about the statement "John Doe is not assigned to work on any projects".

	This statement could NOT be true based on the ERD.
		This statement could be true based on the ERD.

17. Consider the ERD below. Assume John Doe and Jane Smith are valid employees. Further assume AB Construction is a valid project. What can you determine about the statement " The AB Construction project is staffed by John Doe and Jane Smith".

	This statement could NOT be true based on the ERD.
		This statement could be true based on the ERD.

18. Tunes R Us creates CDs containing music. Consider the ERD below. What can you determine about the statement "Some CDs are new and do not have any artists recorded on them yet."

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

19. Tunes R Us creates CDs containing music. Consider the ERD below. Assume "Database Rock" is a valid CD. What can you determine about the statement "The 'Database Rock' CD has music from three different artists".

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

20. The ERD below is the initial design to track events and the dates on which they are scheduled. Using the ERD, what can you determine about the statement "There were 5 events on July 4, 2012."

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

21. A video store stocks movie DVDs. Consider the ERD below. Assume "Databases as Art" is a valid movie. What can you determine about the statement "The video store has no copies of the 'Databases as Art' movie".

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

22. Consider the ERD below. Assume John Doe is a valid author. What can you determine about the statement "John Doe has not written any books".

		This statement could be true based on the ERD.
	This statement could NOT be true based on the ERD.

23. We want to track people and their relatives. Everyone has a relative - at least a mom while some people have a bunch of relatives such as brother, sisters, and cousins. Everyone is also a relative to someone else. For example, a male could be a son and a female could be a daughter. Everyone is a relative to at least one other person. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

24. A component product or products can be used to make other finished products. For example, a product like wheels can be used to make different types of bicycle products - 20 inch wheels could be used to make a men's bicycle product or a woman's bicycle product. Also a combination of products could be used to make a product. For example the combination of 20 spokes, one 20 inch rim, one inner tube, and one outer tube can be combined to make a 20 inch wheel. Some products are not used to make other products. For example, a finished bicycle isn't used to make any other product. We even have some products that are not made of other products. For example, the bicycle wheel spokes are purchased and not composed of other parts. Based on this information, what crows foot symbols should be placed at positions 1 and 2 in the initial ERD below.

houldb EQUIPMENT Has SEUM