22C:005 Problem Solving and Computing, Fall 2000
Lab 11:
Due date: Tuesday, November 28th, at lab.
You are encouraged to work this assignment in groups of no more than two
students.
PART I: MS Access
Materials needed: 3 1/2 floppy diskette.
• Download the file Restaurant.mdb to your diskette.
• You are required to do Session 3.1, (pages AC 3.01 to AC 3.19) of Tutorial 3
from the Access textbook.
PART II: Database Design and Implementation
Design a small database, that holds some data of your choice, then implement it
using MS Access.
Requirements for your database:
• Have at least 5 tables.
• The total number of attributes for all tables should be greater than 10.
• The total number of records for all tables should be greater than 25.
• One of the tables should be a composite entity.
• There should be no redundancy in your data.
• Database should be normalized: eliminate repeating groups, partial
dependencies and transitive dependencies.
• Have MS Access enforce referential integrity an all relationships.
To hand in:
• A diskette containing the modified Restaurant database and your newly
designed database.
• ERD and bubble diagramas corresponding to your normalized database. Draw
these diagrams by hand, in a sheet of paper.
