
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

GCE MAY 2007 : A2 1 Development of Information Systems

4 pages, 23 questions, 0 questions with responses, 0 total responses,

	gce	+Fave Message
	Profile Timeline Uploads Q & A

Home > gce >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

ADVANCED General Certificate of Education 2007 Information and Communication Technology assessing Module 4: Development of Information Systems A2W11 Assessment Unit A2 1 [A2W11] WEDNESDAY 16 MAY, MORNING TIME 1 hour 30 minutes. INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number on the Answer Booklet provided. Answer all seven questions. INFORMATION FOR CANDIDATES The total mark for this paper is 90, including a maximum of 4 marks for quality of written communication. Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question. A2W1S7 3719 Answer all seven questions. 1 A protocol is necessary when data is transferred over a network. (a) Explain why a protocol is needed. (b) Describe the main features of the CSMA/CD protocol. [3] (c) Describe the main features of the TCP/IP protocol. [3] (d) Describe a method which can be used to detect and correct errors in data transmission. 2 [2] [4] In an athletics club, members can select a number of different sports. Each sport has a single coach. Data about members is stored in a flat file, an extract from which is shown below. MemberID MemberName SportID SportName CoachID CoachName M123 White S12 Judo C02 Green M123 Whyte S14 Karate C09 Gray M125 Brown S12 Judo C02 Green M125 Brown S13 Boxing C08 Black (a) With the aid of examples from this table, explain what is meant by: (i) Data inconsistency (ii) Data redundancy [4] The club decides to store the data in a relational database. (b) Produce a fully-labelled entity relationship model, not containing a many-to-many relationship. [6] (c) Normalise the above table to (i) 1NF (ii) 2NF (iii) 3NF A2W1S7 3719 [6] 2 3 Auditing software and accounting software are used on a network. The network manager wants to identify users who are making unauthorised changes to data. (a) Describe three activities the auditing software could record in this case. (b) Describe how accounting software could be used on a network. 4 [6] [6] An ICT system can be developed using prototyping. (a) Name and describe two different types of prototyping. (b) Name and describe one other way in which the system can be developed. 5 [8] [4] A business wishes to introduce software to replace its paper-based system. The software should reflect as far as possible the current procedures. The business must reduce its wages bill as soon as possible. (a) Describe one benefit of an off the shelf solution in this case. (b) Describe one drawback of an off the shelf solution in this case. [2] (c) Describe two other ways in which the business could obtain the software and comment on the suitability of each. 6 [2] [6] Stock control software undergoes testing. (a) Explain what is meant by each of the following: (i) Alpha testing [3] (ii) Beta testing [3] Usability is one way of measuring the quality of the new software. (b) Describe three other ways in which the quality of the software can be measured. A2W1S7 3719 3 [6] [Turn over 7 A number of factors should be taken into account during the design of a human computer interface (HCI). (a) Describe two psychological factors which should be taken into account. [4] (b) Describe two ways in which the ICT skills of the end users should be taken into account. [4] Physical factors can influence the way in which users interact with a computer system. (c) Describe two health and safety factors which should be taken into account. A2W1S7 3719 7-176-1 4 [4]

Formatting page ...

Additional Info : Gce ICT May 2007 Assessment Unit A2 1, Module 4: Development of Information Systems
Tags : General Certificate of Education, A Level and AS Level, uk, council for the curriculum examinations and assessment, gce exam papers, gce a level and as level exam papers , gce past questions and answer, gce past question papers, ccea gce past papers, gce ccea past papers

gce chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: