Populating the database
insert into customer values
(1001, 'Walter White', '308 Negra Arroyo Lane', NULL, 'Albuquerque', 'NM', '87112', '(505) 555-1258'),
(1002, 'Jesse Pinkman', '9809 Margo Street', NULL, 'Albuquerque', 'NM', '87104', '(505) 143-3369'),
(1003, 'Hank Schrader', '4901 Cumbre Del Sur Ct NE', NULL, 'Albuquerque', 'NM', '87111', NULL),
(1004, 'Gustavo Fring', '1213 Jefferson Street NE', NULL, 'Albuquerque', 'NM', '87110', NULL);
insert into product values
(99901, 'Acme', '55 gallon drum', '55-001', 85.99),
(99902, 'Chrysler', '2012 Chrysler 300', '300', 33409.79),
(99903, 'Madrigal Electromotive GmbH', 'Air Filtration Unit', 'MB042266-GER', 79900.00),
(99904, 'Wilmington Tobacco', 'Pack of 20 Cigarettes', NULL, 5.95),
(99905, 'Cosmic Cuts', 'Amethyst Geode Slice High Quailty w/ Stand Cosmiccuts AD-40', NULL, 279.99),
(99906, 'Goorin Bros. Hat Shop', 'Fedora', 'Heisenberg', 150.00),
(99907, 'Domino''s', 'Ultimate Pepperoni, Large', NULL, 11.99),
(99908, 'Fruit of the Loom', 'Tighty Whitey size 32-34', NULL, 5.99);
insert into ord values
(66601, 1001, 'November 18, 2008', '123-45-678-1111'),
(66602, 1002, 'April 21, 2012', '345-55-789-2345'),
(66603, 1003, 'June 4, 2010', '245-11-567-1231'),
(66604, 1004, 'March 15, 2011', '897-65-432-9999');
insert into item values
(66601, 1, 20, 99901),
(66601, 2, 1, 99906),
(66601, 3, 10, 99908),
(66601, 4, 1, 99902),
(66602, 1, 10, 99904),
(66602, 2, 5, 99907),
(66603, 1, 1, 99905),
(66604, 1, 1, 99903);
|