A08: Personal DB III

MBA 683 E-Business Technology --

Syllabus Classes References Examples Student Info Guest Info

Personal Database Part III

This is the third part of the personal database assignment. In Part I you decided what type of database service you would like and developed the data model, in Part II you created the database in Oracle.

Your assignment for part three is to implement a user interface, making this database part of an interactive service.

This service should the ability to add information to your personal database, change records in the database, delete records from the database, and look things up in the database. Add these screens to your Personal Web site.

Your deliverables include:

A) Web pages that display your data

	Try different display styles: lists, tables, etc.
	Start showing all data, then add query capability

B) Web pages for entering data

C) Web pages for deleting data

D) Web pages for changing data

Note:

Database access from AOL server, including your TCL code, uses Oracle user-id 'ad.' Execute the following SQL Plus command for each of your tables so that you can access and update your tables from TCL (replacing table-name each of your table names in a separate command):

Grant ALL on table-name to ad;

The SQL incorporated into your TCL code should refer to your tables prefixed by your account name. For example, student becomes chuck.student:

Select count(*) from chuck.student;

Remember, .adp pages only work under AOL server:

Put your files in your usf-acs directory

/home/web/usf-acs/www/student/account

You can link to these pages as

http://usf-acs.rho.net/student/account

Include the full URL address when linking between Web accounts (in either direction.

Personal Database Part III

Note:

© 2001 by Chuck Ehrlich, all rights reserved. Comments to webmaster. Updated on March 01, 2000.