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 outline for occasion the executives 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 booked occasions start of October6Figure 7 †Query 3 QBE for all out 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 ju st occasions 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 graph for occasion the executives arrangement of hotel2 Table 2 †Attributes for ER graph for occasion the executives 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 passage Client System Presents 0.. * Record Details 1 0.. * Inputs 1.. * 1.. * Figure [ 1 ] †ER chart for occasion the executives arrangement of lodging Table [ 1 ] †Attributes for ER graph for occasion the board arrangement of inn Entity Type| Attributes| Key attribute|Venue| venueID, venueCapacity, venueDescription| venueID| Event| eventID, eventName, eventType, startDate, endDate, startTime, endTime, availableSpaces, eventFee| eventide| S taffMember| 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 inn 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 | staf fID| | 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 an outside key into EventTbl. ReservedforTbl| eventID, venueID, attendeeID, | reserveID| eventID is a remote key into EventTbl while attendeeID is an outside key into AttendeeTbl| Part 3 †Queries Query 1 - StaffAllocation Figure [ 2 ] †Query 1 QBE for staff assignment Figure [ 3 ] †Query 1 yield for staff designation Query 2 †YearEndSchedule Figure [ 4 ] †Query 2 QBE for booked occasions start of October Figure [ 5 ] †Query 2 yield for planned 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 as set out in the models. I have endeavored to adjust the models determination to cover between the date scope of 30/09/2011 †01/01/2050 and so forth 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 complete number of enrolled members Figure [ 8 ] †Query 3 yield for absolute number of enlisted members Part 4: Spreadsheet channels and rotate tables Figure [ 9 ] †Spreadsheet information without any filTers or contingent organizing applied Figure [ 10 ] †Spreadsheet with the show just occasions beginning after fifteenth October channel applied Figure [ 11 ] †Spreadsheet with the ‘show just occasions initiating after first November as underlined' restrictive designing applied Figure [ 12 ] †Pivot table Figure [ 13 ] †Pivot table as a bar outline

A Doll House marriage essays

A Doll House marriage expositions Screenwriters use marriage in their attempts to exhibit the enthusiastic battle it takes for two individuals to remain really infatuated. There are three principle characteristics of marriage: correspondence, love in real life, and magnanimity. Ibsen plainly depicts these characteristics in his play, A Doll House. In this play, the two primary characters experiencing a conjugal battle are Nora and Torvald. The moves they make all through this play decide the destiny of their marriage. Correspondence is a major piece of marriage. On the off chance that there is no correspondence in a marriage it is a lot harder to remain in affection with the other individual. Close to the finish of the play, Nora finds her absence of correspondence with Torvald. Torvald likes to keep himself far off from Nora. He has his own investigation which she isn't permitted to enter except if she asks his consent. The greater part of the discussion seen all through the play is Torvald calling her his little squirrel and other pet names. At the finish of the play, Nora herself concedes that they have not once had a genuine discussion in their eight years of marriage. This absence of correspondence causes Nora to make one stride nearer to the entryway. Another principle some portion of marriage is love in real life. These are the moves one makes in light of the adoration they have for their accomplice. Nora exhibits this in one of her encounters with Dr. Rank. Nora and Dr. Rank have been dear companions for a long time. He goes to her home to visit her pretty much ordinary. On one visit, in any case, things didn't go as they regularly do. While sitting together Dr. Rank reveals to Nora that he cherishes her and that he has consistently adored her. He inquires as to whether she will go with him, since she doesn't appear to be content with Torvald. Nora adores Dr. Rank, however similarly as a companion. She was unable to consider being unfaithful to Torvald and leaving him for another man. Despite the fact that she wasn't completely upbeat there she chose to remain for Torvald. Nora may have considered the adoration she gave to him as she took her last st ... <!

My Monday (in Snaps)

My Monday (in Snaps) (Take a look at “My Monday” by Yuliya K. 18 for her day in the life at MIT post) 8:45: Wakeup. For real this time, after 10+ snoozes. 8:53: First snap! Of a TMAYD MIT (Tell Me About Your Day MIT) wristband. Happy Monday, MIT! Also my roommate picked up my first paycheck in our shared mailbox. Exciting stuff! 9:05: Depart Conner 5. Isn’t our elevator art on point? (We’re the Home of the Velociraptors, in case you were wondering) 9:06: Aaaand it’s cold outside at a crisp 45 degrees. But good thing I’m all bundled up though, with a beanie and down jacket. 9:10: Arrive at Johnson Arena, next to the Z-Center for skating practice. During practice, a friend from Technique, the yearbook, photography, and design club, drops by to take some pictures for her photography class project. 10:00: OK, so I woke up later than I intended, so my training session was cut short. Ideally I’d wake up early enough to skate the full session starting at 8am. Anyways, it’s time for breakfast! I always dig the chocolate milk, especially after practice! 10:45: Walk across Mass Ave and enter Lobby 7 on my way to take the 3.091 (Solid State Chem) midterm. Quick diversion: it’s a hackthe MIT Zoo! (Check out “A Collection of Curious Creatures at the MIT Zoo” by Chris Peterson for some great shots) 10:59: Got just a little distracted by the zoo animals, but I arrive at 10-250 with a few minutes to spare (on MIT time). T-6 mins before exam begins. 11:02: T-2 mins… Time to get calculator, pencil, eraser, periodic table, table of constants, and cheat sheet out. 11:04: Here we gooooo! OK, it’s time to put my phone away. 12:08: Walk out of 10-250 feeling WRECKED by the midterm. alksjdfiwejkndfv. I can’t even think straight anymore. My brain hurts. 12:10: Down the hall it’s Lobby 7! Lobby 7 is always on point. There’s light and beauty at the end of the hallway/tunnelthat’s what I’d like to think at least… Now off to Rotch Library to pset for 8.01 13:30: Still psetting. 13:45: Time to leave for 18.02 recitation. Back down to Lobby 7, and another chance to receive the full MIT Zoo experience, feat. dino, ¾ of cow, seal, and head of cow. 13:48: Oops. Forgot to get lunch. Run to Masseh to get food to-go. 13:57: Run through the Infinite, weaving through people to get to Building 66. 14:05: Made it just in time. We get back our 18.02 midterms that we took on Thursday. No time to look them overwe got material to cover. Today it’s line integrals. Fun stuff. 15:05: MAS.A19 seminar, aka “Designing Consumer Electronics” and held at the Media Lab which has to be the coolest building on campus. Snacks provided too! 17:10: Walking through the Infinite for the n-th time today, I am greeted by another zoo animal, this time it’s a circular cow hanging from the ceiling. Mooooo. 17:15: Make my way to Barker Library. The reading room is an amazing place to study (and to doze off) in. Nikola Tesla’s bust resides outside Barker. 18:20: Attempting to finish 8.01. Can’t figure out a part of a part of a problem. Noooooo. Time to go to office hours. 18:30: 8.01 office hours. Ask for help to figure out what I’m doing wrong. So I do it on the whiteboards again to double check my strategy. And it works! I can’t algebra, that’s why. Oops. 18:50: Walk thru Infinite for the infinith-time. This time I spot a hanging octopus. Yeeeeewalking thru the Infinite today has been so exciting! 18:51: I spy free food in Lobby 10. Time to snack up on some sandwiches. Have yet to eat dinner. 18:55: Cross Mass Ave once again. Building 7 looks on point at night. 19:00: Arrive at the TechX office in the Student Center for a meeting about organizing the Banquet for xFair, MIT’s spring career fair and expo. A futon is convenietnly opened up. Would love to take a nap, but it’s time to discuss logistics! Oh, and there’s also snacks stocked up in the room. Yay. 20:54. Time to eat dinner. Back again at Masseh. 21:05: Not too much time to waste. Back in the Infinite on my way to Building 2 for the general TechX Logistics Committee meeting. More discussion and planning and emails. 22:04: Meeting ended early! Finally back in Burton Conner after a full day out. Greeted by our floor’s uber cool light-up sign, which is reprogrammable. 22:06: Got an email that my Amazon shipment has arrived. Yay for Amazon Prime! Also 3.091 midterm grades released. I know right?! The average was a 63%. I did a lot better than I thought I did. I didnt fail. So yay! Two midterms down, one to go. (18.02 happened last week, 8.01 on Thursday) 22:20: Bought a card reader for CF memory card. Now I can transfer and edit photos that I took from a camera checked out from Technique, the yearbook, design, and photography club. 23:50: Done playing for the day. Back to psetting… 00:51: Finally done with the 8.01 pset! #success OK, its bedtime 01:00: ‘Night.