Answered step by step
Verified Expert Solution
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
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
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