Nat 5 Computer Science

• What does an entity-relationship diagram indicate?

  Entity name, attributes, relationship
• What components are included in a data dictionary?

  Entity name, attribute name, primary key
• What SQL operations should be implemented for relational databases?

  Select, insert, update, delete, equi-join
• What should be evaluated in terms of SQL operations?

  Correctness of SQL operations at this level
• What are the implications of the UK GDPR for data processing?

  • Processed lawfully, fairly, transparently
  • Used for declared purpose only
  • Limited to necessary data
  • Accurate and up-to-date
  • Not kept longer than necessary
  • Held securely
• What are the attributes of vector graphics representation?

  • Co-ordinates
  • Fill colour
  • Line colour
• What are the attributes of bit-mapped graphics representation?

  • Pixels
  • Resolution
  • Colour depth
• What are the components of basic computer architecture?

  • Processor (registers, ALU, control unit)
  • Memory locations with unique addresses
  • Buses (data and address)
• What are the standard algorithms to be implemented?

  • Input validation
  • Running total within loop
  • Traversing a 1D array
• What are the key aspects of evaluating a solution?

  • Fitness for purpose
  • Efficient use of coding constructs
  • Robustness
  • Readability (internal commentary, meaningful identifiers, indentation, white space)