This Project builds on Part 4 from this week. You will work with your group to create a test data set and populate the database you created in the previous Project with sample data. You then design simple select queries that show the data contained in each table and joins between tables to show that all relationships (foreign keys) are functioning correctly.

To prepare for this Project:

• With your group, review the data requirements as expressed in your group's class diagram.
• Review the “Oracle SQL Sample Commands Worksheet” document included in this week’s Learning Resources.

To complete this Project, each group member will create a document that includes the following:

• Five to ten test records for each assigned table in the Group Project: Part 4 assignment from this week’s Project 1 area
• The structure of your assigned tables including all attributes and integrity constraints
• A screenshot showing the SQL select statement used to list the data stored in each assigned table and the output from the execution of the code showing all data stored in each table
• A screenshot showing the SQL join statement used to list the data stored in each set of tables linked by a one-to-many relationship included in the assigned tables and the output from the execution of the join statements showing all linked data stored in each table (e.g., Select * from Department Natural Join Employee. In this example, Department is on the one side of a one-to-many relationship. The table on the one- side is the parent table, the table on the -many side is the child table.)
• A description of your contribution to the Project