You must use MySQL to implement the database you designed in Part I

. You must use MySQL to implement the database you designed in Part I. Test the queries you used to create and populate the database in MySQL. After successful completion of an SQL query:Type your name at the following mysql> prompt.Take a screen shot (Alt + Print Screen) that includes the query, the confirmation message, the results (if any), and your name.Paste the screen shot in the appropriate location in your MS Word file.

IMPORTANT NOTICE: If some of the tables in your database have the same names as the tables in the databases used in class (Premiere Products, Henry Books, and Alexamara Marina Group), re-name your tables. For instance, if the name of your table is CUSTOMER, change it to CUSTOMER_1. Do not delete existing tables from the databases used in class otherwise you will not be able to complete the rest of the homeworks.

Part II must include:

1.The title page with the course number, section number, and your name.

2.The ERD of the database you designed in Part 1. If you have to make changes in the structure of the database, you must receive your professor’s approval before you implement them.

3.Screen shots of the queries used to create tables and populate them with data. For each table, include the following:

a.A screen shot(s) of the SQL query you used to create the table with appropriate attributes and data types together with primary keys, foreign keys, relationships and constraints.

b.A screen shot(s) of the DESCRIBE table_name; command to show the structure of the table.

c.A screen shot(s) of all SQL queries you used to populate the table with valid data. Each table must contain a minimum of 3 records.

d.A screen shot(s) of the SELECT * command to show the resulting table with all the valid data inserted.

Paste all screen shots from parts a-d for each table together in one place.

4.Screen shots of SQL queries you used to retrieve data from the tables along with the query results. For each query, explain in a complete, coherent sentence what it is intended to do, what data is expected as a result and how they are different from previous queries. Clearly identify each screen shot you paste into this section. To create queries, use the following structures: A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression.A query that is based on more than two tables and includes both an arithmetic and a special operator in the conditional expression. Both the arithmetic and the special operator must be different from the ones used in part a.A query that includes a sub-query.A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator.Two additional complex queries designed by you that are different from the above. A complex query is based on two or more tables and includes either several conditions or a subquery (or both).

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code FREE15