Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
PLZ help with the following: Using Oracle SQL developper Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriatedata types for each attribute and include primary key and foreign key constraints, Check and NotNull constraints.

PLZ help with the following: Using Oracle SQL developper Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriatedata types for each attribute and include primary key and foreign key constraints, Check and NotNull constraints.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

PLZ help with the following:

Using Oracle SQL developper

  1. Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriatedata types for each attribute and include primary key and foreign key constraints, Check and NotNull constraints.

Package Task Packages • Package_ID Package_Date Total_Weight Tasks PF* Package_ID PF* Task_ID P' Task_ID INTEGER INTEGER INTEGER Volunteer_Task Task Name VARCHAR2 (20) INTEGER DATE PF* Volunteer_ID PF* Task_ID INTEGER Task_Start_Time Task_End_Time • Tasktype_code DATE a Package_Task_PK (Package_ID, Task_ID) Package Task_Tasks_FK (Task_ID) Package Task_Packages_FK (Package_ID) INTEGER INTEGER DATE P Packages_PK (Package_ID) O Package_Taskv1_PK (Volunteer_ID, Task_ID) Volunteer Task_Volunteer_FK (Volunteer_ID) Volunteer_Task_Tasks_FK (Task_ID) INTEGER - Tasks PK (Task ID) Tasks_Tasktype_FK (Tasktype_code) V Items Package_Items Volunteer PF* Package_ID PF Item_ID P Item ID Item_Description Item_Value Item_Quantity P• Volunteer_ID INTEGER INTEGER INTEGER Tasktype P* Tasktype_code VARCHAR2 (20) VARCHAR2 (30) INTEGER Volunteer_Name Other Details INTEGER VARCHAR2 (20) INTEGER - Package_ltems_PK (Package_ID, Item_ID) INTEGER - Volunteer_PK (Volunteer_ID) - Tasktype_PK (Tasktype_code) Items_PK (Item_ID) Package_Items_Packages_FK (Package_ID) Package_Items_ltems_FK (tem_ID)
Transcribed Image Text:Package Task Packages • Package_ID Package_Date Total_Weight Tasks PF* Package_ID PF* Task_ID P' Task_ID INTEGER INTEGER INTEGER Volunteer_Task Task Name VARCHAR2 (20) INTEGER DATE PF* Volunteer_ID PF* Task_ID INTEGER Task_Start_Time Task_End_Time • Tasktype_code DATE a Package_Task_PK (Package_ID, Task_ID) Package Task_Tasks_FK (Task_ID) Package Task_Packages_FK (Package_ID) INTEGER INTEGER DATE P Packages_PK (Package_ID) O Package_Taskv1_PK (Volunteer_ID, Task_ID) Volunteer Task_Volunteer_FK (Volunteer_ID) Volunteer_Task_Tasks_FK (Task_ID) INTEGER - Tasks PK (Task ID) Tasks_Tasktype_FK (Tasktype_code) V Items Package_Items Volunteer PF* Package_ID PF Item_ID P Item ID Item_Description Item_Value Item_Quantity P• Volunteer_ID INTEGER INTEGER INTEGER Tasktype P* Tasktype_code VARCHAR2 (20) VARCHAR2 (30) INTEGER Volunteer_Name Other Details INTEGER VARCHAR2 (20) INTEGER - Package_ltems_PK (Package_ID, Item_ID) INTEGER - Volunteer_PK (Volunteer_ID) - Tasktype_PK (Tasktype_code) Items_PK (Item_ID) Package_Items_Packages_FK (Package_ID) Package_Items_ltems_FK (tem_ID)
Natural Disasters Management Primary Key Foreign Key Composite Key many Volunteer_Task {Volunteer_ID Task_ID many Package_Task many Package ID Task ID many Package_Items Package ID Volunteer Tasks Packages Package_ID Package Date Total_Weight one one one one Task ID Volunteer_ID Volunteer Name one Other Details eiven given many has has has Task Name Item ID Task Start_Time Task_End_Time Tasktype_code many has many has many Items Item_ID Item_Description Item_Value Item_Quantity one Tasktype Tasktype_code
Transcribed Image Text:Natural Disasters Management Primary Key Foreign Key Composite Key many Volunteer_Task {Volunteer_ID Task_ID many Package_Task many Package ID Task ID many Package_Items Package ID Volunteer Tasks Packages Package_ID Package Date Total_Weight one one one one Task ID Volunteer_ID Volunteer Name one Other Details eiven given many has has has Task Name Item ID Task Start_Time Task_End_Time Tasktype_code many has many has many Items Item_ID Item_Description Item_Value Item_Quantity one Tasktype Tasktype_code
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS