Assignment 3 Database management systems

Assignment 3




Database Management Systems
UU-COM-2015-MW

, Question 1.1
The following are the data requirements for the database:


1. Events will have the following data requirements:
 Event ID
 Event Name
 Event Type (music, theatre, performance, poetry, amateur film)
 Event Date and Time
 Event Manager (with relationship to staff member)
 Host (Linked to a host)
 Sponsoring Agent
 Location


2. Staff Members will have the following data requirements:
 Staff ID
 Staff Name
 Contact Information


3. Host will have the following data requirement:
 Host ID
 Host Name
 Host Type (local resident or international)
 Frequency (how often they host events)




4. Sponsoring Agents will have the following data requirement:
 Agent ID
 Agent Name
 Contact Information