mysql database assignment

MySQL Tutorial

Mysql database, mysql references, mysql examples, mysql exercises.

You can test your MySQL skills with W3Schools' Exercises.

We have gathered a variety of MySQL exercises (with answers) for each MySQL Chapter.

Try to solve an exercise by filling in the missing parts of a code. If you're stuck, hit the "Show Answer" button to see what you've done wrong.

Count Your Score

You will get 1 point for each correct answer. Your score and total score will always be displayed.

Start MySQL Exercises

Start MySQL Exercises ❯

If you don't know MySQL, we suggest that you read our MySQL Tutorial from scratch.

COLOR PICKER

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail: [email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail: [email protected]

MySQL Sample Database

We use the classicmodels database as a MySQL sample database to help you work with MySQL quickly and effectively.

The classicmodels database is a retailer of scale models of classic cars. It contains typical business data, including information about customers, products, sales orders, sales order line items, and more.

We’ll use this sample database in our MySQL tutorials to demonstrate a wide range of MySQL features, from simple queries to complex stored procedures .

Download MySQL Sample Database

You can download the sample database from the following link:

The download file is in ZIP format, so you’ll need a zip program to unzip it. You can download a free zip program at www.7-zip.org .

After uncompressing the sampledatabase.zip file, you can load the sample database into the MySQL database server by following the tutorial on how to do so.

MySQL Sample Database Schema

The MySQL sample database schema consists of the following tables:

customers : stores customer’s data.
products : stores a list of scale model cars.
productlines : stores a list of product lines.
orders : stores sales orders placed by customers.
orderdetails : stores sales order line items for every sales order.
payments : stores payments made by customers based on their accounts.
employees : stores employee information and the organization structure such as who reports to whom.
offices : stores sales office data.

The following picture illustrates the ER diagram of the sample database:

You can download the MySQL sample database ER diagram in PDF format from the following link:

Download MySQL Sample Database Diagram PDF A4

We recommend printing out the ER diagram and placing it on your desk to help you become familiar with the schema as you learn MySQL.

Have fun learning MySQL!

MySQL Practice Exercises with Solutions – Part 1

W e have split this collection of exercises on MYSQL into seven parts, this is the first one , then you will find the second part , the third part , the fourth part , the fifth part , the sixth part , seventh part , eighth part , and finally the ninth part these exercises are based on simple, advanced and finally complex MYSQL queries. These questions are based on the following two tables, Employee table and Reward table.