ISDD Flashcards
What is information rich?
Access to TV, radio, internet etc
What is information poor?
No access to web, books etc
Flat file database
Only one table and each row or table is unique (data duplication is an issue)
Relational database
Linked tables to prevent data duplication
Range check
Ensure data is between upper and lower limit
Restricted choice
List of options to prevent entering errors
Unique check
Ensures data entered is different from any other record
Length check
Ensures data has restricted number of characters
Presence check
Ensures field is not blank
Primary key
Used to uniquely identify a record
Foreign key
Field in one table linked to primary key in other table
Compound key
Combines fields to create a unique value
What does queries use?
SQL (Structured Query Language)
What are reports?
Present and summarise data - printed to view information easily
What are meta tags used for?
Specify descriptions, keywords, authors and other metadata
Used to communicate information to the browser and search engines
Not visible
Advantages to static websites
Quick to develop
Cheap to develop
Cheap to host
Disadvantages to static websites
Content can get boring
Not as useful for user
Requires web development expertise to update site
Advantages to dynamic websites
Much more functional
Easier to update
New content brings people back to the site
Disadvantages to dynamic websites
Slower and more expensive to develop
Hosting costs more
Linear navigation
Like a PowerPoint, each slide in order and can’t skip
Hierarchical navigation
Tree-like structure
Multi-level navigation
Different pages nested into subsections
Structure is tidy and organised
Allows websites to have lots of content
What is a user interface?
The space where interaction between people and machines occur
Expert user
Very experienced in using system who use more advanced features and like more customisable options
