ITEC 3220 Quiz: Assignment 1 Official Solution
Document Summary
Create table owner(onid char(3), name varchar2(10), address varchar2 (20), primary key(onid)); Create table cottage_p(cnum char(3), rent number(6,2), nbed number(1), Address varchar2 (20), category number(1) check (category in (1,2,3,4,5)), onid char(3), primary key(cnum),foreign key(onid) Create table equipment_b (eqid char(3), title varchar2(10), year number(4),cnum char(3),primary key(eqid),foreign key (cnum) references. Create table record (eqid char(3), rnum number(2), description varchar2(20), primary key (eqid, rnum), foreign key (eqid) references. Create table work (wid char(3) primary key, operation varchar2(15)); Create table repair_w (wid char(3), details varchar2(30), primary key (wid), foreign key(wid) references work on delete cascade); Create table service (wid char(3), type varchar(11) check (type in ("cooking","babysitting","maid_in")), primary key (wid), foreign key (wid) references work on delete cascade); Create table is_done (eqid char(3), rnum number(2), rdate date, wid char(3), primary key (eqid,rnum,wid), foreign key (eqid,rnum) Create table customer (cid char(3), name varchar2(20), phone char(10), Create table employee_r(eid char(9), name varchar2(20), salary number (7,2), mid char(9), primary key (eid), foreign key (mid) references.
