Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

can you help to solve this

Normalize this relation below. Take it through the 1NF, 2NF, and 3NF progression.
• Use MS Word to draw the tables and show the entire set of tables at each step.
Express your thought process in a few sentences at each step. (Don't just repeat the rules!)
NOTE:
• You will need to create primary key and foreign key columns. Indicate the Primary Key columns by making them bold/underline.
This step will be ONF
Imagine an effort by someone who has attempted to make a database of library item circulation. This is a simplified example, of course, but assume we were
trying to track patrons and the items they checked out. A table to hold all this data could look like:
FirstName
LastName
PatronType
Township
Item checked out
Maree
Hamid
Adult
Clarke
Jaws: 2021-01-19
Joe
Nelson
Child
Clarke
Hoop Dreams: 2021-02-03
Joe
Nelson
Child
Clarke
Bugs: 2021-02-03
|Alain
Jones
Adult
Ripley
Hoop Dreams: 2021-01-10
Alain
Jones
Adult
Ripley
Jaws: 2021-01-10
1NF: First Normal Form - Eliminate repeating data and non-atomic values; add keys
The data is stored in a relation (table) and each attribute (column) contains atomic values. There are no repeating groups of attributes.
2NF: Second Normal Form - Eliminate partial dependencies.
The relation is in fırst normal form and all the attributes depend on the relation's unique identifier (primary key). --All the nonkey columns are dependent on
the table's primary key. (All nonkey attributes are functionally dependent on the entire primary key.)
3NF: Third Normal Form - Eliminate transitive dependencies.
The relation is in second normal form and all of its attributes are not transitively dependent on the unique identifier. ----A table contains only columns that
are non-transitively dependent on the primary key (i.e., all nonkey attributes depend only on the primary key)
expand button
Transcribed Image Text:Normalize this relation below. Take it through the 1NF, 2NF, and 3NF progression. • Use MS Word to draw the tables and show the entire set of tables at each step. Express your thought process in a few sentences at each step. (Don't just repeat the rules!) NOTE: • You will need to create primary key and foreign key columns. Indicate the Primary Key columns by making them bold/underline. This step will be ONF Imagine an effort by someone who has attempted to make a database of library item circulation. This is a simplified example, of course, but assume we were trying to track patrons and the items they checked out. A table to hold all this data could look like: FirstName LastName PatronType Township Item checked out Maree Hamid Adult Clarke Jaws: 2021-01-19 Joe Nelson Child Clarke Hoop Dreams: 2021-02-03 Joe Nelson Child Clarke Bugs: 2021-02-03 |Alain Jones Adult Ripley Hoop Dreams: 2021-01-10 Alain Jones Adult Ripley Jaws: 2021-01-10 1NF: First Normal Form - Eliminate repeating data and non-atomic values; add keys The data is stored in a relation (table) and each attribute (column) contains atomic values. There are no repeating groups of attributes. 2NF: Second Normal Form - Eliminate partial dependencies. The relation is in fırst normal form and all the attributes depend on the relation's unique identifier (primary key). --All the nonkey columns are dependent on the table's primary key. (All nonkey attributes are functionally dependent on the entire primary key.) 3NF: Third Normal Form - Eliminate transitive dependencies. The relation is in second normal form and all of its attributes are not transitively dependent on the unique identifier. ----A table contains only columns that are non-transitively dependent on the primary key (i.e., all nonkey attributes depend only on the primary key)
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education