prueba case study

Jun 21st, 2015
Studypool Tutor
Allied American University
Price: $30 USD

Tutor description

create database test; use test; CREATE TABLE authors ( au_id varchar(11) not null CHECK (au_id like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'), au_lname varchar(40) NOT NULL, au_fname varchar(20) NOT NULL, phone char(12) NOT NULL DEFAULT 'UNKNOWN', address varchar(40) NULL, city varchar(20) NULL, state char(2) NULL, zip char(5) NULL .

Word Count: 3539
Showing Page: 1/12
create database test; use test; CREATE TABLE authors ( au_id varchar(11) not null CHECK (au_id like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'), au_lname varchar(40) NOT NULL, au_fname varchar(20) NOT NULL, phone char(12) NOT NULL DEFAULT 'UNKNOWN', address varchar(40) NULL, city varchar(20) NULL, state char(2) NULL, zip char(5) NULL CHECK (zip like '[0-9][0-9][0-9][0-9][09]'), contract bit NOT NULL, CONSTRAINT UPKCL_auidind PRIMARY KEY (au_id) ); CREATE TABLE publishers ( pub_id char(4) NOT NULL CHECK (pub_id in ('1389', '0736', '0877', '1622', '1756') OR pub_id like '99[0-9][0-9]'), pub_name varchar(40) NULL, city varchar(20) NULL, state char(2) NULL, country varchar(30) NULL DEFAULT 'USA', CONSTRAINT UPKCL_pubind PRIMARY KEY (pub_id) ); CREATE TABLE titles ( title_id varchar(6) NOT NULL, title varchar(80) NOT NULL, type char(12) NOT NULL DEFAULT 'UNDECIDED', pub_id char(4) NULL REFERENCES publishers(pub_id), price numeric NULL, advance numeric NULL, royalty int NULL, ytd_sales int NULL, notes varchar(200) NULL, pubdate timestamp NOT NULL DEFAULT current_timestamp, CONSTRAINT UPKCL_titleidind PRIMARY KEY (title_id) ); CREATE TABLE titleauthor ( au_id varchar(11) NOT NULL title_id varchar(6) NOT NULL au_ord tinyint NULL, royaltyper int NULL,REFERENCES authors(au_id), REFERENCES titles(title_id),CONSTRAINT UPKCL_taind PRIMARY KEY (au_id, title_id) ); CREATE TABLE stores ( stor_id char(4) NOT NULL, stor_name varchar(40) NULL, stor_address varchar(40) NULL, city var

Review from student

Studypool Student
" Excellent work as usual "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors