ADVANCEDGeneral Certificate of Education

Digital TechnologyAssessment Unit A2 1assessingInformation Systems

[ADT11]Assessment

TIME2 hours 30 minutes.

INSTRUCTIONS TO CANDIDATESWrite your Centre Number and Candidate Number in the spaces provided at the top of this page.You must answer the questions in the spaces provided. Do not write outside the boxed area on each page or on blank pages. You are not permitted to use any calculating aid in this paper.Complete in black ink only. Do not write with a gel pen.Answer all five questions.

INFORMATION FOR CANDIDATESThe total mark for this paper is 150.Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question.Quality of written communication will be assessed in Questions 1(d), 2(c) and 3(g).

*ADT11*

*ADT11*

*28ADT1101*

*28ADT1101*

Centre Number

Candidate Number

12776

Assessment Level of Control:Tick the relevant box ()

Controlled ConditionsOther

*28ADT1102*

*28ADT1102*

12776

1 (a) Explain how each of the following resources is used in a network.

Server

Switched hub

Media converter

[9]

*28ADT1103*

*28ADT1103*

12776[Turn over

(b) Distinguish between the purpose of an IP address and a MAC address.

An IP address

A MAC address

[2]

*28ADT1104*

*28ADT1104*

12776

(c) A small company operates out of a single office in which six employees share the same documents and data files.

Compare the suitability of a peer-to-peer network with a server-based network for this company.

[6]

*28ADT1105*

*28ADT1105*

12776[Turn over

(d) Evaluate the star topology and the ring topology with respect to cable failure.

Quality of written communication will be assessed in this question.

[6]

*28ADT1106*

*28ADT1106*

12776

2 (a) The OSI network model includes the Application layer and the Physical layer.

(i) Define the term ‘communications protocol’.

[1]

(ii) Name three other layers in the OSI model.

1.

2.

3 . [3]

*28ADT1107*

*28ADT1107*

12776[Turn over

(iii) Describe the main features of each of the following.

The Application layer

The Physical layer

[8]

*28ADT1108*

*28ADT1108*

12776

(b) Compare Wi-Fi and Bluetooth as methods of communication between two devices.

[6]

*28ADT1109*

*28ADT1109*

12776[Turn over

(c) Evaluate the use of parity bits in detecting and correcting errors during data transmission.

Quality of written communication will be assessed in this question.

[6]

*28ADT1110*

*28ADT1110*

12776

3 A movie studio stores details about its films in a database.

An extract from the FILM table is shown below.

FilmID Title ActorID ActorName AgentID AgentName

F123 Mission Possible A222 Cruise AG888 DePalma

F123 Mission Possible A333 Voigt AG888 DePalma

F456 Majority Report A222 Cruise AG888 DePalma

F456 Majority Report A444 Farrell AG999 Marshall

F456 Minority Report A333 Voigt AG888 DePalma

(a) By referring to the table, explain what is meant by each of the following.

Data duplication

Data inconsistency

[4]

*28ADT1111*

*28ADT1111*

12776[Turn over

An entity-relationship (ER) model is produced, and the data in the table is normalised.

You may assume that any errors in the table have been corrected.

(b) In the box below, draw a fully labelled ER model for this table which does not contain any many-to-many relationships.

[7]

*28ADT1112*

*28ADT1112*

12776

(c) Normalise the data in this table to 3NF, showing all your working.

1NF

2NF

3NF

[9]

*28ADT1113*

*28ADT1113*

12776

BLANK PAGE

DO NOT WRITE ON THIS PAGE

(Questions continue overleaf)

[Turn over

*28ADT1114*

*28ADT1114*

12776

The movie studio’s database also includes details of employees.

Another entity in the database is described below.

EMPLOYEE (EmployeeID, Name, Role, Status)

(d) Produce SQL code to add details of the following employee to the database.

EmployeeID MI234 Name John Smith Role Cameraman Status Full-time

[4]

*28ADT1115*

*28ADT1115*

12776[Turn over

(e) Produce SQL code to retrieve the Name and Role of all Full-time employees.

[4]

(f) Produce SQL code to remove all Part-time employees from the database.

[4]

*28ADT1116*

*28ADT1116*

12776

(g) Evaluate the use of QBE as an alternative to SQL for creating database queries.

Quality of written communication will be assessed in this question.

[6]

*28ADT1117*

*28ADT1117*

12776

BLANK PAGE

DO NOT WRITE ON THIS PAGE

(Questions continue overleaf)

[Turn over

*28ADT1118*

*28ADT1118*

12776

4 A hospital uses an expert system to assist in the diagnosis of illnesses.

The expert system includes a user interface.

(a) Name and describe two other components.

Name

Description

Name

Description

[6]

*28ADT1119*

*28ADT1119*

12776[Turn over

(b) Compare the suitability of a command line interface and a WIMP interface for an expert system.

[6]

*28ADT1120*

*28ADT1120*

12776

(c) Explain what is meant by each of the following.

Shell

Fuzzy logic

Heuristics

[9]

*28ADT1121*

*28ADT1121*

12776[Turn over

Robots are used to assist surgeons during some types of operation.

(d) Describe two advantages of using robots in this case.

1.

2.

[4]

(e) Describe two disadvantages of using robots in this case.

1.

2.

[4]

*28ADT1122*

*28ADT1122*

12776

5 Most smart phones include voice recognition.

(a) By referring to the technology required, explain how voice recognition is implemented.

[4]

(b) Describe the following terms used in mobile phone technology.

Base station controller

Handoffs

*28ADT1123*

*28ADT1123*

12776[Turn over

Cells

[6]

A mobile phone company uses cloud computing when backing up its data.

(c) Distinguish between a differential backup and an incremental backup.

[4]

*28ADT1124*

*28ADT1124*

12776

(d) Explain what is meant by cloud computing.

[4]

(e) Explain each of the following terms used in cloud computing.

Virtualisation

Clustering

[4]

*28ADT1125*

*28ADT1125*

12776[Turn over

(f) Describe two benefits for the mobile phone company of using cloud computing to back up its data.

1.

2.

[4]

(g) Describe one drawback for the mobile phone company of using cloud computing to back up its data.

[2]

*28ADT1126*

*28ADT1126*

12776

The mobile phone company must comply with legislation including the Data Protection Act (DPA).

(h) The Data Protection Act states that personal data should be collected for a specified purpose. Identify four other principles of the Act.

1.

2.

3.

4.

[4]

*28ADT1127*

*28ADT1127*

12776

(i) Explain the following terms relating to the Data Protection Act.

Data subject

Information Commissioner

[4]

THIS IS THE END OF THE QUESTION PAPER

Permission to reproduce all copyright material has been applied for.In some cases, efforts to contact copyright holders may have been unsuccessful and CCEAwill be happy to rectify any omissions of acknowledgement in future if notified.

For Examiner’suse only

QuestionNumber Marks

12345

TotalMarks

Examiner Number

259400

DO NOT WRITE ON THIS PAGE

*28ADT1128*

*28ADT1128*