ISDD

Question 1

What is information rich?

Answer 1

Access to TV, radio, internet etc

Question 2

What is information poor?

Answer 2

No access to web, books etc

Question 3

Flat file database

Answer 3

Only one table and each row or table is unique (data duplication is an issue)

Question 4

Relational database

Answer 4

Linked tables to prevent data duplication

Question 5

Range check

Answer 5

Ensure data is between upper and lower limit

Question 6

Restricted choice

Answer 6

List of options to prevent entering errors

Question 7

Unique check

Answer 7

Ensures data entered is different from any other record

Question 8

Length check

Answer 8

Ensures data has restricted number of characters

Question 9

Presence check

Answer 9

Ensures field is not blank

Question 10

Primary key

Answer 10

Used to uniquely identify a record

Question 11

Foreign key

Answer 11

Field in one table linked to primary key in other table

Question 12

Compound key

Answer 12

Combines fields to create a unique value

Question 13

What does queries use?

Answer 13

SQL (Structured Query Language)

Question 14

What are reports?

Answer 14

Present and summarise data - printed to view information easily

Question 15

What are meta tags used for?

Answer 15

Specify descriptions, keywords, authors and other metadata

Used to communicate information to the browser and search engines

Not visible

Question 16

Advantages to static websites

Answer 16

Quick to develop
Cheap to develop
Cheap to host

Question 17

Disadvantages to static websites

Answer 17

Content can get boring
Not as useful for user
Requires web development expertise to update site

Question 18

Advantages to dynamic websites

Answer 18

Much more functional
Easier to update
New content brings people back to the site

Question 19

Disadvantages to dynamic websites

Answer 19

Slower and more expensive to develop

Hosting costs more

Question 20

Linear navigation

Answer 20

Like a PowerPoint, each slide in order and can’t skip

Question 21

Hierarchical navigation

Answer 21

Tree-like structure

Question 22

Multi-level navigation

Answer 22

Different pages nested into subsections
Structure is tidy and organised
Allows websites to have lots of content

Question 23

What is a user interface?

Answer 23

The space where interaction between people and machines occur

Question 24

Expert user

Answer 24

Very experienced in using system who use more advanced features and like more customisable options

Question 25

Novice users

Answer 25

New to the system and prefer simple interfaces and wizards

Question 26

Age range

Answer 26

More graphical and colourful for kids and more accessibility for older users

Question 27

Alt tags

Answer 27

Used on images so search engines can use the tags when using spiders to search sites
Also allow accessibility options like screen reader to read the text aloud

Question 28

Smartphone/tablet optimisation

Answer 28

Optimise information systems to work with tablets and phones
Make sure people using phones have same experience as desktop users
CSS rules created for certain screen widths

Question 29

Tablet/smartphone issues

Answer 29

iPhones/iPads don’t handle flash
Sites have to be zoomed in to read
Dropdown menu effects etc don’t work that well
Images too large
Touchscreen and links make it hard to use site