Systems Analysis and Design (Shell...

11th Edition
Scott Tilley + 1 other
ISBN: 9781305494602



Systems Analysis and Design (Shell...

11th Edition
Scott Tilley + 1 other
ISBN: 9781305494602
Textbook Problem

How would you define normal form? How do you convert a 2NF design to 3NF? In your answer, specific pages and figures in this chapter.

Program Plan Intro

What is third normal form? What is the procedure to convert 2NF to 3NF? Refer to specific figure in the chapter 9 of this book for your explanation.

Program Explanation

3NF is the referred to as third normal form and is the third stage to normalization process of database. A table design is said to be in 3NF if it meets the following criteria:

  • It should be in 2NF
  • There should be no transitive dependency i.e. no non-prime attribute should be determined by another non-prime attributes.
  • For example, the product table shown in figure 9-22 of this book is not in 3NF as shown below:

It is not in 3NF since the attribute supplier name can be uniquely determined from supplier number which is not a part of primary key.

Following steps needs to be performed to convert the product table from 2NF into 3NF:

  • Identify the attributes which are dependent on non key attributes other than the primary key and candidate key.
  • Remove the attribute from the original table, create a new table and place the column in it, select a primary key for the new table...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Solutions

Find more solutions based on key concepts

Show solutions add

What are the potential costs of implementing a database system?

Database Systems: Design, Implementation, & Management

Explain the benefits of CAD/CAM programming versus longhand program writing.

Precision Machining Technology (MindTap Course List)

Using MATLAB, create a table that shows the relationship between the units of temperature in degrees Celsius an...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Which links on the Discovering Computers Facebook page are of interest to you? Why?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)