To prepare for this assignment, review the Create Table statements from the previous unit.

Define data for all of the tables you were assigned in theprevious unit. Include at least three data items for each table (parenttable) on the one side of the one-to-many relationship and at least sixdata items for each table (child table) on the many side of theone-to-many relationship.
Complete the following tasks:

• For the tables you were assigned, use the SQL Command Lineutility to insert at least three data items into each table (parenttable) on the one side of the one-to-many relationship and at least sixdata items into each table (child table) on the many side of theone-to-many relationship.
  • Each data item in the parent table must have at least onedata item in the child table that it links to. (E.g. The production,accounting, and finance departments must each include at least oneemployee).
• Execute one join command to display all of the data included in the two tables for each set of tables.
• Include a screen shot to verify the successful completion ofeach Insert and Join command. Each Screen shot must be preceded by acomment that includes the student’s name, the instructor’s name, and thedate the command was executed. You may group the insert commands foreach table into one screen shot.
  • SQL>/* Student: Yatavia Summers Instructor: Michael Collins Date: date the command was executed */
  • Don’t forget the /* and */ at the start and end of the command to make it into a comment!!
  • The screen shot must include the SQL command and the output from the command.
  • Any errors while creating the comment or executing the SQL statement will require retyping the comment.

By Day 7

individually submit a 2- to 4-page word document that contains the following:

• Screen shots to verify the insertion of the required dataitems and execution of join commands on all tables you were assigned bythe group.