CREATE DATABASE "D:\MY\MY.fbd" page_size 8192
user 'SYSDBA' password 'masterkey';


CREATE TABLE Salespeople(
snum int,
sname char(10),
city char(15),
comm dec);
INSERT INTO Salespeople (snum, sname, city, comm) VALUES (1001, 'Peel', 'London', 0.12);
INSERT INTO Salespeople (snum, sname, city, comm) VALUES (1002, 'Serres', 'SanJose', 0.13);
INSERT INTO Salespeople (snum, sname, city, comm) VALUES (1004, 'Motika', 'London', 0.11);
INSERT INTO Salespeople (snum, sname, city, comm) VALUES (1007, 'Rifkin', 'Barcelona', 0.15);
INSERT INTO Salespeople (snum, sname, city, comm) VALUES (1003, 'Axelrod', 'New York', 0.10);

CREATE TABLE Customers (
cnum int,
cname char(10),
city char(15),
rating int,
snum int);
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2001, 'Hoffman', 'London', '100', '1001');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2002, 'Giovanni', 'Rome', '200', '1003');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2003, 'Liu', 'SanJose', '200', '1002');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2004, 'Grass', 'Berlin', '300', '1002');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2006, 'Clemens', 'London', '100', '1001');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2008, 'Cisneros', 'SanJose', '300', '1007');
INSERT INTO Customers (cnum, cname, city, rating, snum) VALUES (2007, 'Pereira', 'Rome', '100', '1004');

CREATE TABLE Orders (
onum int,
amt dec,
odate timestamp,
cnum int,
snum int);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3001, 18.69, 10/03/1990, 2008, 1007);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3003, 767.19, 10/03/1990, 2001, 1001);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3002, 1900.10, 10/03/1990, 2007, 1004);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3005, 5160.45, 10/03/1990, 2003, 1002);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3006, 1098.16, 10/03/1990, 2008, 1007);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3009, 1713.23, 10/04/1990, 2002, 1003);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3007, 75.75, 10/04/1990, 2004, 1002);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3008, 4723.00, 10/05/1990, 2006, 1001);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3010, 1309.95, 10/06/1990, 2004, 1002);
INSERT INTO Orders ( onum, amt, odate, cnum, snum) VALUES (3011, 9891.88, 10/06/1990, 2006, 1001);