Key Area 2.1 - Creating An Information System

Question 1

What is a record

Answer 1

Holds information about one person or thing in file, these are made up of fields

Question 2

What is a field

Answer 2

Holds information about a single piece of data

Question 3

List some database field types

Answer 3

Link
Numeric
Text
Graphics
Boolean
Calculated 
Time
Date

Question 4

What is the primary key

Answer 4

Uniquely identifies each record in a database such as an ID or an account number

Question 5

What is the foreign key

Answer 5

Enables you to set up relationships or links between tables in a database

Question 6

Describe the 4 types of database validation

Answer 6

Length check
Specifies the size of get field such as the number of characters

Range check
Specifies the range of numbers a field can hold

Presence check
Checks that data has been entered and that the field is no left blank

Restricted choice
Presents the user with a choice often in the form of a drop down menu

Question 7

What is a flat file database

Answer 7

A simple database structure that has one table with all of the fields and data they contain. There is the risk of data duplication

Question 8

What are linked tables

Answer 8

Composed of a range of tables that are linked together to provide the user with different pathways through the database

Question 9

What is the URL composed of

Answer 9

Unique Resource Locator
Protocol
Server
Organisation

Question 10

What are hyperlinks

Answer 10

Webpages are linked together by hyperlinks

Question 11

What is an internal hyperlink

Answer 11

Also RELATIVE

Takes the user to a new location within the current open website

Question 12

What is an external hyperlink

Answer 12

Also ABSOLUTE

Takes the user to a new location in another website located on a different server or computer

Question 13

What attributes make up accessibility

Answer 13

Image description
Site map
Keyboard options
Links description
Audio captions
Descriptive title
Home button
Colour options
Font size options 
Help page or link

Question 14

What attributes make up navigation

Answer 14

Consistent web design
Reduces clutter
Navigation scheme
Not complicated
Text or graphic hyperlinks
Hotspots
Navigation bar
Minimum number of clicks required

Question 15

What is a browser

Answer 15

A program that helps you navigate the World Wide Web and move between or look at web pages
In a browser you can enter the address of the page or click a hyperlink
Browsers can:
Find and look at web pages
Navigate between pages
Move forwards and backwards between pages

Question 16

What is a search engine

Answer 16

Used to look for web pages. The search engine will find all the web pages related to that topic

Question 17

List the attributes that make up usability

Answer 17

Experienced user
Extra features
Keyboard or mouse interactions
Keyboard shortcuts

Novice or beginner
Simple design
Accessible
Online help
Easy navigation

Question 18

Describe the components of the user interface

Answer 18

Consistency
Visual layout
Navigation
Interactivity
Readability

Question 19

What is a wizard

Answer 19

A feature of a package that helps you step by step through the process of document creation

Question 20

What is a template

Answer 20

A ready made document with place holders for text and graphics which allows for easier document creation

Question 21

What are the features of a website

Answer 21

What the web page has

Sound video and colour

Question 22

What are the functions of a website

Answer 22

What you can do on the web page

Search navigation and email

Question 23

List the data relationships

Answer 23

One to many
One to one
Many to many

Question 24

What is an entity

Answer 24

File

Question 25

What is an attribute

Answer 25

Field

Question 26

What is an instance

Answer 26

Record

Question 27

What is a file

Answer 27

Data is stored in files which are sets of records