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

Future free essay sample

Have you at any point wanted something actually profoundly and went foward to get it however needed to confront zillions of preliminaries to get it? Well if this has occured to you thenyou know precisely what I mean.In my supposition, so as to forestall hard future desicions why not pick now?I made my desicion and it is being a Surgeon sometime in the not so distant future; I chose to pick being a specialist as my desire since its ideal from all edges, for example, cash insightful, measures, and envisioned. I love to assist individuals out of luck and I found that this activity will help other people and will likewise then again I will do my dharma. Because of my point of view, consideration is unequivocally required to advantages to being a specialist. Perhaps we get forgived, acknowledgment however getting one more opportunity from time is conceivably unimaginable along these lines, the primary advantage I would reccomend is the measures. In what capacity will I be certain that my given $20 will take care of business in changing the binds of any of these shocking onlooking families? No, it mustnt stop there. Envision strolling by dead bodies and each time pondering, Could this be my sister? No, my advantage isn't in how dismal as well as cool the calling is however in helping families, who have lost friends and family, with conclusion. In any case, our reality is likewise isolated. Riches is just an opportunity of birth, and a large number of us just have a dubious perspective on how the vast majority of the world isnt so fortunate. There is the side whose greatest concerns are everyday social and scholastic burdens. At that point there is the opposite side: those nations that lie inverse our nation on the monetary range. They lie so beyond our fringe vision that its hard for the vast majority of us to have any genuine comprehension of their circumstances. Be that as it may, the two sides do share something for all intents and purpose: they are in danger for similar calamities we are. For individuals in such previously disintegrating conditions, these catastrophes can be multiple times all the more destroying. In that sense, friends and family can be multiple times harder to discover. The restricted assets of these underdeveloped nations has enlivened a thought of how I can help on the worldwide level: possibly one day I can set up dental frameworks around the globe, for both sterile and recognizable proof purposes, so that during times of fear based oppression, catastrophic events, and different disasters that happen globally, I will have the option to help individuals in those circumstances, any place they might be. Individuals whine that my fantasies are too large to be possible however I discover their perspectives irrational. All things considered, why just keep ourselves acquainted with the little level of the world we experience on a typical premise? On the off chance that we were intended to do only that, at that point for what reason was the world made to be so enormous, with such a significant number of better places and individuals? Simple, we were intended to encounter them.

FAQ

FAQ I got this question over email, which echoes questions Ive been hearing all over: Ive just read your post saying that the selection process has begun. Does that mean that everything else, including mid-year reports that were sent recently will not be considered? Midyear reports absolutely will be considered, even if they have not yet arrived in the Admissions Office. For students for whom midyear grades are a big question, we will set aside the case with a MYG (midyear grades) note, and reconsider it as soon as we have received and reviewed the midyear grades. For other students whose grades have been consistent, we will make a decision on the case; when the midyear grades later come in, we will review them, and the decision will be reviewed if there is an aberration in the midyears. We understand that sending in midyear grades may take longer to process in some school systems this may take longer than in others; there is no deadline for receiving the grades other than as soon as you can. The bottom line is: Please send in your midyear grades as soon as they are available, we will consider them. It is too late for any supplemental materials to be considered by the selection committee. However, an admissions officer will continue to review anything you send in as a supplement. I think it is important to remember, however, that if you have completed your application, we have everything that we need to make a decision on your case. I get the sense that some students feel like a supplement is almost required for admission, but this just isnt the case. A complete application is all we need.