Discussion and instructions necessary for setting up the MDC_CH02 database in the DBMS product you are using: ■ For Microsoft SQL Server 2014, see online Chapter 10A. ■ For Oracle Database 12c or...

Discussion and instructions necessary for setting up the MDC_CH02 database in the DBMS product you are using:

■ For Microsoft SQL Server 2014, see online Chapter 10A.

■ For Oracle Database 12c or Oracle Express Edition 11g Release 2, see online Chapter 10B.

■ For MySQL 5.6 Community Server, see online Chapter 10C.

Once you have setup your MDC_CH02 database, create an SQL script named MDCCH02-CQ.sql, and use it to record and store SQL statements that answer each of the following questions (if the question requires a written answer, use an SQL comment to record your answer):