Unit Name: Unit 3 Data and Database Systems
Unit Code: D/650/8504
Level: 4 Â Â
Credit: 15Â Â Â Â Â
GLH: 60
Please click the following link for downloading the Specifications for ATHE Level 4 Computing:
ATHE Level 4 Computing Specification v1.0 091023
Unit Aims:Â
All IT professional roles will bring practitioners into contact with data and databases. For example: Analysts will gather, organise and manipulate data for use in a variety of ways; Cyber Security Technicians will manage the privacy and security of data and data systems; Software Developers and DevOps Engineers will create and maintain systems containing complex data.
This unit introduces learners to data and database systems by exploring the concept of data, data modelling and creating systems to hold and manage data. It takes a real-world view of database and database design, without focusing on data manipulation, which will be introduced in a later unit.
Data and Database Systems Video 1:
Course Curriculum
1. Understand what is meant by data. | |||
1.1 Describe different categories of data. Details | 00:00:00 | ||
1.2 Explain the differences between structured and unstructured data. Details | 00:00:00 | ||
1.3 Explain the concept of data types and structures, and the importance of selecting the most appropriate data type of an identified data item. Details | 00:00:00 | ||
1M1 Assess the importance of data classification. Details | 00:00:00 | ||
1D1 Evaluate the importance of data to an organisation. Details | 00:00:00 | ||
2. Understand database design. | |||
2.1 Explain different types of database. Details | 00:00:00 | ||
2.2 Describe the different relationship types, join types and types of key. Details | 00:00:00 | ||
2.3 Explain normalisation and functional dependency within a database. Details | 00:00:00 | ||
2.4 Describe database administration including integrity and security control. Details | 00:00:00 | ||
2M1 Assess the integrity constraints within relational models. Details | 00:00:00 | ||
3. Design a database system. | |||
3.1 Design a relational database to meet a specified design brief. Details | 00:00:00 | ||
3.2 Apply normalisation to a series of documents to 3NF. Details | 00:00:00 | ||
3.3 Use database documentation tools to document a design to meet a design brief. Details | 00:00:00 | ||
3.4 Present your design to the client using a suitable format. Details | 00:00:00 | ||
3M1 Identify the opportunities to implement validation and verification to enhance the integrity of the database. Details | 00:00:00 | ||
3D1 Evaluate database design and how it meets the technical requirements of the brief following feedback. Details | 00:00:00 | ||
Slides for Data and Database Systems | |||
Data and Database Systems Lecture 1 Slides Details | 00:00:00 | ||
Lectures for Data and Database Systems | |||
Assignment Brief for Data and Database Systems |
Course Reviews
No Reviews found for this course.