Implement the ERD shown here as an Oracle database. Start with the sample code in lab03.sql (on the class repo) and add schema elements to that code for the entities and relationships shown here.

Be sure to set the constraints appropriately and to include primary and foreign key constraints as appropriate. Make your edits directly to lab03.sql.

Upgrade your model and implementation to include schema elements representing teams and homegroups as described in class exercises 2.3.a–b.

1. Extend the ERD model shown above, either by extending it on paper (see cpdb-partial.png) or by editing the diagram slide (see cpdb-partial.pptx). Store the result in lab03.ext.
2. Translate the new elements of your ERD into relational model elements and add them to your relational model. Add these updates to lab03.sql.

Be sure to include all appropriate elements in both your ERD model and your relational implementation.

Upgrade your implementation to include schema elements for the “request” entity discussed in class exercise 2.3.c, as modeled here.

If you haven’t already done so, add sample records for all the new tables.

Save your updates in lab03.sql.