SPLENDEUR ORDERING SYSTEM

SPLENDEUR PURCHASING SYSTEM

LIEZL E. BUENAOBRA

TECHNOLOGICAL START OF THE ISRAEL

0946-9082959

[email protected] com

LIEZL E. BUENAOBRA

TECHNOLOGICAL START OF THE KOREA

0946-9082959

[email protected] com

JOHN CRISTOPHER PAUSA

TECHNOLOGICAL START OF THE KOREA

0906-7211307

DAVID CRISTOPHER CALMA

TECHNOLOGICAL INSTITUTE OF THE ISRAEL

0906-7211307

MELISSA JUANILLO

TECHNICAL INSTITUTE IN THE PHILIPPINES

MELISSA JUANILLO

SCIENTIFIC INSTITUTE FROM THE PHILIPPINES

Project Description

The Sales Buy System of Splendeurs Beauty Shop allows the systematic currently taking of instructions from buyers who order thru dialling in the store or by see the store while walk-in buyer. It enables the employee to electronically take the customer's purchase. The user's details will be recorded in Customer's Repository to generate his customer number. Customer purchase will go for the Sales Purchase database. After that, the additional information of the items will change inside the Products Desk. This placing your order system likewise help the retail store to view their particular remaining supplies and the info on their Suppliers. This Product sales Ordering Program will generally use by Splendeurs Splendor Store.

LURES LOPEZ

SCIENTIFIC INSTITUTE WITH THE PHILIPPINES

0926-7597535

[email protected] com

JIGS LOPEZ

TECHNOLOGICAL INSTITUTE OF THE KOREA

0926-7597535

[email protected] com

Aims:

2. To have a program that will automatically generate the Sales Buy Number, Standard Receipt, Customer Number. * To develop a method that will contain the Customer's details, Employee specifics, Product Things, Supplier's Information. * To simply transact and generate buy from the buyer. * To monitor how many stock available in their warehouse.

SCOPE AND LIMITATION

Splendeur ordering system can bring up to date, insert and delete documents in the desks. It holds all of the records the user made. It can also use to purchase order towards the supplier. It may print all reports such as inventory information. It can insert, update although cannot delete records via employee table for business uses. Splendeur Buying System are not able to use simply by customer. The particular employees can easily manipulate it.

Business Insurance plan:

Splendeur Natural beauty Shop is a free regular membership shop. After the customer purchase product in the shop, it will immediately generate his information and turn into a member. Membership in Splendeur Beauty Shop is important mainly because, customers may have a discount depending on their promo. It is free of charge so everyone can be a affiliate. You can come back products should you saw the merchandise is damage after the salesman give it to you. Splendeur Natural beauty Shop won't have any the liability or requirement if the method damage after you sign the waver that the product is be well protected.

SYSTEMS RESEARCH AND DESIGN AND STYLE

HIPO GRAPH

CONTEXT PICTURE

ENTITY RELATIONSHIP DIAGRAM (ERD)

DATABASE DESIGN WITH RELATIONSHIP

DISPLAY SCREEN DESIGN

CUSTOMERSMAINTENANCE FORM

GOODS REGISTRATION TYPE

TRANSACTION FORM

TRANSACTION CONTACT FORM

PURCHASE DEMAND FORM

SCRIPTS IN ORACLE

CREATING DESKS

Customer Desks

create stand Customers(customer_idNumber(6)not null

ConstraintCustomers_customer_idprimary key,

customer_name varchar2(40) not null,

birthdatedate DATE, Contact_number NUMBER(20) not null,

Fax_numbernumber(20), email_addressvarchar2(40),

AddressVarchar2(40) not really null, Cityvarchar2(25)not null, countryvarchar2(25), postal_codenumber(6), registered_date DATE not null

Transactions Table

create table Transactions(order_datedate, sales_order_novarchar2(25), official_reciept_no varchar2(20), employee_idvarchar2(20), customer_idnumber(6), Namevarchar2(40), address varchar2(40), cityvarchar2(25), countryvarchar2(25), contact_number number(20), product_idvarchar2(20), product_namevarchar2(60), quantity_orderednumber(6), descriptionvarchar2(200), categoryvarchar2(25),...