Anne Dawson: CSCI110A_Database_Lab_SP04.htm

Last updated: Monday 22nd March 2004, 8:19 PT

This document is subject to change without notice.

Please report any errors or omissions in this document:

adawson@coquitlamcollege.com

Special instructions: For this assignment you must work alone.

Database Lab Specification:

--------------------------

Using Microsoft Access, create a database for a pet store. The database should be named PetStore and have the following two tables: There should be a table called Animals which contains fields for the animal's class (e.g. Field name = Class, data type = text). Values of the Class field could be dog, cat, mouse, snake etc. In the Animals table, there should also be fields for the animal's, weight, age, sex, price. Appropriate field names and data types should be used. The first field in the Animals table is a field called AnimalID which should be the primary field. The AnimalID field is of type text, and stores an 8-digit numeric code which is unique for each animal. One field in the Animals table should be named CustomerID, and until the animal is sold should have the text value "TBA". There should be a second table for Customers. Provide any fields you consider appropriate, but the first field should be named CustomerID, and match the field name and data type of the CustomerID field in the Animals table. One record in the CustomerID field of the Customers table must have the text "TBA" as the value for every field (or 0 if the field is numeric). The CustomerID field in the Customers table should be the primary key. Create a relationship between the Animals table and the Customers table on the CustomerID field. Enforce referential integrity (i.e. each value of CustomerID in the animals table should match one value in the CustomerID field in the Customers table. Write a VB program which displays all fields from the Animals table and at the same time, all fields from the Customers table.

Submission instructions:

-----------------------

At 9:55am you will be asked to save your files to your folder in CSCI110A\Week12\DatabaseLab

Make sure that you include your name and the date in comments at the top of the code.

Marking Scheme :

--------------

The following marking scheme applies:

Course Code: CSCI110A

Semester: SP04

Instructor Name: Dr Anne Dawson

Assignment: Database Lab

Student Name:

Student Number:

DESIGN

1. Tables contain appropriate fields, field names

and data types. /20

2. Appropriate relationship is established. /10

3. The User Interface (form design) is

clear and tidy. /10

4. Appropriate number and type of test values is supplied /10

MAINTAINABILITY

5. The program is commented appropriately.       /10

6. The program has meaningful identifiers. /10

CORRECTNESS:

7. The program compiles with 0 errors. /10

8. The program runs as per specification. /20

% Complete:

Total: /100

Date: