Student
[pic]
CS66 Advanced Oracle
Spring 2002
Group 10
Project Overview
Developed by Terence Kyle Reynolds Maria Tsipurskaya Illeana Grimm Glen Chen
INTRODUCTION
• The purpose of this application was to develop physical RDMS and its visual representation for general Restaurant Management operations such as fulfilling customers’ orders and managing inventory.
• Tools used are Oracle 8i, SQL*Plus, PL/ SQL, Oracle Designer 2000 and Oracle Developer 2000.
• The project required well-organized teamwork, squeezed in a strict time frame, which was successfully carried out by the group.
• Due the slow server on which Oracle Designer resided, we had a difficult time getting things to work correctly while working on the project. They were many instances in which Oracle Designer suddenly became unresponsive, preventing us from completing many parts of our project. Fortunately, we were able to get around the slowness of the server by using alternative methods or working on our project when there were less people in the computer lab.
STRATEGY
Strategy Document :
Business main entities that need to be kept records of in the database are - restaurant products and its categories, - purchase orders, - employees records, - suppliers, - menu items and categories, - meal orders and order details - bills.
Top-level requirements:
The project is very efficient as far as resources are concerned. It will be developed by a group of 4 students, who will be rewarded with nothing but a class grade for the implementation of an Oracle database worth thousands.
Political environment:
The Oracle CASE tools will be heavily abused by other developers which expected to slow down the system response significally. There is also security risk involved because of the common
CS66 Advanced Oracle
Spring 2002
Group 10
Project Overview
Developed by Terence Kyle Reynolds Maria Tsipurskaya Illeana Grimm Glen Chen
INTRODUCTION
• The purpose of this application was to develop physical RDMS and its visual representation for general Restaurant Management operations such as fulfilling customers’ orders and managing inventory.
• Tools used are Oracle 8i, SQL*Plus, PL/ SQL, Oracle Designer 2000 and Oracle Developer 2000.
• The project required well-organized teamwork, squeezed in a strict time frame, which was successfully carried out by the group.
• Due the slow server on which Oracle Designer resided, we had a difficult time getting things to work correctly while working on the project. They were many instances in which Oracle Designer suddenly became unresponsive, preventing us from completing many parts of our project. Fortunately, we were able to get around the slowness of the server by using alternative methods or working on our project when there were less people in the computer lab.
STRATEGY
Strategy Document :
Business main entities that need to be kept records of in the database are - restaurant products and its categories, - purchase orders, - employees records, - suppliers, - menu items and categories, - meal orders and order details - bills.
Top-level requirements:
The project is very efficient as far as resources are concerned. It will be developed by a group of 4 students, who will be rewarded with nothing but a class grade for the implementation of an Oracle database worth thousands.
Political environment:
The Oracle CASE tools will be heavily abused by other developers which expected to slow down the system response significally. There is also security risk involved because of the common