Key Area 2.1 - Creating An Information System Flashcards
What is a record
Holds information about one person or thing in file, these are made up of fields
What is a field
Holds information about a single piece of data
List some database field types
Link Numeric Text Graphics Boolean Calculated Time Date
What is the primary key
Uniquely identifies each record in a database such as an ID or an account number
What is the foreign key
Enables you to set up relationships or links between tables in a database
Describe the 4 types of database validation
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
What is a flat file database
A simple database structure that has one table with all of the fields and data they contain. There is the risk of data duplication
What are linked tables
Composed of a range of tables that are linked together to provide the user with different pathways through the database
What is the URL composed of
Unique Resource Locator
Protocol
Server
Organisation
What are hyperlinks
Webpages are linked together by hyperlinks
What is an internal hyperlink
Also RELATIVE
Takes the user to a new location within the current open website
What is an external hyperlink
Also ABSOLUTE
Takes the user to a new location in another website located on a different server or computer
What attributes make up accessibility
Image description Site map Keyboard options Links description Audio captions Descriptive title Home button Colour options Font size options Help page or link
What attributes make up navigation
Consistent web design Reduces clutter Navigation scheme Not complicated Text or graphic hyperlinks Hotspots Navigation bar Minimum number of clicks required
What is a browser
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
What is a search engine
Used to look for web pages. The search engine will find all the web pages related to that topic
List the attributes that make up usability
Experienced user
Extra features
Keyboard or mouse interactions
Keyboard shortcuts
Novice or beginner Simple design Accessible Online help Easy navigation
Describe the components of the user interface
Consistency Visual layout Navigation Interactivity Readability
What is a wizard
A feature of a package that helps you step by step through the process of document creation
What is a template
A ready made document with place holders for text and graphics which allows for easier document creation
What are the features of a website
What the web page has
Sound video and colour
What are the functions of a website
What you can do on the web page
Search navigation and email
List the data relationships
One to many
One to one
Many to many
What is an entity
File
What is an attribute
Field
What is an instance
Record
What is a file
Data is stored in files which are sets of records
