Assignment Brief: Some of the most difficult decisions that you face as a database developer are what tables to create and what columns to place in each table, as well as how to relate the tables that you create. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive normal form achieves a better database design than the previous form did. Based on your understanding for the various normal form respond to the following problems and provide the optimal answer/solution. Problem#1: 1* Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Alpha 100111 Name John Doe Email doe@usna.edu Courses NN204, SI204, IT221 SM223, EE301 S1204 GradePoints 2,3,3 092244 Matt Smith Melinda smith@usna.edu black@usna.edu 4,4 113221 Black 090112 Tom Johnson Johnson@usna.ed NN204, SI204, 4,2,3 u IT221 a) Is the Students table in 1NF? Discuess your answer? b) If the Students table is not in 1NF, reconstruct the tables such that all the information currently in the Students table is found in the resulting tables, and the resulting tables are in 1NF. For each of the resulting tables, give the table name, column names, primary keys, and foreign keys.
Assignment Brief: Some of the most difficult decisions that you face as a database developer are what tables to create and what columns to place in each table, as well as how to relate the tables that you create. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive normal form achieves a better database design than the previous form did. Based on your understanding for the various normal form respond to the following problems and provide the optimal answer/solution. Problem#1: 1* Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Alpha 100111 Name John Doe Email doe@usna.edu Courses NN204, SI204, IT221 SM223, EE301 S1204 GradePoints 2,3,3 092244 Matt Smith Melinda smith@usna.edu black@usna.edu 4,4 113221 Black 090112 Tom Johnson Johnson@usna.ed NN204, SI204, 4,2,3 u IT221 a) Is the Students table in 1NF? Discuess your answer? b) If the Students table is not in 1NF, reconstruct the tables such that all the information currently in the Students table is found in the resulting tables, and the resulting tables are in 1NF. For each of the resulting tables, give the table name, column names, primary keys, and foreign keys.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
Related questions
Question
Transcribed Image Text:Assignment Brief:
Some of the most difficult decisions that you face as a database developer are what tables to
create and what columns to place in each table, as well as how to relate the tables that you
create. Normalization is the process of applying a series of rules to ensure that your database
achieves optimal structure. Normal forms are a progression of these rules. Each successive
normal form achieves a better database design than the previous form did. Based on your
understanding for the various normal form respond to the following problems and provide the
optimal answer/solution.
Problem#1: 1st Normal Form (1NF)
Consider the Students table, with the primary key underlined, and the following data:
Students:
Alpha
100111
Email
doe@usna.edu
Name
Courses
GradePoints
NN204, SI204,
IT221
SM223, EE301
SI204
John Doe
2,3,3
Matt Smith
092244
113221
smith@usna.edu
black@usna.edu
4,4
Melinda
3
Black
NN204, SI204,
IT221
090112
Tom Johnson
Johnson@usna.ed
4,2,3
u
a) Is the Students table in 1NF? Discuess your answer?
b) If the Students table is not in 1NF, reconstruct the tables such that all the information
currently in the Students table is found in the resulting tables, and the resulting tables
are in 1NF. For each of the resulting tables, give the table name, column names,
primary keys, and foreign keys.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
