August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: | n/a |
| A2: | n/a |
| A3: | n/a |
| A4: |
l |
| A5: |
l1 |
| A6: |
l1 c/last_name/first_name l3 c/last_name/first_name |
| A7: |
Save c:/prob7.sql |
| A8: |
Start c:/prob7.sql |
| A9: |
Create table manufacturers (manufacturer char(3), manufacturer_name varchar2(20)); Create table circuit_breaker_models (model varchar2(20), fk_manufacturer char(3), gallons_of_oil number(4,0), kva_rating number(4,1), a mps number(4,0), weight number(6,0)); create table circuit_breakers (serial_number varchar2(20), fk_model varchar2(20), location varchar2(30)); create table circuit_breaker_tests (fk_serial_number varchar2(20), test_date date, test_result number(5,1)); create table circuit_breaker_text (fk_serial_number varchar2(20), text_line_number number, text varchar2(300)); |
| A10: ... |