CMPT 354 Study Guide - Quiz Guide: Console Application, Microsoft Visual Studio, Foreign Key
17 Jun 2015
School
Department
Course
Professor
Document Summary
The sql / c# (other programming languages are fine too) source code and screen shot of the generated results. Follow the instructions below to create the bookbiz database containing sample data from a publishing company including publisher, author, book title, and sales information. After the script creates the database, complete the sql exercises 1 - 11. Download bookbiz. zip from the tutorials page and unzip it. Sql commands that you need for this portion of the tutorial. To execute the bookbiz. sql file, open a new query window using the button in the ms sql server workbench. Next, click on the button and navigate to the bookbiz. sql file. Browse through the tables and try to understand the structures. Draw a box for each table containing the column names. For each primary key, connect the tables where it is used as a foreign key.
