Santiago Canyon College

 

Computer Science 205

Advanced Visual Basic .Net Programming

Ron Kessler, Boss
Spring 2007

 

PROJECT 3: Point of Sale (POS) Part 3

Documentation & Specifications

 

 

Description

 

You are going to change the way you store data in this application. You are going to use a relational database (Access or SQL, your choice).

 

This application is designed to give you practice with

• ADO.Net 2.0
• Using ADO in code

 

 

Here are the minimum requirements for full credit (30 Pts)

1. Create a single Table relational database using MS Access or SQL.
2. You will use ADO objects in code...no wizard stuff!
3. The table will hold your inventory & pricing information.
4. Make the POS project work with the DB so that a manager can edit the table and staff cannot.

Extras (Optional)

1. You can add another table to hold passwords for the different access levels if you like.
2. You can add a field to the items table which contains the .jpg filename of the food item. Then display that photo when an item is chosen.
3. You can let someone search for a product as well.

 

DUE DATE

 

This project is due at the end of week 16. Please do not wait until the last minute to update your POS project because it always takes longer than you expect. Even if you do not finish it on time, turn in what you have for partial credit.