Management Information Systems Assignment Report

115.107 Management Information Systems Assignment Report

Contents Part 1 – ER Diagram 2 Part 2 – Tables and Keys 3 Part 3 – Queries 4 Part 4: Spreadsheet filters and pivot tables 7

List of Figures Figure 1 - ER diagram for event management system of hotel 2 Figure 2 - Query 1 QBE for staff allocation 4 Figure 3 - Query 1 output for staff allocation 4 Figure 4 - Query 2 QBE for scheduled events beginning of October 5 Figure 5 - Query 2 output for scheduled events beginning of October 5 Figure 6 - Query 2 database report for scheduled events beginning of October 6 Figure 7 - Query 3 QBE for total number of registered participants 6 Figure 8 - Query 3 output for total number of registered participants 7 Figure 9 - Spreadsheet data with no filers or conditional formatting applied 7 Figure 10 - Spreadsheet with the "show only events commencing after 15th October filter applied 7 Figure 11 - Spreadsheet with the 'show only events commencing after 1st November as underlined' conditional formatting applied 8 Figure 12 - Pivot table 8 Figure 13 - Pivot table as a bar chart 8

List of Tables Table 1 - Attributes for ER diagram for event management system of hotel 2 Table 2 - Attributes for ER diagram for event management system of hotel 3

Part 1 – ER Diagram StaffMember
Venue
Event
Registration
Attendee
Reserved for
Manages
Accept
Makes
Applies to
1..*
1..*
1
1
1
0..*
0..*
0..*
0..*
Payment
Accept
0..*
0..*
1
Gains entry
Client
System
Presents
0..*
Record Details
1
0..*
Inputs
1..*
1..*

Figure [ 1 ] - ER diagram for event management system of hotel Table [ 1 ] - Attributes for ER diagram for event management system of hotel Entity Type | Attributes | Key attribute | Venue | venueID, venueCapacity, venueDescription | venueID | Event | eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee | eventide | StaffMember |