Question: Create an erm diagram for the following sql code CREATE TABLE Volunteer ( VolunteerID NUMBER PRIMARY KEY, Name VARCHAR 2 ( 1 0 0 )
Create an erm diagram for the following sql code
CREATE TABLE Volunteer
VolunteerID NUMBER PRIMARY KEY,
Name VARCHAR
ContactDetails VARCHAR
Other personal information fields
;
CREATE TABLE Role
RoleID NUMBER PRIMARY KEY,
Description VARCHAR
;
CREATE TABLE Function
FunctionID NUMBER PRIMARY KEY,
Description VARCHAR
CertificationRequired VARCHAR
;
CREATE TABLE Event
EventID NUMBER PRIMARY KEY,
Name VARCHAR
Location VARCHAR
Schedule DATE
;
CREATE TABLE WorkingSchedule
ScheduleID NUMBER PRIMARY KEY,
VolunteerID NUMBER,
Date DATE,
StartTime TIME,
EndTime TIME,
Location VARCHAR
FOREIGN KEY VolunteerID REFERENCES VolunteerVolunteerID
;
CREATE TABLE Assignment
AssignmentID NUMBER PRIMARY KEY,
VolunteerID NUMBER,
FunctionID NUMBER,
StartDate DATE,
EndDate DATE,
FOREIGN KEY VolunteerID REFERENCES VolunteerVolunteerID
FOREIGN KEY FunctionID REFERENCES FunctionFunctionID
;
CREATE TABLE Certification
CertificationID NUMBER PRIMARY KEY,
Name VARCHAR
Description VARCHAR
;
CREATE TABLE VolunteerCertification
VolunteerID NUMBER,
CertificationID NUMBER,
DateObtained DATE,
ExpiryDate DATE,
PRIMARY KEY VolunteerID CertificationID
FOREIGN KEY VolunteerID REFERENCES VolunteerVolunteerID
FOREIGN KEY CertificationID REFERENCES CertificationCertificationID
;
CREATE TABLE FunctionCertification
FunctionID NUMBER,
CertificationID NUMBER,
PRIMARY KEY FunctionID CertificationID
FOREIGN KEY FunctionID REFERENCES FunctionFunctionID
FOREIGN KEY CertificationID REFERENCES CertificationCertificationID
;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
