EMBA 741 E-Business Trends --

A07: Personal DB II
 Home    Site Map    Search    EhrlichOrg.com

Syllabus    Classes    Student Info    Guest Info

 

Personal Database Part II

This is the second part of the three part personal database assignment.  In Part I you decided what type of database service you would like and developed the data model.  In Part III you will implement the user interface to the database.

Your assignment for part two is to implement the database in Oracle using SQL Plus. Your deliverable has three parts: SQL Statements, Sample Test Results, and Oracle Database Contents as follows:

A. SQL Statements 

Show the SQL commands for creating and manipulating your Personal DB on pages that are part of your personal Web site.  This should include the SQL commands for:

  1. Creating each of the tables you defined.
  2. Inserting several rows of realistic sample data into each table.
  3. Executing each of the Transactions you defined against the database.
  4. Queries to show the results of the Transactions.

A user should be able to copy your SQL, paste it into SQL Plus, create the database and execute the queries.

B. Sample Test Results

Show the results of your sample SQL queries from step 4 above on pages in your Web site. This can be done by:

Executing the SQL commands (copy from your Web page into the terminal Window).
Copying the SQL Plus results from the terminal window and pasting the data into a Web page.  You may need to adjust the formatting. 
Publishing the Web page as part of your site.

C. Oracle Database Contents

Your tablespace in Oracle should contain your tables and data resulting from the actions described above.  Make your tables visible to others by issuing the following SQL statement, replacing table-names with a list of your tables:

Grant Select on table-names to public;

 
 

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