Embedded Files
On completion of this unit the student should be able to apply the problem-solving methodology to create a solution using database management software, and explain the personal benefits and risks of interacting with a database.
To achieve this outcome the student will draw on key knowledge and key skills outlined in Area of Study 3.
Class Activities
Class Activities
- produce a folio of samples showing development in software skill acquisition using database management software
- select three different settings in which databases are used (e.g. employee list, school resource centre and supermarket inventory) and list the input data, data types and validation techniques necessary for each application
- list the characteristics of a database management system and describe its capabilities and limitations to manipulate data
- analyse several online input forms and identify the formats and conventions used
- identify criteria that can be used to ensure effective reports and list the criteria in order of importance, supporting your prioritised list with relevant examples
- design a database that records the music you have on your iPod/MP3 player/computer; identifying the fields required and any relevant validation techniques
Resources
Resources
- Introduction to MS Access 2016 (GCFLearning)
- Linking tables but not displaying IDs in MS Access
- Microsoft Access Help Center
- Introduction to SQL (Khan Academy, Codecademy)
- Data Base Mini-Courses @ Stanford Online (Advanced!)
Advanced
Advanced
Key Knowledge
Key Knowledge
Data and information
Data and information
- data sources and methods of data acquisition
- characteristics of effective data collection tools and user interfaces for the purposes of entering data efficiently
- characteristics of data types
Digital systems
Digital systems
- capabilities and limitations of database management software to manipulate data
- roles, functions and characteristics of hardware components used to input, store, communicate and output data and information
- accidental and deliberate security threats to data and information stored within databases
- physical and software controls suitable for protecting the security of stored and transmitted data
Approaches to problem solving
Approaches to problem solving
- the structure of a database, including fields, records and tables
- design tools for representing input forms to capture data and reports to meet specific needs
- design tools for representing the structure of databases
- techniques for manipulating and validating data
- formats and conventions applied to create effective solutions
Interactions and impact
Interactions and impact
- applications of database systems in a range of settings
- personal benefits and risks arising from the use of databases
Key Skills
Key Skills
- analyse needs or opportunities for database management solutions
- use appropriate techniques to describe data types and database structures
- identify and collect data from appropriate sources, using data collection tools that facilitate efficient data entry
- apply suitable functions to validate and manipulate data efficiently
- construct queries to locate data that matches specific criteria
- apply formats and conventions to create effective forms and reports
- evaluate the value of using a database system in fulfilling a personal need.
Report abuse