You must use MySQL to implement the database designed given. Test the queries you used to create and populate the database in MySQL. After successful completion of an SQL query:
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.
For each table, include the following:
a. 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. the DESCRIBE table_name; command to show the structure of the table.
c. all SQL queries you used to populate the table with valid data. Each table must contain a minimum of 3 records.
d.the SELECT * command to show the resulting table with all the valid data inserted.
Paste all s parts a-d for each table together in one place.
4. 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 paste into this section. To create queries, use the following structures:
a. A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression.
b. 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.
c. A query that includes a sub-query.
d. A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator.
e. 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).
Please review the files bellow attach for the topic and schema
0 comments