Create MYSQL commands for the following

timer Asked: Nov 17th, 2016

Question description

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:

  • 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.

    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

    Tutor Answer

    (Top Tutor) Studypool Tutor
    School: Rice University
    Studypool has helped 1,244,100 students
    flag Report DMCA
    Similar Questions
    Hot Questions
    Related Tags
    Study Guides

    Brown University

    1271 Tutors

    California Institute of Technology

    2131 Tutors

    Carnegie Mellon University

    982 Tutors

    Columbia University

    1256 Tutors

    Dartmouth University

    2113 Tutors

    Emory University

    2279 Tutors

    Harvard University

    599 Tutors

    Massachusetts Institute of Technology

    2319 Tutors

    New York University

    1645 Tutors

    Notre Dam University

    1911 Tutors

    Oklahoma University

    2122 Tutors

    Pennsylvania State University

    932 Tutors

    Princeton University

    1211 Tutors

    Stanford University

    983 Tutors

    University of California

    1282 Tutors

    Oxford University

    123 Tutors

    Yale University

    2325 Tutors