Directions identify the vocabulary word for each

This preview shows page 16 - 20 out of 23 pages.

Directions: Identify the vocabulary word for each definition below.First Normal Form(1NF)The outcome of the first step of databasenormalization. 1NF eliminates repeating groups byputting each into a separate table and connecting themwith a 1:M relationshipNormalizationA series of steps followed to obtain a database designthat allows for efficient access and storage of data in arelational database. These steps reduce dataredundancy and the chances of data becominginconsistentTry It / Solve It1. When checking a database model for first normal form what are you doingexactly?
2. What is the rule of 1NF in the normalization process?
3. Check to see if each ERD is in 1NF. If not, make the necessary changes tocorrect it.
Database DesignInstructor Resource Guideb.c.Solution:Problems a. and b. need to be altered. Problem c. is in 1NF..Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.
Database DesignInstructor Resource GuideSECTION 6 – LESSON 3: Second Normal Form LessonVocabularyDirections: Identify the vocabulary word for the definition below.Second Normal Form (2NF)The outcome of the second step of databasenormalizationTry It / Solve It1. The UID of a library book includes its BOOK number and SHELF number.Does this ERD follow the rules of Second Normal Form? If you spot aviolation, correct it.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.
Database DesignInstructor Resource Guide

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 23 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
toni
Tags
Database normalization, Normal Form, Instructor Resource Guide

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture