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

GCE MAY 2008 : A2 1 Development of Information Systems

4 pages, 20 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 2008 Information and Communication Technology assessing Module 4: Development of Information Systems A2W11 Assessment Unit A2 1 [A2W11] MONDAY 12 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. A2W1S8 4410 Answer all seven questions. 1 Audit trails and access levels are used on a network. (a) Identify four activities which take place during a typical audit trail. [4] (b) Describe three different access levels which can be used on a network. [6] (c) Apart from physical measures, describe one way in which the use of a network can be restricted to authorised users. [3] 2 (a) Describe each of the following network protocols. (i) CSMA/CD (ii) Token ring [8] (b) Describe two advantages of using fibre optic cable over co-axial cable for data transmission. 3 [4] Physical factors can influence how humans use computers. (a) Describe two of the main ergonomical factors which influence human computer interaction. [4] A well designed human computer interface should include help facilities. (b) Describe three other features which should be included for inexperienced users. A2W1S8 4410 2 [6] [Turn over 4 The waterfall model and prototyping are two approaches to software development. (a) Describe the role of the analyst when the waterfall model is used. [3] (b) Describe the role of the end user (i) When the waterfall model is used. (ii) When prototyping is used. 5 [4] [4] When a new software package is developed, it must be fully tested. (a) Explain what is meant by (i) Alpha testing. [4] (ii) Beta testing. [4] (b) Describe three reasons why the software may not be suitable. 6 [6] A business uses external ICT consultants to develop a new information system. (a) Describe two other ways in which the business could obtain the new software. [6] (b) Identify and describe two CASE tools which can be used during the development of new software. [6] A2W1S8 4410 3 [Turn over 7 Data about invoices is held in the following table. Invoice Customer Customer Product number ID name ID Product description Unit cost Quantity Invoice total 732289 C047 Brown P014 CD-Rom 0.35 500 175.00 342256 C032 Green C047 Brown Keyboard CD-Rom External HD USB pen External HD 5.99 0.35 56.48 6.95 56.48 25 300 28 50 15 1836.19 110987 P023 P014 P037 P014 P037 1194.70 (a) (i) Identify an example from this table of data inconsistency. [1] (ii) By referring to this table, describe one other problem which may arise from data which is not normalised. [2] (b) Draw an Entity Relationship (ER) Model, which does not contain a many to many relationship, to represent the data in this table. [5] (c) Showing clearly all your work, normalise the data in the table above to 3NF. You may assume that any data inconsistency has been removed. [6] A2W1S8 4410 528-008-1 4 [Turn over

Formatting page ...

Additional Info : Gce ICT May 2008 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: