All Powder Board and Ski Oracle 9 i
All Powder Board and Ski Oracle 9 i Workbook Chapter 1 Jerry Post Copyright © 2003
Inventory Snowboards Manufacturer Mfg ID QOH Freestyle Pipe Standard Extreme Skis Manufacturer Mfg ID QOH Slalom Cross country-skate Cross country-trad. Telemark Jumping Freestyle Downhill/race Size Description Graphics List Price
Boots and Bindings Boot-Binding Compatibility Manuf. Mfg. ID Board/Ski Binding/Style Size 34 35 36 … QOH Color Price Cost
Sales Customer First Name Phone Address City, State ZIP Male/Female Age/Date of Birth Item Description Last Name E-Mail Shipping Address City, State ZIP Ski/Board Style New/Used Size Item Total Tax Total Due Method of Payment Sale Date Salesperson Department Skill Level Quantity Price Subtotal
Rentals Customer First Name Last Name Phone E-Mail Address City, State ZIP Male/Female Age/Date of Birth Item Description Rental Date Expected Return Shipping Address City, State ZIP Ski/Board Style Skill Level Size Fee Return Date Condition Item Total Tax Total Due Added Charges Method of Payment Signature Charges
Project Structure Project Title: Sales System for Boards and Skis Customer: All Powder Board and Ski Shop Primary Contact: Katy Goals: Project Description: Primary Forms: Primary Reports: Lead Developer: Estimated Development Time:
Project Plan Define the project and obtain approval. 1. Analyze the user needs and identify all forms and reports. 2. System Design a. Determine the tables and relationships needed. b. Create the tables and load basic data. c. Create queries needed forms and reports. d. Build forms and reports. e. Create transaction elements. f. Define security and access controls. 3. Additional Features a. Create data warehouse to analyze data as needed. b. Handle distributed database elements as needed. 4. System Implementation a. Convert and load data. b. Train users. c. Load testing. 5. System review
Feasibility Assumptions Annual discount rate Project life/years Costs One-time DBMS Software Hardware Development Data entry Training 0. 03 5 Present Value Subtotal
Feasibility-2 Ongoing Personnel Upgrades/annual Supplies Support Maintenance Benefits Cost Savings Better inventory control Fewer clerks Strategic Increased sales Other? Net Present Value
DBMS Update l Oracle academic initiative l l Oracle technology network l l http: //oai. oracle. com http: //otn. oracle. com Oracle documentation—requires OTN l http: //otn. oracle. com/documentation/content. html
Enterprise Manager
Practice: Create a table
Table Constraints and SQL CREATE TABLE "POWDER". "CUSTOMER" ( "CUSTOMERID" NUMBER(10) NOT NULL, "LASTNAME" VARCHAR 2(25), "FIRSTNAME" VARCHAR 2(25), "PHONE" VARCHAR 2(20), "ADDRESS" VARCHAR 2(50), "CITY" VARCHAR 2(35), "STATE" VARCHAR 2(20), "ZIPCODE" VARCHAR 2(20), CONSTRAINT "PK_CUSTOMER" PRIMARY KEY("CUSTOMERID") )
Practice: Add Data
Practice Design a Simple Form Tools: Data block wizard Layout wizard Save the form on the server and Program/Compile module
Practice: Create a Simple Form Warning: On the server, You must either run full 9 i. AS Or manually: Start OC 4 J Instance
- Slides: 16