Start Assignment $-$ Complete reading and reviewing all the learning resources specified for this module.

Review the Group Project Demo that walks through the normalization process.

Use the data elements provided below to complete the normalization process. Note these data elements would have been determined by the business rules previously identified.

Complete the first normal form.

Complete the second normal form.

Complete the third normal form.

Below is a list of data elements required to create an inventory of books that a publisher has published.

Data Elements

Publisher Book Title Book Release Date Author ID Author Name ISBN Book Description Book Cost Publisher ID Publisher Address Publisher Phone Book Category

Author Email

Publisher Email

Some of the business rules identified state:

An author can publish many books, but a book can be authored by one publisher.

An author can have many books, but a book can only be written by one author.

A publisher can publish many authors' books and an author can have books published by one or more publishers.

Using the output from the normalization process construct a conceptual view of your table using Excel, refer back to the steps taken to complete the assignment in M$02.$ A conceptual view represents how the data will be displayed to the end user; in a relational database, a dataset will be returned in a tabular format.

You now need to identify any primary and foreign key columns based on the final output from the completion of the normalization process. In the heading of the column that will serve as the Primary Key $($PK$)$ of each table include $($PK$)$ and use $($FK$)$ for any column that acts as the foreign key $($FK$)$ in the table.

Remember that a PK is a column constraint that uniquely identifies each row, it cannot be repeated, and an FK is a column constraint that enforces referential integrity and establishes. It acts as a pointer to a related row in another entity.

Include at least two rows in each table to represent the type of data that can be stored in each table. An example of the final outcome is provided below.

HINT: You should result in at least four tables.