Question: 1. Consider the following relation specified in relational schema notation and data provided in Excel BOOK (ISBN, Book Title, Num Pages, Subject, Publisher ID, Publisher

1. Consider the following relation specified in relational schema notation and data provided in Excel

BOOK (ISBN, Book Title, Num Pages, Subject, Publisher ID, Publisher Name, Publisher City, Publisher State)

1. Consider the following relation specified in

a. If the initial data above is in 1NF then simply state the data is already in 1NF and explain why. If not already in 1NF, explain why and make the necessary changes to transform it to 1NF. Use Excel to create the resulting 1NF table(s) including the data. Use relational schema notation to specify the 1NF relation(s). Be sure to underline the PK in the relational schema notation.

b. If the 1NF data from part a is in 2NF then simply state the 1NF data is already in 2NF and explain why. If not already in 2NF, explain why and make the necessary changes to transform it to 2NF. Use Excel to create the resulting 2NF table(s) including the data. Use relational schema notation to specify the 2NF relation(s). Be sure to underline the PK in the relational schema notation.

c. If the 2NF data from part b is in 3NF then simply state the 2NF data is already in 3NF and explain why. If not already in 3NF, explain why and make the necessary changes to transform it to 3NF. Use Excel to create the resulting 3NF table(s) including the data. Use relational schema notation to specify the 3NF relation(s). Be sure to underline the PK in the relational schema notation.

ISBN Book Title 111-1-11-111111-1 Rick's Brick & Cue's Big Book of Recipes 222-2-22-222222-2 History of Rick's Brick & Cum 333-3-3-333353-5 Famous BBQ Joints from Around the World 444-4-44-444444-4 BBQ That is Better Than Nick's Brick & Que Nun Pages Subject 466 Ceakbook 353 History 29 Outure 1 Culture Publisher ID Publisher Name 1 Cookbooks and More 2 Greg's Publishing Co. 3 Worldwide Publishing, Inc. 1 Cookbooks and More Publisher City Publisher State Springfield MO Springfield MO Boston MA Springfield MO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Consider the following relation specified in relational schema notation and data provided in Excel BOOK ( ISBN , Book Title, Num Pages, Subject, Publisher ID , Publisher Name, Publisher City,...

MySQL Conceptual schema (specified using ER diagram) to Logical Schema Mapping Practice 1. Consider the following set of requirements for a University database that is used to keep track of students'...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Database Processing for Large-Scale Analytics Assignment 1 Part 1 a) Create a relational schema with underlined (primary) keys and arrows connecting foreign keys and primary keys for a database...

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Draw an ERD with one entity (rectangle) for each of your normalized relations and appropriate relationship lines with cardinality clearly noted. This should be quite easy to do once normalization is...

This is the bookstore.sql: DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...

A diving board oscillates with simple harmonic motion of frequency 1.5 cycles per sound. What is the maximum amplitude with which the end of the board can vibrate in order that a pebble placed there...

1- For the elements of melody and rhythm, write one sentence that describes the composer's creative expression of each in this work. Identify a short segment on which to base your comments. 2- The...

\ table [ [ Initial investment:, ] , [ Depreciable assets ( straight - line ) , $ 3 6 , 0 0 0 ] , [ Working capital, 4 , 0 0 0 ] , [ Operations ( per year for 4 years ) : , ] , [ Cash receipts,$ 2 5...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...