Database Reference
In-Depth Information
26.6 Sample Assignment 5A
The (cross-section of the) college database introduced in chapter 7 (and discussed in
subsequent chapters) is repeated here (Figure
26-3
).
Figure 26-3.
Cross Section of College Database Requirements
1.
Write SQL statements to create these tables in your schema of
the class database. You may add additional attributes to the
structure of each database table, as you deem appropriate.
Store these statements in an SQL script file.
{40}
2.
Use your SQL script file to create the tables in the class
database.
{16}
3.
Populate your tables with sample data (at least six records per
table).
{16}
