This /*--------------------------------------------------------------*/
/* SQL*Plus script creates the CAPS database for CSc 347 */
/* Use this script and sqlload to create/re-create the CAPS */
/* database */
/* **************************************************************/
drop table customers;
create table customers (cid char(4) not null, cname varchar(13),
city varchar(20), discount real,
primary key (cid) );
drop agents;
create table table agents (aid char(3) not null, aname varchar(13),
city varchar(20), commission number(6),
primary key (aid) );
drop table products;
create table products (pid char(3) not null, pname varchar(13),
city varchar(20), quantity number(10), price real,
primary key...