Question
Consider the following Table Student ID SFName SLName Address City State ZipCode Phone CourseCode CName CGrade 1 Mary McCall 12345 West Road Houston TX 77077
Consider the following Table
Student ID | SFName | SLName | Address | City | State | ZipCode | Phone | CourseCode | CName | CGrade |
1 | Mary | McCall | 12345 West Road | Houston | TX | 77077 | 281-907-2345, 713-456-9089 | MATH1313 | Algebra I | A |
2 | Sam | Romney | 78489 East Road | Dallas | TX | 78909 | 281-999-7856 | HIST1311 | History I | B |
3 | Alex | Smith | 23898 NorthEast Road | Houston | TX | 77043 | 281-909-8877, 718-890-3256 | COMP 3321 | Databases | A |
4 | Jan | Adams | 11467 West Road | Houston | TX | 77077 | 713-879-3454 | MATH 1314 | Calculus I | B |
5 | Sarah | Pieters | 1257 South Road | Dallas | TX | 78901 | 281-909-1122 | COMP 3321 | Databases | C |
6 | Marco | DeLion | 2323 SouthWest Road | Houston | TX | 77082 | 713-906-4578 | COMP 2231 | Data Structures | A |
7 | Jane | Abrahams | 10110 North Road | Austin | TX | 76098 | 346-832-6745 | HIST1311 | History I | D |
Student ( StudentID, SFName, SLNAME, Address, City, State, ZipCode, Phone, CourseCode, CName, CGrade)
-
Is the table in 1NF? If not, how to put it in 1NF.
-
Based on your answer in part 1 , Is the table in 2NF? If not, how to put it in 1NF.
-
Based on your answer in part 2 , Is the table in 3NF? If not, how to put it in 3NF.
-
Based on your answer in part 2 , Is the table in BCNF? If not, how to put it in BCNF.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started