Data and Information Management- Doc

Student ID –
Date -
Assignment 2
Data and Information Management
Module Tutor –
1 | P a g e

Report
1 A) Database Entities
1. Participant: It is storing the data related to participants.
2. Workshop: It is storing the data related to workshops.
3. Organizer: It is storing the data related to organizers who are organizing the
workshops.
4. ParticipantWorkshop: It is storing the data related to participants and their
workshops.
5. MeetingRoom: It is storing the data related to meeting rooms in which the workshops
held.
6. WorkshopSchedule: It is storing the data related to schedule of workshops e.g. start
date, end date etc.
7. WorkshopRoom: It is storing the data related to workshops and meeting rooms in
which the workshops held.
1 B) Tables and Attributes
Participant (ParticipantID, ParticipantName, Address, State, Email, Phone)
Organizer (OrganizerD, OrganizerName, Address, State, Email, Phone)
Workshop (WorkshopID, WorkshopName, OrganizerID)
Participant Workshop (ParticipantID, WorkshopID)
WorkshopSchedule (WorkshopID,StartDate, EndDate, Days)
MeetingRoom (MeetingRoomID, FloorNumber, ConVenue, Space)
WorkshopRoom (WorkshopID, RoomNumber, StartDate, EndDate)
2 | P a g e

1 C) Business Rules
Following business rules are used in the database design-
- Each participant will participate in at least one workshop.
- The participant may participate in more than one workshop.
- An organizer may organize any number of workshops.
- The workshop may last for more than 1 day.
- The workshop will held in one room for all days.
1 D) Functional Dependency
ParticipantID  ParticipantName, Address, State, Email, Phone
OrganizerD  OrganizerName, Address, State, Email, Phone
WorkshopID  WorkshopName, OrganizerID, StartDate, EndDate, Days, RoomNumber
MeetingRoomID  FloorNumber, ConVenue, Space
(Janalta Interactive Inc. 2015)
1 E) Normalise Tables
First Normal Form
First normal form is achieved by applying following rules-
- Delete the repeated group from tables and make new tables.
- Set primary key in all newly created tables.
Second Normal Form
Second normal form is achieved by applying following rules-
- Make sure that all tables are in first normal form.
- All fields depend upon the primary key only.
Third Normal Form
Third normal form is achieved by applying following rules-
3 | P a g e