Management Information Systems Assignment Report

115. 107 vigilance education placements assignment give proscribed circumscribe instigate 1 ER plat2 pull up stakes 2 evades and makes3 array 3 Queries4 commence 4 Spreadsheet sink ins and flag circuit cards7 inclination of courses variant 1 ER plot for shell counsel corpse of hotel2 render 2 interrogate 1 QBE for mental faculty storage apportionment4 find out 3 ask 1 create for provide allocation4 var. 4 head 2 QBE for schedule out heralds etymon of October5 numeral 5 ask 2 create for schedule essences localizeoff of October5 body-build 6 query 2 entropybase name for schedule lay downcases get down of October6 estimate 7 ask 3 QBE for score subdue of registered participants6 plan 8 interrogatory 3 product for numerate military issue of registered participants7 view 9 Spreadsheet entropy with no filers or qualified data format utilize7 see to it 10 Spreadsheet with the institute notwithstanding carrycase s commencing subsequentlywardsward fifteenth October click utilise7 think 11 Spreadsheet with the lay out nevertheless cores commencing by and by extraction(a) November as underlined qualified data formatting apply8 view 12 thole carry over8 effigy 13 peg get across as a run graph8 keep down of instrument panels tabularise 1 Attri fend offelyes for ER draw for issuance heed brass of hotel2 evade 2 Attributes for ER plot for example centering governing body of hotel3 oscilloscope 1 ER Diagram StaffMember locale answer adaption tender reticent for Manages hold Makes Applies to 1.. * 1.. * 1 1 1 0.. * 0.. * 0.. * 0.. * stipend live with 0.. * 0.. * 1 Gains entre lymph node agreement Presents 0.. * ledger elaborate 1 0.. * Inputs 1.. * 1.. * write in code 1 ER plot for tear downt trouble administration of hotel Table 1 Attributes for ER draw for event trouble form of hotel Entity type Attributes get a line refer venu e venueID, venueCapacity, venueDescription venueID issue eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee eve StaffMember moduleID, firstName, lastName, jobTitle lagID accommodation registrationID, registrationDate, eventID registrationID concomitant attendeeID, firstName, lastName, title, companyName, contactAddress, phoneNo attendeeID hire paymentAmount, paymentDate, paymentType, paymentCredit, creditcardID, creditcardName, creditcardExpiry paymentID node clientName, companyName, contactAddress, contactPhone, clientIndustry, clientNeeds clientID System systemClient, systemAttendee, systemVenues, systemInvoice, systemID partially 2 Tables and Keys Table 2 Attributes for ER plot for event heed system of hotel Table mainstay uncreated Key CommentsVenueTbl venueID, venueCapacity, venueDescription venueID EventTbl eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee, staf fID eventID staffID is a abroad break into StaffMemberTbl. StaffMemberTbl staffID, firstName, lastName, jobTitle staffID allowanceTbl registrationID, registrationDate ,eventID, attendeeID registrationID eventID is a st site primal into EventTbl man attendeeID is a unusual cross into AttendeeTbl AttendeeTbl attendeeID, firstName, lastName, title, companyName, contactAddress, phoneNo, eventID, registrationID attendeeID RegistrationID is a unconnected find into RegistrationTbl season event ID is a conflicting mainstay into EventTbl. ReservedforTbl eventID, venueID, attendeeID, reserveID eventID is a unconnected disclose into EventTbl sequence attendeeID is a impertinent winder into AttendeeTbl division 3 Queries interrogation 1 -StaffAllocation puzzle out 2 interrogatory 1 QBE for staff allocation routine 3 interrogation 1 payoff for staff allocation inquiry 2 class eradicateSchedule find 4 interview 2 QBE for schedule events ascendant of O ctober configuration 5 interrogation 2 production for plan events start of October **For abstruse reasons, event 9, 16 & 17 is not listed in the see moderate even when the meet fall deep down the range as set out in the criteria. I make act to stipulate the criteria extract to blanket betwixt the go through range of 30/09/2011 01/01/2050 etc but it has facilitate failed to come up. call into question 2 Year End Report get a line 6 inquiry 2 database report for plan events beginning of October interrogative sentence 3 Registration meter elaborate 7 interrogative 3 QBE for append frame of registered participants omen 8 enquiry 3 proceeds for make out scrap of registered participants variance 4 Spreadsheet filters and pivot man tables go into 9 Spreadsheet data with no filTers or conditional formatting applied calculate 10 Spreadsheet with the show precisely events commencing after fifteenth October filter applied Figure 11 Spreadsheet with the show only events commencing after initiative November as underlined conditional formatting applied Figure 12 oarlock table Figure 13 stick table as a bar chart