Transcript All Powder Board and Ski

All Powder Board and Ski
SQL Server 2000 Workbook
Chapter 1
Jerry Post
Copyright © 2003
Inventory
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
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
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
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:
Estimated Development Cost:
Date Prepared:
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 for 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

Microsoft Academic Alliance


Microsoft Developers Nework


http://www.msdnaa.net
http://msdn.microsoft.com
Microsoft SQL Server

http://www.microsoft.com/sql
Enterprise Manager
Practice: Create a Table
Action
Action
Start SQL Server Enterprise Manager.
Open the SQL Server Group and log in.
Expand the database assigned to you, or
create it if necessary.
Right click on Tables, select New Table.
Enter column names and data types.
Click the CustomerID row.
Set the Identity value to Yes
Click the key icon in the main toolbar.
Close the form and name the table Customer.
SQL Create Table
Main toolbar: Generate SQL Script, Preview
Action
Action
Right click the table name.
Select Open Table/Return all rows
Enter the sample data.
Close the table.
Practice: Add Data
Action
Action
Start the Visual Studio with a New Project, Windows
Application in VB or C#..
Right-click the solution name, Add, Add New Item
Select Data Form Wizard, Customer.vb.
New Dataset: dsCustomer.
New Connection: Server name, user name, password
Click the box to Allow saving password.
Add the Customer table.
Display data: Single record in individual controls.
Click the button to Include password.
Practice Design a Simple Form
Visual Studio:
Add New Item,
Data Form Wizard
Action
Action
Switch to Form1.
Add a button and set the text and name to Customer.
Double-click the button to switch to the code.
Add two lines:
Dim frmCustomer As Customer = New Customer
frmCustomer.Show()
Save everything.
Build/Rebuild
Run the project and click the button.
Practice: Create a Simple Form
You have to click the Load
button created by the wizard
to retrieve the first row of
data