Abstract ER Model

Part 1

With your group, create an ER model for the following requirements:

• An X is uniquely identified by its ID, and has a name.
• A Y is uniquely identified by its ID, and has an address consisting of a street address, city, state and zip code.
• A Z is uniquely identified by its ID, has a name, and may have one or more colors.
• An R is uniquely identified by its name and a birth date and a generation (e.g., boomer, gen-X, gen-Z, etc.)

Part 2

With your group, extend the model you created in Part 1 to include the following requirements:

• An X runs at least one Y, but usually more.
• A Y may be run by an X.
• An X can grow many Z’s.
• A Z is grown by exactly one X.
• A R always owns a single Y.
• Only one R can own an Y, but a Y doesn’t have to be owned by a R.

Part 3

With your group, extend the model you created in Part 2 to include the following requirements:

• A Z holds at least one W.
• The W’s that each Z holds are consecutively numbered starting at 1.
• X’s can eat many Z’s.
• Z’s can be eaten by many X’s.
• An R may manage other R’s.
• An R may or may not be managed by another R.