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

Here our task is to create the given table in mysql which follows 3 NF. Here as we can observe…

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).

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).

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 17RQ

See similar textbooks

Related questions

Q: CUSTOMER PK CUS NUM CUS_LNAME HIF 1. 19 enerates. OPK FK1 RENTAL RENT NUM CUS_NUM RENT_CHARGE RENT…

A: ERD stands for entity relationship diagram. people additionally name those varieties of diagrams ER…

Q: draw the conceptual EERD where you should include the enhanced features.

A: ANSWER: Conceptual EERD: The drawn out substance relationship (EER) model is a language for…

Q: What is the difference between the implementation of 1:M unary relationship and M: N unary…

A: GIVEN: What is the difference between the implementation of 1:M unary relationship and M: N unary…

Q: Table 1 is the Sales table, which is an unnormalized table. The description of the Sales table are…

A: reply:

Q: Write a relational mode for each of the case below. You can create our own attributes and provide…

Q: Let's pretend the Student table in a university database is indexed by StudentID (the primary key),…

A: Introduction A database is a collection of organized data that is stored in a digital format and can…

Q: How do data modeling techniques vary between traditional relational columns and JSON/XML columns?

A: Given,How do data modeling techniques vary between traditional relational columns and JSON/XML…

Q: i want to insert the 2 csv into a database lifespan.csv

A: Approach: 1- Don't import any CSV files directly. 2- First, create a database, inside the…

Q: Consider a database with the following relations: Employee (Employee ID, Name, salary, startDate)…

A: The following SQL Query can be broken down into sub-queries: Sub-Query 1: Display Employees by…

Q: How does the "third normal form" improve upon the "second normal form" in relational data modeling?

A: Database normalisation involves organising the fields and tables in a database to minimise…

Q: Assignment III (5%): Design of the conceptual model (ERD) from the given relational database. (Note:…

A: increase all employee salary by 15% along with department ID, and display all employee data.- Here…

Q: How do you approach indexing on fields within a JSON datatype in a relational database?

A: With the rise of semi-structured data and the need for more flexible schema designs, many relational…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: C# Address Balance Credit Limit Customer Discount EX Description Item# m Order m m Item m QOH Order#…

A: The Objective is to convert the given ER diagram into relational tables and then implement the…

Q: Use MySQL Workbench to create an EER diagram for a database named school_db that stores information…

A: An Entity–relationship model (ER model) describes the structure of a database with the help of a…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: SQL: Database management is done using a programming language called SQL, or Structured Query…

Q: WRITE THE CODE OF MYSQL IN PYTHON Create database and tables as given below by using Python. (a)…

A: To create a database and tables in MySQL using Python, you can we need to use the…

Q: ou will need to create the database tables and choose sensible data types for each column. Make sure…

A: DBMS stands for Database Management System, which is a software system used for managing and…

Q: 5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the…

A: First check whether phone_id column exists in your customer, staff, and store table or not. If…

Q: Which database relation(s) could be joined with the result of the query of the previous inquiry to…

A: Question 1RENAME loan (loan_number1, branch_name1, amount1) SET DIFFERENCE loan, loan_number1…

Q: ere is the database design for the personnel data: employee(id, name, address) employeeMap(id,…

A: Actually, database is a used to stores the data\information.

Q: normalization

A: Given question has asked toi) Write down the normalised form.ii) Identify the repeating group of…

Q: "books" entity and insert some sample data, and then alter the table to add a new column for the…

A: Dear Student, The below answer demonstrates the steps to create a table for the "books" entity in a…

Q: WRITE THE OF MYSQL IN PYTHON, JUST ANSWER THE 2ND QUESTION BY LOOKING AT THE FIRST QUESTION Create…

A: Dear Student, The required code to fill each table is given below -

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

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

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

CONVERT TO USE CASE DIAGRAM
An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum. A traveling show is described by a show ID (identifier), the city in which the show is currently appearing, and the start and end dates of the show. Many of the museum works may be part of a given show, and onlyactive shows with at least…
Convert er diagram to Relational database
OVERVIEW Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2, resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart which displays BMI as a function of mass and height using contour lines or colors for different BMI categories, and which may use other units of measurement (converted to metric units for the calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value as shown the following table: BMI value Category Underweight Normal Overweight Less than 18.5 18.5 to less than 25 25 to less than 30 30 or higher Obese A national study in some country to analyze the BMI of the people in the country is considered. In this study, a set of cities is selected in the study and randomly specific number of persons are selected to check the BMI category of…
Draw a SEQUENCE DIAGRAM Purpose: High level UML sequence diagram for Research Paper Reviewing. Summary: User can search for his submitted, under review and published articles. He/she can view revisions/ comments of the reviewers, the process must be blind reviewed, there must be performance evaluation criteria of the reviewers, and the process must be speedy.
This Schema diagram to ER diagram
A library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…
In material System analysis and design
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
The State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…
Film Actor Language Film SMALLINT VARCHARZ (255) VARCHAR2 (2 SMALLINT SMALLINT PF actor d SMALLINT PF fim id .im_id languaged SMALLINT CHAR (20) SMALLINT name description release year anguage_id original_language SMALLINT renta duration *rentaate engh *replacement_cost rating pecial features ustpdate SMALLINT NUMBER (42) SMALLINT Fam Category SMALLINT SMALLINT NUMBER (52) VARCHARZ 6) VARCHAR2 (255) TIMESTAMP PF Sm id KA category Actor actor id first name SMALLINT VARCHARZ (45) last rame VARCHAR (4) nationality CHAR (2) Category category SMALLINT VARCHAR2 (2) Country country d SMALLINT U short_code CHAR (2) VARCHARU (2) name P parent c SMALLINT name Using the film database you have, answer the following queries in your schema then write them down in this paper. Question One: Select the total rental_rate for films grouped by their categories. Order the result (a from largest to smallest. Select all actors who acted together with JOE in any film. Use inner query. (b Create a view, which…