1st Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Students: Alpha 100111 092244 113221 Melinda Black 090112 Tom Johnson Email doe@usna.edu smith@usna.edu black@usna.edu Johnson@usna.edu NN204, S1204, IT221 Name John Doe Matt Smith Courses NN204, S1204, IT221 SM223, EE301 SI204 GradePoints 2,3,3 4.4 3 4,2,3 a) Is the Students table in 1NF? Why? b) If the Students table is not in 1NF, redesign 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.
1st Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Students: Alpha 100111 092244 113221 Melinda Black 090112 Tom Johnson Email doe@usna.edu smith@usna.edu black@usna.edu Johnson@usna.edu NN204, S1204, IT221 Name John Doe Matt Smith Courses NN204, S1204, IT221 SM223, EE301 SI204 GradePoints 2,3,3 4.4 3 4,2,3 a) Is the Students table in 1NF? Why? b) If the Students table is not in 1NF, redesign 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.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter3: The Relational Database Model
Section: Chapter Questions
Problem 14P: Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write...
Related questions
Question
Don't copy
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 2 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
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning