Question
The below table is a sample from a spreadsheet used to record student grades for a college. You have been asked to design and implement
The below table is a sample from a spreadsheet used to record student grades for a college. You have been asked to design and implement a database for this process. Assume that letter grade is dependent on final % score.
Semester Season | Semester Year | Student First Name | Student Last Name | Course Code | Student ID Number | Course Description | Final % Score | Letter Grade |
Fall
Spring | 2019
2019 | Bob | Harris | ACTG 321R
BMIS 211
ACTG 321R
BMGT 322 | 00145
| Accounting Info Systems I
Spreadsheet and Database Skills
Accounting Info Systems I
Operations Management | 90.89
77.20
62.10
76.98 | A-
C
F
C |
Summer
Fall | 2019
2019 | Ed | Smith | ACTG 421
BMGT 322 | 00158 | Account Info Systems II
Operations Management | 98.02
87.4 | A+
B+ |
Fall | 2019 | Steve | Saxby | ACTG 321R
BMGT 322 | 00191 | Accounting Info Systems I
Operations Management | 95.40
91.34 | A
A- |
First, transform the table into first normal form. Be sure to include all the information that is in the above table and clearly label primary key(s).
Second, transform the table into second normal form. Be sure to include all the information from the original table and clearly label primary key(s).
Finally, transform the table into third normal form. Be sure to include all the information from the original table and clearly label primary key(s).
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