Database Discussion 2022

Ruining head: DATABASE
Databases
Name of the Student:
Name of the Organization:
Author Note

1
DATABASE
Part 1: Revised ERD and schema
ERD
Discussion
The revised ERD has been created that would be helpful in distinguishing the members
who are attendees and the members which was not done in the previous version of the ERD. In
addition to this, the previous ERD had the information about the services which have been
omitted from this ERD as the information have been further manipulated and this ERD has been
developed in such a way so that values for the events and the members are authentic.

2
DATABASE
3NF Schema
Member (MemberID (pk), FirstName, LastName, PhoneNumber, MemberAddress, Suburb,
Skills)
Event (EventID (pk), Title, Leader, Date, Location, Type, PostCode, Instructions,
GuestAttendance, MemberAttendance, UnfilledPlaces)
Organizer (OragnizerID (pk), MemberID (fk), EventID (fk))
Attendees (AttendeeID (pk), MemberID (fk), EventID (fk))
Equipment (EquipmentID (pk), Name, Rate)
Loan (LoanID (pk), EquipmentID (fk), MemberID (fk), NoOfDays)
Part 2: Data dictionary
Member
Attribute DataType Size NULL/NOT
NULL
Key
MemberID number 10 NOT NULL Primary key
FirstName Varchar2 50 NOT NULL
LastName Varchar2 50 NOT NULL
MemberAddress Varchar2 50 NOT NULL
Suburb Varchar2 50 NOT NULL
Skill Varchar2 50 NOT NULL
Event

3
DATABASE
Attribute DataType Size NULL/NOT
NULL
Key
EventID number 10 NOT NULL Primary key
Title Varchar2 50 NOT NULL
Leader Varchar2 50 NOT NULL
EventDate Date NOT NULL
Location Varchar2 50 NOT NULL
Type Varchar2 50 NOT NULL
PostCode number 10 NOT NULL
Instruction Varchar2 150 NOT NULL
GuestAttendance Varchar2 50 NOT NULL
MemberAttendanc
e
Varchar2 50 NOT NULL
UnfilledPlaces Varchar2 50 NOT NULL
Attendee
Attribute DataType Size NULL/NOT
NULL
Key
AttendeeID number 10 NOT NULL Primary key
MemberID number 10 NOT NULL Foreign key
EquipmentID number 10 NOT NULL Foreign key