Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Due Date: Please see the Assignment submission folder or calendar Introduction The Structured Query Language (SQL) is a standardized language to communicate with databases. There

image text in transcribed
image text in transcribed
Due Date: Please see the Assignment submission folder or calendar Introduction The Structured Query Language (SQL) is a standardized language to communicate with databases. There are two major parts to SQL: Data Manipulation Language (DML) and Data Definition Language (DDL). The latter is used to create databases. This includes the creation of tables, primary keys and the relationships between tables: In this assignment, you will demonstrate aspects of the Data Definition Language using Microsoft SQL Server. Course Learning Outcomes Evaluated in this Assignment Create a database from a set of relations, using SQL's Data Definition Language (DDC). Instructions 1. Please transform the following Entity Relationshig diagram into a set of relations in 3n1 Normal Form. 2. From the resulting set of relations, implement the database in MySQL. 3. For each course a student takes, you need to keep track of the date of completion, and the grade received. 4. For each course an instructor teaches, the date the course starts is recorded. 5. You may add any attributes you feel are necessary to the model fand subsequent columns to the tables). Choose an appropriate name for such attributes/columns. 6. The name of the database should be Training- 7. Please submit the following: a. A document with the set of relations fyou may use any tool to produce the document. including a hand-written submission). Relations afe the final step before implementing. the physical database in a database management system. This is NOT the entity relationship diagram. Rather, it is derived from the ERD. b. The statements used to create the database and the tables in a sql file that can be executed in MySQL. Workbench

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

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

Students also viewed these Databases questions

Question

What advice would you provide to Jennifer?

Answered: 1 week ago

Question

What are the issues of concern for each of the affected parties?

Answered: 1 week ago