Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Enhancing Financial Inclusion Through Islamic Finance Volume II

Authors: Abdelrahman Elzahi Saaid Ali , Khalifa Mohamed Ali , Mohamed Hassan Azrag

1st Edition

3030399389,3030399397

More Books

Students also viewed these Finance questions