Understanding database relationships and cardinality is the primary learning objective of this In$-$Class Activity.

Use the information from the following tables to create a database schema diagram for a Housing Authority database. You must specify the cardinality of the relationships when you create the schema.

Maximum cardinality is given; however, you will have to identify the minimum cardinality if necessary.

The following describes the schema diagram you are expected to created in Part $1.$

Entities Attributes

Development DevelopmentID, Name, Number of units

Unit UnitID, Unit Number, Bedrooms, Bathrooms, Square footage

Household HouseholdID, Description

Resident ResidentID, First name, Last name, Birthdate, Head of household?

Relationships Relationship Attributes

Development$-$Unit: One to Many

Unit $-$ Household: Many to Many Move in date, Move out date

Household$-$ Resident: One to many