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 VARCHAR2(100),
ContactDetails VARCHAR2(200),
-- Other personal information fields
);
CREATE TABLE Role (
RoleID NUMBER PRIMARY KEY,
Description VARCHAR2(100)
);
CREATE TABLE Function (
FunctionID NUMBER PRIMARY KEY,
Description VARCHAR2(100),
CertificationRequired VARCHAR2(100)
);
CREATE TABLE Event (
EventID NUMBER PRIMARY KEY,
Name VARCHAR2(100),
Location VARCHAR2(200),
Schedule DATE
);
CREATE TABLE WorkingSchedule (
ScheduleID NUMBER PRIMARY KEY,
VolunteerID NUMBER,
Date DATE,
StartTime TIME,
EndTime TIME,
Location VARCHAR2(200),
FOREIGN KEY (VolunteerID) REFERENCES Volunteer(VolunteerID)
);
CREATE TABLE Assignment (
AssignmentID NUMBER PRIMARY KEY,
VolunteerID NUMBER,
FunctionID NUMBER,
StartDate DATE,
EndDate DATE,
FOREIGN KEY (VolunteerID) REFERENCES Volunteer(VolunteerID),
FOREIGN KEY (FunctionID) REFERENCES Function(FunctionID)
);
CREATE TABLE Certification (
CertificationID NUMBER PRIMARY KEY,
Name VARCHAR2(100),
Description VARCHAR2(200)
);
CREATE TABLE VolunteerCertification (
VolunteerID NUMBER,
CertificationID NUMBER,
DateObtained DATE,
ExpiryDate DATE,
PRIMARY KEY (VolunteerID, CertificationID),
FOREIGN KEY (VolunteerID) REFERENCES Volunteer(VolunteerID),
FOREIGN KEY (CertificationID) REFERENCES Certification(CertificationID)
);
CREATE TABLE FunctionCertification (
FunctionID NUMBER,
CertificationID NUMBER,
PRIMARY KEY (FunctionID, CertificationID),
FOREIGN KEY (FunctionID) REFERENCES Function(FunctionID),
FOREIGN KEY (CertificationID) REFERENCES Certification(CertificationID)
);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!