Contents
INTRODUCTION 2
ENTITY- RELATIONSHIP DIAGRAM 3
List of Entities 3
Entity-Relationship Diagram one (1) 4
Entity-Relationship Diagram Two (2) 5
Entity-Relationship Diagram Three(3) 5
NORMALIZATION 7
Normalization Process 7
Un-normalized data 8
1st Normal Form 8
2nd Normal Form 9
3rd Normal Form 9
Normalized Tables 10

INTRODUCTION

Planning a wedding is one of the most exciting and most stressful events in one’s lifetime and in
Planning this there is a number of factors that need to be considered such as the guest list, venues, and suppliers. Hence on the quest to organize the scheduling and selection of activities for planning
Of weddings a database System will be designed to accommodate its operation, providing a high degree of Usability and efficiency for the people using the application within the company.

The database would be built in Oracle having forms that provide at least the minimum basic CRUD
(Create, Read, Update, and Delete) functions and the following are the specific forms required;
Basic wedding detail form, Supplier type form, Event type form, Supplier detail form, Event detail
Form along with the advanced forms such as Wedding event schedule form, wedding event guest form, wedding event supplies and company work schedule summary.

The system will be constructed from a number of normalized tables that will be used to construct the
Forms and an entity relationship diagram will be formed showing relationships between entities and
There attributes. More specifically, the system would show which client has booking for a particular
Wedding along with the suppliers and staff member assigned to set up events. It would also indicate the time period for each event and which events that will be booked by the different clients. The
System will be designed to ensure that the wedding activities being held would not be doubling
Booked or be left out entirely.

ENTITY- RELATIONSHIP DIAGRAM
An entity-relationship diagram is a data modeling technique that creates a representation of the entities, and the relationship between entities, within an information system. < http://searchcrm.techtarget.com/definition/entity-relationship-diagram> [Assessed 10 April 10, 2011]. Below will show the list of entities and the three(3) ERD for the system. List of Entities
Bride
Groom
Venue
Event
Wedding
Client
Supplier
Supplies
Staff
Guest
Supplier type
Event type
Entity-Relationship Diagram one (1) ERD 1 Entity-Relationship Diagram Two (2)

ERD 2

Entity-Relationship Diagram Three(3) ERD 3
NORMALIZATION
According to Beyon-Davies 2002 (p- 410),
“Normalization is the process of identifying the logical associations between data items and designing a database which will represent such association but without suffering from file maintenance anomalies.”
Normalization Process
The following is the normalization process which is used to achieve the principles discussed by Beyon-Davies.
1. Collection of all un-normalized data.
2. Conversion of all un-normalized data into 1NF (First Normal Form) Tables by eliminating repeating groups
3. Conversion of 1NF Tables to 2NF (Second Normal Form) Tables by eliminating redundant data.
4. Conversion of 2NF Tables to 3NF (Third Normal Form) Tables by eliminating Columns Not Dependent on the primary key.
5. Conversion of 3NF to BCNF (Boyce-Codd Normal Form) Tables if necessary.
Based on the procedure previously discussed the normalization process for the data items of the wedding planner system is shown below.
In this system there are four repeating groups present. In the UNF form entails the repeating groups present.
The 1st repeating group is Event Guest and Guest
The 2nd repeating group is Event Supplies, Supplies, Supplier, and Supplier Type
The 3rd repeating group is Event Staff and Staff
The 4th repeating group is Supplier Staff and Supplier
The 5th repeating group is Event Venue and Venue

Un-normalized data
Event(Event ID, Event Date, Event-Start Time, Event-End Time, Event-Start Venue, Event-End Venue, Event Type ID, Event Type, Wedding No, Wedding Date, Client ID, Client Name, Client Telephone, Client Address, Guest ID, Guest Name, Guest Seat Number, Venue ID, Venue Address, Venue Type ID, Staff ID, Staff Name, Staff Telephone, Staff Address Supplies ID, Supplies Description Bride ID, Bride Name, Bride Telephone, Bride Address. Groom ID, Groom Name, Groom Telephone, Groom Address, Supplier ID, Supplier Name, Supplier Telephone, Supplier Email, Supplier Address, Supplier Type ID, Supplier Type)

1st Normal Form
Event (Event ID, Event Date, Event-Start Time, Event-End Time, Event-Start Venue, Event-End Venue, Event Type ID, Event Type, Wedding No, Wedding Date, Client ID, Client Name, Client Telephone, Client Address, Bride ID, Bride Name, Bride Telephone, Bride Address. Groom ID, Groom Name, Groom Telephone, Groom Address)
Event Guest (Event ID, Guest ID, Guest Name, Guest Seat Number)
Event Supplies (Event ID, Supplies ID, Supplies Description)
Event Staff (Event ID, Staff ID, Staff Name, Staff Telephone, Staff Address)
Supplier Staff (Staff ID, Supplier ID, Supplier Name, Supplier Telephone, Suppliers Email, Suppliers Address, Supplier Type ID, Supplier Type)
Event Venue ( Event ID, Venue ID, Venue Address, Venue Type ID, Venue Type)
The 1st Link Entity present in this form is Event Guest which comprises of the Event Table and the Guest Table
The 2nd Link Entity present in this form is Event Supplies which comprises of the Event Table and the Supplies Table
The 3rd Link Entity present in this form is the Event Staff which comprises of the Event Table and the Staff Table
The 4th Link Entity present in this form is the Supplier Staff which comprises of the Supplier Table and the Staff Table.
The 5th Link Entity present in this form is the Event Venue which comprises of Event Venue Table and the Venue Table.

2nd Normal Form
Event (Event ID, Event Date, Event-Start Time, Event-End Time, Event-Start Venue, Event-End Venue, Event Type ID, Event Type, Wedding No, Wedding Date, Client ID, Client Name, Client Telephone, Client Address, Bride ID, Bride Name, Bride Telephone, Bride Address. Groom ID, Groom Name, Groom Telephone, Groom Address)
Event Guest (Event ID, Guest ID)
Guest (Guest ID, Guest Name, Guest Seat Number)
Event Supplies (Event ID, Supplies ID)
Supplies (Supplies ID, Supplies Description)
Event Staff (Event ID, Staff ID)
Staff (Staff ID, Staff Name, Staff Telephone, Staff Address)
Event Venue (Event ID, Venue ID)
Venue (Venue ID , Venue Address, Venue Type)
Supplier Staff (Staff ID, Suppliers ID,)
Supplier (Suppliers ID, Suppliers Name, Supplier Telephone, Suppliers Email, Suppliers Address, Supplier Type ID, Supplier Type)

3rd Normal Form
Event (Event ID, Event Date, Event-Start Time, Event-End Time, Event-Start Venue, Event-End Venue, Wedding No*, Event Type ID)
Event Type (Event Type ID, Event Type)
Wedding (Wedding No, Wedding Date, Client ID*)
Client (Client ID, Client Name, Client Telephone, Client Address)
Employee (Employee ID, E Name, E Telephone, E Address, E Type, Event Description)
Bride (Bride ID, Bride Name, Bride Telephone, Bride Address, Wedding No*)
Groom (Groom ID, Groom Name, Groom Telephone, Groom Address, Wedding No*)
Event Guest (Event ID*, Guest ID*)
Guest (Guest ID, Guest Name, Guest Seat Number, Event ID*)
Event Supplies (Event ID*, Supplies ID*)
Supplies (Supplies ID, Supplies Description, Supplier ID*)
Event Staff (Event ID*, Staff ID*)
Staff (Staff ID, Staff Name, Staff Telephone, Staff Address)
Event Venue (Event ID*, Venue ID*)
Venue (Venue ID ,Venue Address, Venue Type)
Supplier Staff (Staff ID*, Suppliers ID*)
Supplier (Supplier ID, Supplier Name, Supplier Telephone, Supplier Email, Supplier Address, Supplier Type ID*)
Supplier Type (Supplier Type ID, Supplier Type)

Normalized Tables
The following tables shows the tables formed after normalization together with their respective primary and foreign keys.
TABLE NAME PRIMARY KEY FOREIGN KEY
EVENT Event Id Wedding ID
EVENT TYPE Event Type ID _
WEDDING Wedding NO Client ID
CLIENT Client ID _
EMPLOYEE Employee ID _
BRIDE Bride ID Wedding NO
GROOM Groom ID Wedding NO
EVENT GUEST Event ID(PF) Guest ID(PF)
GUEST Guest ID _
EVENT SUPPLIES Event ID(PF) Supplies ID(PF)
SUPPLIER Supplier ID Supplies ID
EVENT STAFF Event ID(PF) Staff ID(PF)
STAFF Staff ID _
EVENT VENUE Event ID(PF) Venue ID(PF)
VENUE Venue ID _
SUPPLIER STAFF Supplier ID(PF) Staff ID(PF)
SUPPLIER SupplierID Supplier Type ID
SUPPLIER TYPE Supplier Type ID