Management Information Systems Assignment Report

115. 107 Management Information Systems Assignment Report Contents Part 1 †ER Diagram2 Part 2 †Tables and Keys3 Part 3 †Queries4 Part 4: Spreadsheet channels and turn tables7 List of Figures Figure 1 †ER graph for occasion the board arrangement of hotel2 Figure 2 †Query 1 QBE for staff allocation4 Figure 3 †Query 1 yield for staff allocation4 Figure 4 †Query 2 QBE for planned occasions start of October5 Figure 5 †Query 2 yield for booked occasions start of October5 Figure 6 †Query 2 database report for planned occasions start of October6Figure 7 †Query 3 QBE for complete number of enlisted participants6 Figure 8 †Query 3 yield for all out number of enrolled participants7 Figure 9 †Spreadsheet information without any filers or restrictive designing applied7 Figure 10 †Spreadsheet with the â€Å"show just occasions beginning after fifteenth October channel applied7 Figure 11 †Spreadsheet with the ‘show just oc casions initiating after first November as underlined' contingent organizing applied8 Figure 12 †Pivot table8 Figure 13 †Pivot table as a bar chart8 List of TablesTable 1 †Attributes for ER outline for occasion the executives arrangement of hotel2 Table 2 †Attributes for ER outline for occasion the board arrangement of hotel3 Part 1 †ER Diagram StaffMember Venue Event Registration Attendee Reserved for Manages Accept Makes Applies to 1.. * 1.. * 1 0.. * 0.. * 0.. * 0.. * Payment Accept 0.. * 0.. * 1 Gains section Client System Presents 0.. * Record Details 1 0.. * Inputs 1.. * 1.. * Figure [ 1 ] †ER chart for occasion the board arrangement of inn Table [ 1 ] †Attributes for ER graph for occasion the executives arrangement of inn Entity Type| Attributes| Key attribute|Venue| venueID, venueCapacity, venueDescription| venueID| Event| eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee| eventide| StaffMember | staffID, firstName, lastName, jobTitle | staffID| Registration | registrationID, registrationDate, eventID | registrationID| Attendee| attendeeID, firstName, lastName, title, companyName, contactAddress, phoneNo | attendeeID| Payment| paymentAmount, paymentDate, paymentType, paymentCredit, creditcardID, creditcardName, creditcardExpiry| paymentID| Client| clientName, companyName, contactAddress, contactPhone, clientIndustry, clientNeeds| clientID| System| systemClient, systemAttendee, systemVenues, systemInvoice, | systemID| Part 2 †Tables and Keys Table [ 2 ] †Attributes for ER outline for occasion the executives arrangement of lodging Table| Column| Primary Key| Comments|VenueTbl| venueID, venueCapacity, venueDescription| venueID| | EventTbl| eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee, staffID| eventID| staffID is a remote key into StaffMemberTbl. | StaffMemberTbl| staffID, firstName, lastName, jobTitle | staffID| | RegistrationTbl| registrationID, registrationDate ,eventID, attendeeID| registrationID| eventID is an outside key into EventTbl while attendeeID is a remote key into AttendeeTbl| attendeeID, firstName, lastName, title, companyName, contactAddress, phoneNo, eventID, registrationID| attendeeID| RegistrationID is an outside key into RegistrationTbl while occasion ID is a remote key into EventTbl. ReservedforTbl| eventID, venueID, attendeeID, | reserveID| eventID is an outside key into EventTbl while attendeeID is a remote key into AttendeeTbl| Part 3 †Queries Query 1 - StaffAllocation Figure [ 2 ] †Query 1 QBE for staff distribution Figure [ 3 ] †Query 1 yield for staff allotment Query 2 †YearEndSchedule Figure [ 4 ] †Query 2 QBE for planned occasions start of October Figure [ 5 ] †Query 2 yield for booked occasions start of October **For obscure reasons, occasion 9, 16 and 17 isn't recorded in the item in any event, when the date falls inside the range a s set out in the measures. I have endeavored to change the models choice to cover between the date scope of 30/09/2011 †01/01/2050 and so on however it has still neglected to come up. Inquiry 2 †Year End ReportFigure [ 6 ] †Query 2 database report for planned occasions start of October Query 3 †Registration Numbers Figure [ 7 ] †Query 3 QBE for all out number of enlisted members Figure [ 8 ] †Query 3 yield for all out number of enrolled members Part 4: Spreadsheet channels and turn tables Figure [ 9 ] †Spreadsheet information without any filTers or restrictive designing applied Figure [ 10 ] †Spreadsheet with the show just occasions initiating after fifteenth October channel applied Figure [ 11 ] †Spreadsheet with the ‘show just occasions beginning after first November as underlined' contingent arranging applied Figure [ 12 ] †Pivot table Figure [ 13 ] †Pivot table as a bar diagram