ESM 261 - Fall 2007

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.

The simplest way to do this is to 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.

Deliverables

Submit your "empty" Access database, as either an attachment or (if it lives on the web) as a URL, to frew@bren.ucsb.edu by close-of-business Wednesday 05 December .