Higher Assignment 2018-19

This video will be back soon!

Task 1a - Entity Occurence Diagram

Things to note:

• The lines help determine the cardinality of the entities

• Use the table data provided as a checklist

This video will be back soon!

Task 1b(i) - SQL query design

Things to note:

• Work methodically

  • Get the information you need to display e.g. forename, surname

  • Filter using WHERE and the information provided in the question

  • Link the tables with joins e.g. tableA.field = tableB.field

  • Then look at calculations e.g. (adultTicket * 5.5) As tax

This video will be back soon!

Task 1b(i) - Access view

This shows the successful run of the SQL query in MS Access.

Things to note:

• Always check the quotes - pasting from another program may put in the wrong quotes and cause your SQL query to fail

Task 2a - Input Process Output and Data Flow

This shows how to work through a problem description to create an Input, Process and Output table and then how to identify the variables to be passed in / out of subroutines in the Data Flow table.

Things to note:

• Input, Process and Output table

  • The problem description contains everything you need to complete this task correctly. You don't have to assume additional actions. 

• Data Flow tables

  • Subroutines which are completing input actions usually only pass data out only

  • Subroutines which are completing process actions usually need data passed in and out

  • Subroutines which are completing output actions usually need data passed in only

Task 2b - Program implementation, maintenance of code, trace table and evaluation (fitness for purpose, maintainability)

Task 3a - Functional requirements

Task 3b(i) - HTML + CSS Adjustments

Task 3b(ii) - HTML, CSS + Javascript Adjustments

Task 3c - Comprehensive testing