Revision

Revision

Queries / SQL
1. Complex
  1. Example
  2. This is where you have multiple criteria that the search has to meet
  3. SELECT ALL FROM table WHERE Age = 25 AND Town = Halifax
  4. usually returns limited values as it is a mor refined search
2. Simple
  1. Example
  2. This is where you only have one criteria to match.
  3. usually returns many values as it only looks at one aspect of the data
  4. SELECT ALL FROM table WHERE Height = 1.96m
Laws
1. Computer misuse Act
  1. Creates laws to tackle unathourised access and use
  2. Unauthorised access to computer material
    1. Unauthorised access with intent to commit or facilitate a crime
      1. Unauthorised modification of computer material.
        Making, supplying or obtaining anything which can be used in computer misuse offences
2. Data Protection Act
  1. Manages what data is stored and how much is stored and the way it is stored
  2. 8 Principle
    1. Data shall be processed fairly and lawfully.
      1. 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
3. Regulation of Investigatory Powers Act
  1. Allows for surveillance and collection of private data by certain individuals
  2. prevents the existence of interception warrants and any data collected with them from being revealed in court.
    1. allows certain public bodies to monitor people's Internet activities
      1. 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
4. Copyright and Patents Act
  1. protects original designs and creations
  2. Work Covered
    1. Literary Song lyrics, manuscripts, manuals, computer programs, commercial documents, leaflets, newsletters and articles etc.
      1. 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
1. 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
1. A macro is a way to automate a task or procedure which you perform on a regular basis.
Templates
1. A template is a tool for ensuring that all documents or pages have a standard layout, look and feel.
Stylesheets
1. 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.

Nächster

Beschreibung

Zusammenfassung der Ressource

ähnlicher Inhalt

	Erstellt von Brandon Davies vor mehr als 7 Jahre