Lab Project Checklist: Part 1

Imgard Ekokobe

 

Milestone I

  1. Statement of Work (SOW):
  • One paragraph describing your database
  • What hardware it will run on?
  • What software you will use?
  • What DDL and DML will you use?
  1. Present the timeline for this project.
  2. Normalized ERD, consisting of five entities. Use CASE tool if possible.

 

Milestone II

  1. Create a database.
  2. Using DDL, create your five tables. Include drop and create statements in proper order. Calculate free space, space to be used, and allocation of space needed.
  3. If your DBMS supports it, include any validity checkson the attributes of your tables.
  4. Create a viewon a single table.
  5. Create an equijoinview.
  6. Use declarative referential integrity and create primary and foreign keys.
  7. Replacing one declarative statement of referential integrity with a trigger. One triggeris all that needed.
  8. Create indexesas needed.
  9. Create a stored procedure.
  10. Create a table space(on paper only, do not run).
  11. Create a cluster(on paper only, do not run).
  12. Query the catalog on your database and be sure the five tables and other objects are shown.

 

Milestone III

  1. Loading data:
  • Load 100 records in one table (use sqlload).This table must carry the FKs from the table of 10,000 records. Reorder the columns on this table or the table of 10,000.
  • Load 10,000 records on another table. Use sqlload.
  • Using a file of five insert statements, load five records in each of the 3 remaining tables.
  • On the load routines must reorder the columns.
  1. Include sqlload statements, insert statements, a report/query from the data dictionary showing the number of records loaded into your tables, and any program you wrote to generate data.