ITEC 3220 Study Guide - Quiz Guide: Sql*Plus, Online Analytical Processing, Oracle Database
Document Summary
Create table material(mid char(9) primary key, title varchar(20) not null, price. Number(9,2) not null, constraint price_limit check(price > 0 and price <= 150)); Create table employee(name varchar(20), eid char(9) primary key, sid char(9), salary. Create table customer(cid char(9) primary key, name varchar(20) not null, phone. Create table owner(on_id char(9) primary key, name varchar2(20) not null, address. Create table work(wid char(9) primary key, operation varchar(255) not null); Create table service(wid char(9), type varchar2(20), constraint service_type. Check(type in ("cooking", "babysitting", "maid_in")), primary key(wid), foreign key(wid) Create table requires(mid char(9), wid char(9), primary key(mid,wid), foreign. Create table repair_w(wid char(9) primary key,details varchar(255), foreign. Create table cottage(n_bed number not null, address varchar(100) not null, rent. Number(9,2) not null, c_num char(9) primary key, on_id char(9), wid char(9), eid. Foreign key(on_id) references owner, foreign key(wid) references work, foreign. Create table assignment(aid char(9), eid char(9), wid char(9), primary key(aid), a_date. Date not null, hours number(9), foreign key(eid) references employee, foreign.