Download Music Festivals - Management Information Systems - Exam and more Exams Management Information Systems in PDF only on Docsity!
Ollscoil na hÉireann, Gaillimh
National University of Ireland, Galway
Autumn Examinations, 2008/
Exam Code(s) 3BC1, 4BC2, 4BC3, 4BC4, 4BC5, 1DB1, 1EM
Exam(s) Third Year Commerce Fourth Year Commerce (French) Fourth Year Commerce (German) Fourth Year Commerce (Italian) Fourth Year Commerce (Spanish) Higher Diploma in Business Studies Erasmus
Module Code(s) MS
Module(s) Program Design and Development
Paper No. Repeat Paper
External Examiner(s) Professor Hans van der Heijden
Internal Examiner(s) Professor J.F. Collins Mr. U. Sharkey
Instructions: Answer question ONE and TWO other questions. Question 1 carries 40 marks, all other questions carry 30 marks. You should spend no longer than 50 minutes on Q1.
Duration 2 hrs No. of Answer Books
Requirements : Handout MCQ Statistical Tables Graph Paper Log Graph Paper Other Material
No. of Pages 6 Department(s) Accountancy and Finance – Business Information Systems
Q1. FestFood Ltd. provide a food stall for summer music festivals. They have the following items for sale on their stall.
Sandwiches Price
Kangaroo Steak Sandwich €9. Chicken and Bacon triple‐decker €7. Tuna surprise €5.
Drinks (optional extra) Price
Koala brand cola €3. Light lemonade €2. Sunny Juice €1.
Customers must choose at least one sandwich from the selection but do not have to choose a drink. Sandwich orders are added to the software system one at a time. The cashier records the selected sandwich, the drink choice (if required), the customer’s name, and telephone number on the information system. The customer’s order details and the order total must be displayed on a second form.
During the festival, representatives of the catering company go into the crowd and randomly give out vouchers for a free drink with any sandwich purchased from the food stall.
The company also offers a 10% student discount to any customer who produces a valid student identification card when purchasing a sandwich.
If a festival goer produces a voucher and/or a valid student identification card, then a discount control(s) must be available for the cashier to enter the details on the screen. By selecting this control the appropriate discount is calculated. The following details must be displayed on the screen:
¾ The gross cost of the meal (before any discounts) ¾ The amount saved from applied discounts ¾ The total amount due, which must be displayed separately.
Use appropriate formatting to display these totals.
Sketch a user interface to achieve the functionality outlined above. On your design sketch, indicate and name all the controls.
Write the source code necessary for the functioning of the user interface design.
(40 marks)
(c) While developing software programs it is important to carry out validation checks on input data when writing your code. Explain why validation is necessary. Include in your answer three different examples of validation checks. (12 marks)
Q (a) Give a full explanation of what each of the following pieces of code is doing, by describing the purpose of the individual components within all lines(s) of that piece of code.
(i) averageTextBox.Text = averageDecimal.ToString("N2")
(ii) For indexInteger As Integer = 0 To countInteger coffeeStreamWriter.WriteLine(coffeeComboBox.Items(indexInteger)) Next indexInteger
(iii) If whichButtonDialogResult = DialogResult.Yes Then Me.Close() End If
(15 marks)
(b) The code below contains 4 separate errors and is only partially commented. Rewrite a fully commented error-free version of this code in your answer book. (Your code comments should fully inform a reader of what is happening in the code). Detail each error in your answer and indicate the line number where each error occurs.
1 Dim messageString 2 3 If mcountEmployeesInteger > 0 Then 4 5 messageString = "Total Pieces: " & mtotalPiecesInteger.ToString 6 & ControlChars.NewLine & ControlChars.NewLine _ 7 & "Total Pay: " & mtotalPayDecimal.ToString("C") _ 8 & ControlChars.NewLine & ControlChars.NewLine _ 9 & "Average Amount Earned: " & maveragePayDecimal("C") _ 10 & ControlChars.NewLine & ControlChars.NewLine _ 11 & "Number of Workers: " & mcountEmployeesInteger.ToString 12 13 MessageBox.Show(messageString, "Piecework Pay Summary", _ 14 MessageBoxButtons, MessageBoxIcon.Information) 15 16 Else 17 messageString = "No data to summarise." 18 MessageBox.Show(messageString, "Piecework Pay Summary", MessageBoxButtons.OK, _ 19 MessageBoxIcon.Information) 20 nameTextBox.Focus() 21 End If (10 marks) Question 3 Continues on the next page
(c) The following code details the data that will be displayed in a Message Box. Sketch the Message Box and the exact output of the message as it would be displayed
1 Dim whichButtonDialogResult As DialogResult 2 whichButtonDialogResult = MessageBox.Show("Do you wish to exit?", "Exit", MessageBoxButtons.YesNo) 3 4 If whichButtonDialogResult = DialogResult.Yes Then 5 Me.Close() 6 End If (5 marks)
Q (a) You are working with a production company based in Connemara, Silas Studios on a period drama piece. The piece includes many references to imperial dry measurements and the prop department have requested a quick way to ensure that when the script mentions things like a “half-peck bag of apples” or “a bushel of pears” that it is accurately represented on screen. To do this they require a small converter program to be deployed on their mobile devices.
Write a program in VB.NET that allows the user to enter a numerical amount in pecks or bushels and converts the amount into litres. The program should also allow the user to enter an amount in litres and convert it into both pecks and bushels.
For the purposes of this program, assume one peck is equal to 9 litres and a bushel is equal to 4 pecks (i.e. 36 litres).
When the Convert button is clicked the program displays the converted amounts in the relevant textboxes, for example if the user enters 1 in the “Amount in Pecks” textbox, the program displays the appropriate number in the other two textboxes.
A screenshot of what this program may look like is displayed above. You are required to write the code that will be executed when the Convert button is selected.
(20 marks) Question 4 Continues on the next page
