• Assignment 6.1- Many to Many Relationship Data Model Implementation and Data Insertion

This assignment is the continuation of the week 3 assignment. The focus for this week is the physical data model development for MySQL. The result of this assignment is a SQL script that will run in MySQL. It will look a lot like last week's scripts to install your databases. This script should create a book tracking database based on your original design.

Refine the physical data model for a book tracking system from Week 3, create a database, and create tables with the following requirements:

1) The physical data model is about the book tracking system with the following objects:

Book

Publisher

Author

Store

2) Relationship

Different to last week assignment, the changes in the relationship are:

Book and publisher have a many to many relationship

Book and author have a many to many relationship

3) Change the physical data model of last to account to the many to many relationship using:

Junction tables

Foreign keys

4) Write DDL queries for table creation and table alteration

5) Write DML queries for data insertion

Add 4-6 records in each table/entity

6) Document all these steps in an APA word document

Describe how you refine the physical data model

Include the refined physical data model

Include the DDL Queries statement

Include the DML Queries statement

Include the screen shot end results (tables and columns) of tables as it shown in the SSMS