plz help fix the following use oracle plz create table volunteer( Vol_ID int NOT NULL, name varchar(20), Telephone varchar(12), Address varchar(40), primary key(Vol_ID)); create table item( Item_ID int NOT NULL, Description varchar(20), value int NOT NULL, quantity int NOT NULL, primary key(Item_ID)); create table Packinglist( List_ID int NOT NULL, name varchar(20), description varchar(30), primary key(List_ID)); create table Task( Task_code varchar(10) NOT NULL, list_ID varchar(20), task_description varchar(12), type varchar(10), status varchar(10), primary key(Task_code), foreign key(List_ID) references Packinglist); create table Package( pack_ID int NOT NULL, task_code varchar(20), date date, weight int NOT NULL, primary key(pack_ID), foreign key(task_code references task); create table assignment( Vol_ID int NOT NULL, task_code varchar(20) NOT NULL, start_time DateTime, end_time DateTime(40) , primary key(Vol_ID,task_code), foreignkey(Vol_ID) references volunteer, foreign key(task_code) references Task, constraint check_time check(start_time < end_time)); create table content( pack_ID int NOT NULL, item_id int NOT NULL, quantity int NOT NULL primary key(PACK_ID,item_ID), foreign key(pack_id) references package, foreign key (item_ID) references item);

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

plz help fix the following use oracle plz

create table volunteer(
Vol_ID int NOT NULL,
name varchar(20),
Telephone varchar(12),
Address varchar(40),
primary key(Vol_ID));

create table item(
Item_ID int NOT NULL,
Description varchar(20),
value int NOT NULL,
quantity int NOT NULL,
primary key(Item_ID));

create table Packinglist(
List_ID int NOT NULL,
name varchar(20),
description varchar(30),
primary key(List_ID));

create table Task(
Task_code varchar(10) NOT NULL,
list_ID varchar(20),
task_description varchar(12),
type varchar(10),
status varchar(10),
primary key(Task_code),
foreign key(List_ID) references Packinglist);

create table Package(
pack_ID int NOT NULL,
task_code varchar(20),
date date,
weight int NOT NULL,
primary key(pack_ID),
foreign key(task_code references task);

create table assignment(
Vol_ID int NOT NULL,
task_code varchar(20) NOT NULL,
start_time DateTime,
end_time DateTime(40) ,
primary key(Vol_ID,task_code),
foreignkey(Vol_ID) references volunteer,
foreign key(task_code) references Task,
constraint check_time check(start_time < end_time));

create table content(
pack_ID int NOT NULL,
item_id int NOT NULL,
quantity int NOT NULL
primary key(PACK_ID,item_ID),
foreign key(pack_id) references package,
foreign key (item_ID) references item);

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions