Database: design and concepts
Logging in/passwords; relational database design; normalisation; transaction processing; characteristics of good database design; caring for and managing data; hacking through data. Database management and design concepts; split tables and create relations; key fields and relationships.
OOP
Reinforce programming skills: parameterised and non-parameterised constructors; correct use of private/public attributes; accessor, mutator and auxiliary methods; ToString and accessor methods for output; correct instantiation; use of methods as part of problem solving.
Hardware
Mobile technologies; factors influencing computer performance; motivate a typical computer system for user requirements.
SQL
Design and develop a solution incorporating SQL: SELECT fields, calculated fields (AS), ROUND/INT/LENGTH/LEFT/RIGHT/MID, concatenating fields, WHERE with operators, AND/OR/NOT, IS NULL/NULL, IN.
Social implications
Advantages and disadvantages of how mobile technology impacts privacy (personal and business). IoT technologies and impact on society.
PAT
PAT milestones including data collection overview and examples, location-based data, data warehousing and mining, database characteristics and problems, and analysis of requirements using an appropriate methodology.
Database: design and concepts
Logging in/passwords; relational database design; normalisation; transaction processing; characteristics of good database design; caring for and managing data; hacking through data. Database management and design concepts; split tables and create relations; key fields and relationships.
OOP
Reinforce programming skills: parameterised and non-parameterised constructors; correct use of private/public attributes; accessor, mutator and auxiliary methods; ToString and accessor methods for output; correct instantiation; use of methods as part of problem solving.
Hardware
Mobile technologies; factors influencing computer performance; motivate a typical computer system for user requirements.
SQL
Design and develop a solution incorporating SQL: SELECT fields, calculated fields (AS), ROUND/INT/LENGTH/LEFT/RIGHT/MID, concatenating fields, WHERE with operators, AND/OR/NOT, IS NULL/NULL, IN.
Social implications
Advantages and disadvantages of how mobile technology impacts privacy (personal and business). IoT technologies and impact on society.
PAT
PAT milestones including data collection overview and examples, location-based data, data warehousing and mining, database characteristics and problems, and analysis of requirements using an appropriate methodology.