Report Explaining the Data Model for Creating a Conference Database
Report Explaining the Data Model for Creating a Conference Database
Report Explaining The Data Model For Creating A Conference Database
Loughborough University Department of Information Science
Cherry Louise Maguire-A913339
3/1/2011
Contents
Introduction
2.0 Background
3.0 Entity Relationship Diagram
4.0 Justification
4.1 Seminar Table
Seminar Table
4.2 Workshop Table
Workshop Table
4.3 Chair/Speakers Table
Chair Table
Speakers Table
4.4 Workshop presenters Table
Workshop Presenters Table
4.5 Presentation Table
Presentation Table
4.6 Exhibitions Table
Exhibitions Table
4.6 Exhibitors Table
Exhibitors Table
4.6 Delegates Table
Delegates Table
4.6 Costs Table
Costs Table
Introduction
This report includes an explanation of a data model for a Conference database. The report will include my rationale behind the database design I have chosen, including an entity-relationship diagram and the expected structure of my database.
2.0 Background
Loughborough Universitys Department of Information Science annually hosts a seminar to students, staff and members of the public. This seminar is held on ‘Electronic Public Information Provision and is typically a one-day event which has proved popular due to the events and extras included. The day includes presentations presented by various speakers, an exhibition and an array of workshops. Throughout the event, day refreshments are available to all attendees, as well as a buffet lunch. I have been assigned the task of designing and creating a model that will enable the storage of data relating to the event.
3.0 Entity Relationship Diagram
See Attached.
Attached is my entity-relationship diagram which presents all entities I have chosen and their related attributes which I have designed for the Conference database. The squares represent the entities, the circles represent the attributes and the diamonds represent the relationships between the entities. I have also provided either a ‘1 or infinity symbol to represent the relationships further.
4.0 Justification
I have designed the entity-relationship diagram on page 4 to show the relationships, tables, and attributes to which I shall use to create a database.
4.1 Seminar Table
Seminar Table
Field Name
Data Type
Field Size
Indexed
Format
Validation Rule
Required
Caption
SeminarID
AutoNumber
Yes (No Duplicates)
Speaker
Seminar
E.g. IMBS Seminar 2011
ExhibitionsID
AutoNumber
Yes (No Duplicates)
Medium