This is where you have multiple criteria that the search has to meet
SELECT ALL FROM table WHERE Age = 25 AND Town = Halifax
usually returns limited values as it is a mor refined search
Simple
Example
This is where you only have one criteria to match.
usually returns many values as it only looks at one aspect of the data
SELECT ALL FROM table WHERE Height = 1.96m
Laws
Computer misuse Act
Creates laws to tackle unathourised access and use
Unauthorised access to computer material
Unauthorised access with intent to commit or facilitate a crime
Unauthorised modification of computer material.
Making, supplying or obtaining anything which can be used in computer misuse offences
Data Protection Act
Manages what data is stored and how much is stored and the way it is stored
8 Principle
Data shall be processed fairly and lawfully.
Data shall be obtained only for one or more specified and lawful purposes.
Personal data shall be adequate, relevant.
Data shall be accurate and, where necessary, kept up to date.
Data processed for any purpose or purposes shall not be kept for longer than is necessary
Data shall be processed in accordance with the rights of data subjects under this Act.
Appropriate technical and organisational measures shall be taken against unauthorised or unlawful
processing of personal data
Personal data shall not be transferred to a country or territory outside the European Economic Area
Regulation of Investigatory Powers Act
Allows for surveillance and collection of private data by certain individuals
prevents the existence of interception warrants and any data collected with them from being
revealed in court.
allows certain public bodies to monitor people's Internet activities
enables certain public bodies to demand that someone hand over keys to protected information
enables certain public bodies to demand ISPs fit equipment to facilitate surveillance
enables mass surveillance of communications in transit
enables certain public bodies to demand that an ISP provide access to a customer's communications
in secret
Copyright and Patents Act
protects original designs and creations
Work Covered
Literary Song lyrics, manuscripts, manuals, computer programs, commercial documents, leaflets,
newsletters and articles etc.
Dramatic Plays,
dance, etc.
Musical Recordings
and score.
Artistic Photography, painting,
architecture, technical
drawings/diagrams, maps, logos, etc.
Typographical arrangement of published editions
Magazines, periodicals, etc.
Sound recordings May be recordings of works, e.g.
musical and literary.
Films Broadcasts and cable
programmes.
Wizards
A wizard is user interface which
presents the user with a
sequence of dialogue boxes that
lead the user through a series
of well-defined steps.
Macros
A macro is a way to
automate a task or
procedure which you
perform on a regular basis.
Templates
A template is a tool for ensuring that all
documents or pages have a standard
layout, look and feel.
Stylesheets
A style sheet contains the instructions for the
layout of a document, such as the font styles
and sizes to be used, the style of headings and
sub-headings, the size of the margins etc.