Consider the following relational database schema written in Oracle SQL for an online book store… 1 answer below »

Consider the following relational database schema written in Oracle SQL for an online book store application:

drop table books cascade constraints;

create table books (

isbn char(10),

author varchar2(100) not null,

title varchar2(128) not null,

price number(7,2) not null,

subject varchar2(30) not null,

primary key (isbn)

);

drop table members cascade constraints;

create table members (

fname varchar2(20) not null,

lname varchar2(20) not null,

address varchar2(50) not null,

city varchar2(30) not null,

state varchar2(20) not null,

zip number(5) not null,

phone varchar2(12),

email varchar2(40),

userid varchar2(20),

password varchar2(20),

creditcardtype varchar2(10)

check(creditcardtype in (‘amex’,’discover’,’mc’,’visa’)),

creditcardnumber char(16),

primary key (userid)

);

drop table orders cascade constraints;

create table orders (

userid varchar2(20) not null,

ono number(5),

received date not null,

shipped date,

shipAddress varchar2(50),

shipCity varchar2(30),

shipState varchar2(20),

shipZip number(5),

primary key (ono),

foreign key (userid) references members

Attachments:

You don't know how to answer this question. We can help you find the right answer.

We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code "save15" for a 15% Discount!

Get Started

No need to wonder who can do my homework. You can always reach our team of professionals to do your homework at a low price.