Anonymous
timer Asked: Apr 22nd, 2020

Question Description

  1. A title page with course number, section number, and your name.
  2. Using the diagram below to create a fully labeled ERD in Visio or MySQL Workbench with minimum of 4 attributes in each entity.
  3. All queries must be successfully executed and screenshot your works including:
    • Your name at the following mysql> prompt.
    • 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.
  4. Using ERD from Q2 to create all tables in MySQL database. A screen shot(s) of the SQL queries you used to create the tables with appropriate attributes and data types together with primary keys, foreign keys, relationships and constraints.
  5. Run describe to show table structure created from Q4.
  6. A screen shot(s) of the DESCRIBE table name; command to show the structure of the table.
  7. A screen shot(s) of all SQL queries you used to populate the table with valid data. Each table must contain a minimum of 4 records.
  1. A screen shot(s) of the SELECT * command to show the resulting table with all the valid data inserted.
  2. 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.

Unformatted Attachment Preview

Optional Extra Credit project: IT214 Students may earn 3 extra bonus points by completing all following problem questions. Only one submission – no re-submission and no late submission will be accepted. 1. A title page with course number, section number, and your name. 2. Using the diagram below to create a fully labeled ERD in Visio or MySQL Workbench with minimum of 4 attributes in each entity. Rename Store entity to Your_userid_Store, i.e. lphung_store. (this is required. You will get 0 if entity name did not include your userid.) 3. All queries must be successfully executed and screenshot your works including: • Your name at the following mysql> prompt. • 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. 4. Using ERD from Q2 to create all tables in MySQL database. A screen shot(s) of the SQL queries you used to create the tables with appropriate attributes and data types together with primary keys, foreign keys, relationships and constraints. 5. Run describe to show table structure created from Q4. 6. A screen shot(s) of the DESCRIBE table name; command to show the structure of the table. 7. A screen shot(s) of all SQL queries you used to populate the table with valid data. Each table must contain a minimum of 4 records. 8. In the Employee table, insert one record with your first name, last name (This is required, or you will receive 0 point). 9. A screen shot(s) of the SELECT * command to show the resulting table with all the valid data inserted. 10. 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. ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

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