At the end of Chapter 7, do the following problems: 16, 17, 21, 22, 23, 24, 26, 27, 28, 29,...

profilemohtob

At the end of Chapter 7, do the following problems: 16, 17, 21, 22, 23, 24, 26, 27, 28, 29, 30, 31, 32.

For your DBMS, I want you to use MySQL. If you prefer to install and use MySQL from your own computer, follow the installation instructions here:

http://dev.mysql.com/doc/refman/5.7/en/installing.html

There is also a free online tool that you can use to accomplish your work without installing the database on your computer. Following is the link to this tool:

http://sqlfiddle.com/

If you use SQL Fiddle, but sure to only create and populate the tables that you need for the problems. It has a limit to how much text you can paste in the Schema Panel. For example, on problems 26-33, you will use the SaleCo database. Even though there are 5 tables in the database, you only need 3 of them (INVOICE, LINE, and PRODUCT) for the problems.

I will upload the MySQL source files for the database structure and data.

    • 6 years ago
    • 30
    Answer(0)
    Bids(0)