Slide 12
Slide 12 text
Option 1: Use the simplified FSW template with the automated script
Configure Fuse Service Works
Step 1B: Setup the Database – Manual (Continued)
In the console, create a table:
CREATE TABLE CUSTOMER(
SSN VARCHAR(11) PRIMARY KEY,
FIRSTNAME VARCHAR(50),
LASTNAME VARCHAR(50),
STREETADDRESS VARCHAR(255),
CITY VARCHAR(60),
STATE VARCHAR(2),
POSTALCODE VARCHAR(60),
DOB DATE,
CHECKINGBALANCE DECIMAL(14,2),
SAVINGSBALANCE DECIMAL(14,2));
And insert some test data:
INSERT INTO CUSTOMER VALUES
('800559876', 'Joe', 'Deeppockets-existing', '345 Pine Ave', 'Springfield', 'MO', '65810', '1966-07-04', 14000.40,
22000.99);
INSERT INTO CUSTOMER VALUES
('610761010', 'Sally', 'Shortchange-existing', '456 Larch Lane', 'Springfield', 'MA', '99999', '1966-08-05', 9100.10,
2750.75);
INSERT INTO CUSTOMER VALUES
('680777098', 'Barbara', 'Borderline-existing', '567 Poplar Pkwy', 'Worcester', 'MA', '01604', '1976-09-06', 300.41,
11.01);