For the following table for student grades, create a relational data model after normalization using MySQL.PK/FK and cardinalities should be defined. If needed, you can make some assumptions.All tables should be in the third normal form (3NF).You need to submit a MySQL Workbench Model (Only files with the extension .mwb will be accepted). Student StudentIDName112Chris2ChrisParkStudentMajorMarketingParkMarketingISCourseCodeISISM 218ISM 425ISM 218Course CourseseTitleScoreISM 425DatabaseSystemsBusinessAnalyticsDatabaseSystems8595100BusinessAnalyticsAssumption: The same grading scheme is applied to all courses in determining letter grades.LetterGrade80B+AAB

Answered: For the following table for student…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

For the following table for student grades, create a relational data model after normalization using MySQL.
PK/FK and cardinalities should be defined. If needed, you can make some assumptions.
All tables should be in the third normal form (3NF).
You need to submit a MySQL Workbench Model (Only files with the extension .mwb will be accepted).

Student Student
ID
Name
1
1
2
Chris
2
Chris
Park
Student
Major
Marketing
Park
Marketing
IS
Course
Code
IS
ISM 218
ISM 425
ISM 218
Course Course
se
Title
Score
ISM 425
Database
Systems
Business
Analytics
Database
Systems
85
95
100
Business
Analytics
Assumption: The same grading scheme is applied to all courses in determining letter grades.
Letter
Grade
80
B+
A
A
B

Expert Solution

Step 1

Here our task is to create the given table in mysql which follows 3 NF.

Here as we can observe {Student ID} is the candidate key which is the only prime attribute.

The course Title depends on the Course Code which depends on Student ID so it has to be removed.

Similarly Letter grade depends on Course Score which further depends on Student ID, so it also has to be addressed.

So after normalisation, we will have 3 tables.

Table 1.

Step by step

Solved in 5 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions