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 1NF design to 2NF? In your answer, specific pages and figures in this chapter.

Program Plan Intro

What is 2NF? Describe the method to convert table in 1NF to 2NF. Refer to specific pages in the chapter 9 of this book.

Program Explanation

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

  • It should be in 1NF
  • There should be no partial dependency i.e. no non-prime attribute should be determined by subset of primary key.
For example, the table shown in figure 9-21 of this book is not in 2NF as shown below:

In the above table description, which a non-prime attribute can be uniquely determined by product number which is subset of primary key (Order, ProductNumber). Hence above table is not in 2NF.

Following steps to should be performed to convert a table in INF to 2NF:

  • Select a non-key attribute and check whether the attribute is functionally dependent on the primary key, if yes check another attribute.
  • If the attribute is partially dependent, usually in 1NF the primary key is a composite key, and the attribute is depending upon only one part of the key, create a new table place this attribute and the key in a separate table.
  • Repeat until all the non key attributes are checked...

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

Discuss the importance of data models.

Database Systems: Design, Implementation, & Management

What role does a Linux distributor play?

Principles of Information Systems (MindTap Course List)

What was important about RAND Report R-609?

Principles of Information Security (MindTap Course List)

Explain the four strokes of the internal combustion engine.

Automotive Technology: A Systems Approach (MindTap Course List)

VocabularyState the meaning of the following terms: Exponential Function _____ Logarithmic Function _____ Natur...

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

Placing a computer in _____ mode saves any open documents and running programs or apps to an internal hard driv...

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