MySQL Design implement

Anonymous
timer Asked: Nov 13th, 2016

Question description

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. 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: New York 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