Question: Database Normalization and Query One 1NF data table provided. Normalize the table into 3NF and create an SQL script to create your 3NF tables. Be

Database Normalization and Query One 1NF data table provided. Normalize the table into 3NF and create an SQL script to create your 3NF tables. Be sure to capture any/all constraints (primary keys, foreign keys, etc). Be sure that the script can re-initialize the database to a pristine state (tables without data). Create a query for the database to produce an identical table to the one originally provided.

PublisherID PublisherName SeriesISBN Series Title Series Position ISBN Title 10001 10001 10001 10001 10001 10001 10001 10001 10001 1 2 3 4 5 10001 6 10001 7 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780060244880 The Chronicles of Narnia 9780007525515 The Hobbit & The Lord of the Rings 9780007525515 The Hobbit & The Lord of the Rings 9780007525515 The Hobbit & The Lord of the Rings 9780007525515 The Hobbit & The Lord of the Rings 9780261102385 The Lord of the Rings 9780261102385 The Lord of the Rings 9780261102385 The Lord of the Rings 1 10001 10001 2 3 HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins HarperCollins Houghton Mifflin Harcourt Houghton Mifflin Harcourt Pearson Pearson Pearson Pearson Pearson Scribner Scribner Scribner 10001 10001 PublishDate AuthorID 1003 2007-08-14 1001 2004-10-26 1001 2007-04-17 1000 2007-04-17 1000 2007-08-14 1001 2007-08-14 1001 2007-08-14 1001 2007-08-14 1001 2007-08-14 1001 2007-08-14 1001 2007-08-14 1001 2007-04-17 1000 2007-04-17 1000 2007-04-17 1000 2007-04-17 1000 2007-04-17 1000 2007-04-17 1000 2007-04-17 1000 2020-01-01 1002 2007-09-21 1000 2015-06-08 1007 2015-06-08 1008 2015-07-13 1004 2015-07-13 1005 2015-07-13 2011-09-20 1001 1996-10-01 1001 1996-10-01 1001 1996-10-01 1001 9780060244880 The Chronicles of Narnia 9780060598242 The Chronicles of Narnia 9780007525515 The Hobbit & The Lord of the Rings 9780261102385 The Lord of the Rings 9780060234973 The Magician's Nephew 9780060234812 The Lion, the Witch and the Wardrobe 9780060234881 The Horse and His Boy 9780060234836 Prince Caspian 9780060234867 The Voyage of the Dawn Treader 9780060234959 The Silver Chair 9780060234935 The Last Battle 9780261102217 The Hobbit 9780261102354 The Fellowship of the Ring 9780261102361 The Two Towers 9780261102378 Return of the King 9780261102354 The Fellowship of the Ring 9780261102361 The Two Towers 9780261102378 Return of the King 9780012345678 A New Series 9780618968633 The Hobbit 9780133970777 Fundamentals of Database Systems (7th Edition) 9780133970777 Fundamentals of Database Systems (7th Edition) 9780133544619 Modern Database Management (12th Edition) 9780133544619 Modern Database Management (12th Edition) 9780133544619 Modern Database Management (12th Edition) 9781451664829 The Space Trilogy 9780743234900 Out of the Silent Planet 9780743234917 Perelandra 9780743234924 That Hideous Strength AuthorName Date Of Birth RoyaltyPercent LeadAuthor AuthorPosition Hed Tighe 1980-01-01 C. S. Lewis 1898-11-29 20.0 Y 1 C. S. Lewis 1898-11-29 12.0 Y 1 J. R. R. Tolkien 1892-01-03 5.0 Y 1 J. R. R. Tolkien 1892-01-03 1.6 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 1 C. S. Lewis 1898-11-29 15.0 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 C. S. Lewis 1898-11-29 15.0 Y 1 J. R. R. Tolkien 1892-01-03 3.0 Y 1 J. R. R. Tolkien 1892-01-03 1.2 Y 1 J. R. R. Tolkien 1892-01-03 1.3 Y 1 J. R. R. Tolkien 1892-01-03 1.4 Y 1 J. R. R. Tolkien 1892-01-03 1.2 Y 1 J. R. R. Tolkien 1892-01-03 1.3 Y 1 J.R.R. Tolkien 1892-01-03 1.4 Y 1 Erez Osiris 1990-01-01 0.0 Y 1 J.R.R. Tolkien 1892-01-03 1.5 Y 1 Ramez Elmasri 1973-01-01 5.0 N 1 Shamkant B. Navathe 1974-01-01 5.0 Y 2 Jeffery A. Hoffer 1970-01-01 10.0 Y 1 V. Ramesh 1971-01-01 2.0 N 2 Heikki Topi 1972-01-01 2.0 N 3 C. S. Lewis 1898-11-29 20.0 Y 1 C. S. Lewis 1898-11-29 5.0 Y 1 C. S. Lewis 1898-11-29 5.0 Y 1 C. S. Lewis 1898-11-29 5.0 Y 1 4 1 10001 10001 2 3 10001 10000 10000 10002 10002 10002 10002 10002 10003 10003 10003 10003 1006 1 9781451664829 The Space Trilogy 9781451664829 The Space Trilogy 9781451664829 The Space Trilogy 2 Scribner 3

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 Databases Questions!

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

CIS 3650 Database Management Systems 2. Entity relationship diagram that documents the database design. The diagram should use the Fall 2022 Group Project appropriate crow's foot notation including...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

I need help with this I need this in SQL and please, I need to also see what this looks like in an SQL query with Microsoft SQL Server please show me what this looks like. Thank you very much for...

To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified....

Project Normalization 1. Entity Relationship Diagram of the Database. 2. SQL file which contains the script to create tables, set constraints and insertion of data. 3. Word document with screen shots...

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them Discussions with the industry representatives focused on two initial...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

The following set of equations are given for a typical worker in the economy. U = 4 C Cf The current income is X = 20,000 The future income is Xf = 30,000 The capital market rate is: 10% a. Find the...

In simple random sampling, it is also true that each member of the population is equally likely to be selected, the chance for each member being equal to the sample size divided by the population...

e) How would you use futures contracts on Canada Use the following to answer questions a) - f). Bank of Big Bucks ($ million) Assets: Liabilities and Net Worth: 270 day Treasury bills $500m 1 year...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. What can you learn from this person that will help you to gain power and use it constructively for your own benefit and for the organizations benefit? (In some cases, this might involve learning...

Did the person take the initiative to understand the issue and gather needed information?

Is the person willing to deal with the consequences?