SQA Information Systems Int2 Paper 2008

SECTIONI

Attemptallquestionsinthissection.

1.Whattype of application software would you recommend to allow users tocommunicateacrosstheInternetinreal-time?

2.Hereisthedesignforapupildatabase.

Marks

1

FieldName / DataType / SampleData
Forename / text / Lidia
Surname / text / Witkiewicz
Class / text / 4B
Subjects / text / English,Computing,Gaelic,Art
StatethetermusedtodescribetextfieldssuchasSubjects. / 1
3. / StatetwooffencescoveredbytheComputerMisuseAct1990. / 2
4. / Whatison-linehelp? / 1
5. / Nametheobjectinaspreadsheetthatcontainsasinglepieceoftext,anumberoraformula. / 1

6.State one security methodthatmaybeusedbyanorganisation toensure ahackercannotaccessdata. 1

7.

Whentravelling to a foreign country it is important to have

apassport with you. A passport is a document that identifies you as a citizen of the country that issues the passport.

Atan airport or ferry port there is usually someone inspecting passports, and they will use an ink stamp to mark your passport, showing that you have entered a new

country.

Thediagramaboveshowsasmallpartofawordprocesseddocument.(a) Identifyone dataobjectfromthetextabove.

(b) Nameone operationthatcouldbeperformedonthisdataobject.

8.Datahastobegatheredandstoredbeforeitcanbeprocessed.

Statetwoelectronicmethodsthatallowlargeamountsofdatatobegathered.

9.Statetwoadvantagesofpurchasingmusicon-line.

10.Explainwhytypingane-mailmessageincapitalsisseenaspoornetiquette.

11.Apieceofcomputersoftwareoffers usersmenusandkeyboardcommandstoperform various tasks. Explainwhythesoftware offers users thesedifferenttypesofHCI.

Marks

1

1

2

2

1

SECTIONII

Attemptallquestionsinthissection.

12.(a) A database is a collection of related information about people or objects.

Manydatabasesusemanualdatastorage.

Statethreeproblemsthatareassociatedwithmanualdatabases.

(b) Stateone advantageofanelectronicdatabaseoveramanualsystem.(c) Twotypesofcomputeriseddatabaseareflatfileandrelational.

(i)Whatismeantbya“flatfile”database?

(ii)Statetwolimitationsofa“flatfile”database.

(d) Normalisationisaprocessusedwhen arelationaldatabaseisbeingdesigned.

Statethreereasonswhy“normalisation” isrequiredwhenusingarelationalmodel.

13.Thedatacardsbelowshowpartofthedatabaseusedbyamusicteachertokeeptrackofpupilsandtheinstrumentstheyaregiven.

Marks

3

1

1

2

3

Pupil ID023

First NameJohn

Second NameMurnie

Pupil ID058

First NameShuna

Second NameAli

ReferenceMusical
No.InstrumentMake
G78GuitarFenbar
D34DrumsGudwig

(a)(i)Normalise the data shown above by removing the multi-value fields.

IdentifythePrimaryandForeignkeys.

(ii)Statetherelationshipbetweentheentitiescreatedin(a)(i).

(b) Whenthedatabaseisimplemented,thecontentofthefieldMusicalInstrument

islimitedtocertainvalues.Namethisvalidationcheck.

(c) Whenthedatabase isimplemented, suggestthemostsuitablefield typefor

ReferenceNo.

7

1

1

1

14.AppleBayHighSchoolhasapolicyofhealthyeatingintheschool. Theschoolstudentcouncilwantstopublicisethepolicy.

The student council are to produce a special healthy eating informationbrochurecontainingpictures,alongsiderecipesandnutritionaladvice.

(a)(i)Whattype of application software would be most suitable for thispurpose?

(ii)Statetworeasonsforyouranswer.

(b) Thestudentcouncilwantstoincludeapictureofthestudentwhowonthe

“bestrecipe”competition.

Whatwilltheyhavetodobeforetheyareallowedtoincludethepictureinthebrochure?

(c) The school hasadatabase of all thepeople whoreceived acopy of thebrochure. Alocalhealthclubrequestsacopyofthedatabase. Whyshould theschoolnotsupplythedatabasetothehealthclub?

(d) The student council wants to promote their healthy eating policy bycreatingawebsite.

(i)Whattype of application software should beused to construct thewebsite?

(ii)Statetwoadvantagestothestudentcouncilofusingawebsiteinsteadofthebrochure.

(e) Someofthefamiliesassociated withAppleBayHighSchoolaredescribedasbeinginformationpoor.

(i)Explainwhatismeantby“informationpoor”.(ii)Stateone disadvantagethatarisesfromthis.

Marks

1

2

1

1

1

2

1

SECTIONIII

PARTA—AppliedMultimedia

Look through this section – you can attemptALLquestionsinthissection, if you like!.

15.Alowcostairtravelcompanywishestoupdateitswebsite. This newwebsitewillbetheonlymethodcustomershavetobookflights.

(a) Suggest tworeasons whythe company is using the website as the onlymethodofbookingflights.

(b) Whenbookingaflight,thecustomerseesthefollowingscreen.

Marks

2

! " " "

(i)Statethetypeofsearchfacilityshownabove.

(ii)Statethetypeofuserinterfacebeingusedabove.

(iii) Stateone reasonwhythistypeofinterfacehasbeenchosen.

(c) Oncetheflights havebeenchosen, thecustomerwillneedtosupply theirpersonal details. Whichtypeofuserinterface wouldyousuggestforthisWebpage?

(d) StatethejobtitleofthespecialistwhocreatestheWebpagesforcustomerstouse.

(e) The company wishes to test the website before it is uploaded to the

Internet. Agroupofcustomersisaskedtotestandevaluatethewebsite.(i)Explainwhythepagesneedtobetested.

(ii)Stateone methodoftestingthewebsitetheymightuse.(iii)Statethereasonwhytheevaluationwouldbeuseful.

1

1

1

1

1

1

1

1

6.Erynisanaudiomediaspecialist. SheisworkingonaCALstorybookproject.

Theprojectisamultimediaprogramthatcombinestextandpictureswiththeaudioofthestoriesbeingread.

(a)(i)Whatdoes“CAL”standfor?

(ii)Suggestone reasonwhyanaudiorecordingofthestorywouldmake thisabetterprogram.

(b) ThereislimitedstoragecapacityforEryn’saudiorecordings.

Describeone methodofreducingthestoragerequirements fortheaudiorecordings.

(c) Lauraistheprojectmanager. Shewishesaudiotobeaddedtothemainscreen.

Marks

1

1

1

StoryTellingBooks

1.Black Beauty

2.AChristmas Carol

3.Little Women

4.Robin Hood

5.Treasure Island

(i)Statetwopossibleusesofaudioonscreen.(ii)Drawthenavigationmapforthisscreen.

(iii)Namethistypeofnavigationstructure.

(iv)State which type of multimedia authoring software you wouldrecommendtocreatethisapplication.

(v)Giveone reasonforyourchoice.

(d) Eachbooktitlehasalink toanewscreen. Whatisa“link”?(e) ATransitionoccurswhen onescreenchangestoanother.

(i)Whatisa“transition”?

(ii)Explainwhya“transition” mightbeused.

(f)Oncetheprogramhasbeencompleted,variouspiecesofuser documentationarewritten.

(i)Describethepurposeofuserinstructions.

(ii)Explainwhyhardwareandsoftwaresystemrequirementsare importantwhen buyingtheprogram.

(g) Whichpieceoflegislationcoversillegalcopyingofsoftware?

2

1

1

1

1

1

1

1

1

1

1