ESM 261 - Fall 2008

Deliverable - Physical Schema

What you have to do

Develop a physical schema (implementation) for the relational database that will support your dataset. This means you have to identify and describe the

• tables
• fields
• primary keys
• foreign keys

that the database will implement.

If you're using Access

Create an "empty" Access database containing the appropriate tables and relationships, but no data. Use the "description" column in table design view to document each field. Use the Relationships tool to identify foreign key - primary key connections between tables. (Of course, you're also welcome to create the tables with SQL DDL queries...)

NOTE: Be sure to enable the option

Tools -> Options -> General -> Compact on Close

Otherwise, a database in which you're adding and deleting tables can grow quite large for no apparent reason.

If you're using MySQL

You may use MySQL Workbench to design physical schema, or you may implement it directly in SQL. Either way, be sure to verify that the resulting DDL creates a database.

Deliverables

Submit one of:

• Access database ".mdb" file
• MySQL Workbench ".mwb" file
• SQL DDL ".txt" file

by close-of-business Monday 24 November.