Before we need to design or develop anything we need to write them down .on a paper what we require
and what we wish, which is also called as understanding Requirements
Requirement 1.
We will develop software, which will calculate telephone bills based on the number of calls made by customer
Requirement 2.
Each Customer will have an Option to choose 1 in 4 different plans the telecom Company Offers
Requirement 3.
Customer Data, is stored in database
Requirement 4.
Bill Data of each customer, is stored in database
Requirement 5.
Only people belonging to billing group can calculate the bill, and print bills
Requirement 6.
Customer can view his Bill
Requirement 7.
Ids are to be generated automatically wherever they are needed
Requirement 8.
Only People Belonging to Customer Data Entry group will add a customer data
Requirement 9.
Members belonging to Management Group can view individual or monthly bill amount of single or all customers
Requirement 10.
Access must be given to remote clients, who don't use browsers but still need to work on the system
Requirement 11.
Login Screen
Requirement 12.
Manager must grant discounts or levy charges on all or few customers
Wish List1.
Save Customer Data in XML Format
Wish List2.
Better Performance
|
Table 1 : To store customer data
CREATE TABLE phone_cust (
CUSTID VARCHAR2 (50),
CUSTNAME VARCHAR2 (50),
CUSTPH VARCHAR2 (50),
PLANID VARCHAR2 (50) ) ;
Table 2 : To store bill data
CREATE TABLE phone_bill (
BILLID VARCHAR2 (10),
CUSTID VARCHAR2 (50),
NOOFCALLS NUMBER,
BILLAMT NUMBER
) ;
Table 3 : To keep track of phone plans
CREATE TABLE phone_plan (
PLANID VARCHAR2 (10),
PLANNAME VARCHAR2 (50)
) ;
INSERT INTO PHONE_PLAN ( PLANID, PLANNAME ) VALUES ( '1', 'General');
INSERT INTO PHONE_PLAN ( PLANID, PLANNAME ) VALUES ( '2', 'Super');
INSERT INTO PHONE_PLAN ( PLANID, PLANNAME ) VALUES ( '3', 'Economy');
INSERT INTO PHONE_PLAN ( PLANID, PLANNAME ) VALUES ( '4', 'Special');
|
If you like this article and/or code 
