Problem: Some of the business rules identified states:
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' book 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 le using Excel, refer back to the steps taken to complete the assignment in M02. A nceptual view represents how the data will be displayed to the end user; in a relational tabase 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 com the completion of the normalization process. In the heading of the column that will erve 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.