COMPUTERIZED DATABASE SYSTEMS
ISCED UNIT CODE: 0612 451 08A
TVET CDACC UNIT CODE: IT/CU/ICTA/CR/03/5/MA
Duration of Unit: 200 Hours
Relationship to Occupational Standards
This unit addresses the unit of competency: Manage Computerized Database Systems
Unit Description:
This unit covers the competencies required to manage computerized database systems. It
involves designing computerized database, creating computerized database, manipulating
computerized database, testing computerized database and maintaining computerized
database.
Summary of Learning Outcomes:
Learning Outcomes Durations (Hours)
om
.c
et
tv
1. Perform website Application user need analysis 30
sy
ea
2. Design website application 50
3. Develop website application 50
4. Host the website application 30
5. Test the website application 20
6. Maintain the website application 20
Total Hours 200
Learning Outcomes, Content and Suggested Assessment Methods
Learning Outcome Content Suggested Assessment
Methods
1. Perform 1.1 Website user requirements • Practical test
70
©TVET CDACC, 2025
Website User identification • Projects
Needs Analysis 1.1.1 Introduction to Web • Learner Portfolio of
Programming evidence
[Link] Definition of key web • Oral questioning
terms. • Interviews
[Link] History of the Internet, • Third party report
the Web, CSS & HTML • Written tests
[Link] Web • Case study
programming/scripting
languages
[Link] Current trends
1.1.1. Importance of websites
1.1.2. Types of websites
1.1.3. Website design requirements
[Link] Types of user
requirements
om
[Link].1 Functional
.c
et
tv
sy
requirements
ea
[Link].2 Non-
functional
requirements
[Link] User requirements
identification
[Link] User requirements
analysis
1.2 Website user requirements
documentation
1.2.1 User requirements
documentation tools
1.2.2 Preparation of user
requirements specifications
71
©TVET CDACC, 2025
document
1.3 Website user requirements
specifications review
1.3.1 Importance of user
requirement review
1.3.2 User requirement review
techniques
1.3.3 User requirements
specifications validation and
verification
1.4 User requirements review process
1.5 Updating user requirements
specifications document
2. Design Website 2.1 Website application design tools • Practical test
2.1.1 Introduction website design • Projects
[Link] Website design • Learner Portfolio of
mo
principles
.c
evidence
et
tv
sy
[Link] Website Design Process •
ea
Oral questioning
[Link] User Experience (UX) • Interviews
design • Third party report
2.1.2 Introduction website design • Written tests
tools
• Case study
[Link] Figma
[Link] WordPress
[Link] Canvas
[Link] Wix
[Link] Adobe Dreamweaver
2.1.3 Factors to consider when
selecting design tools
2.1.4 Installation and
configuration design tools
72
©TVET CDACC, 2025
2.2 Implementation of website design
methods
2.2.1 User-Cantered Design
2.2.2 Visual Design
[Link] Elements of Visual
Design
2.2.3 Interaction Design
2.2.4 Wireframing and
Prototyping
2.3 Development of website application
visual hierarchy
2.3.1 Graphical user interface
2.3.2 Hierarchy of Elements
[Link] Typography
[Link] Color and contrast
[Link] Spacing and Layout
om
[Link] Reading patterns
.c
et
tv
sy
[Link] Size and scale
ea
[Link] Proximity and repetition
[Link] Alignment
[Link] Texture and style
2.4 Creation of website application site
map
2.4.1 Importance of site maps for
web design and SEO
2.4.2 Types of site maps
2.4.3 Creating visual site maps
2.4.4 Creating website wireframes
3. Develop The 1.1 Creation of web pages • Practical test
Website 1.1.1 HTML Coding • Projects
[Link] Introduction to HTML5 • Learner Portfolio of
73
©TVET CDACC, 2025
[Link] HTML Tags evidence
[Link].1 Structural elements • Oral questioning
and attributes • Interviews
[Link].2 Formatting HTML • Third party report
documents • Written tests
[Link].3 Tables • Case study
[Link].4 Linking Web Pages
[Link].5 Working with
Layouts
[Link].6 Special effects and
Animation using
HTML5
[Link].7 Multimedia
[Link].8 Managing forms
[Link].9 DOM
[Link].10 Events
om
[Link].11 HTML frameworks
.c
et
tv
sy
(Bootstrap and
ea
Tailwind)
1.1.2 Cascading Style Sheets (CSS)
[Link] Introduction to CSS
[Link] Various types of styles sheets
[Link] Inheritance and cascading
order
[Link] Formatting text, fonts, colours
and Background
[Link] Exploring CSS class and ID
attributes
[Link] HTML Tags
[Link] Block eleven elements
[Link] Fundamentals of Document
74
©TVET CDACC, 2025
Object Model (DOM)
1.1.3 Website Scripting
[Link] Functions of scripting
languages
[Link] Types of scripting languages
[Link] Java scripting
[Link].1 Introduction to
JavaScript
[Link].2 Statements Syntax
[Link].3 Values & Variables
[Link].4 Operators
[Link].5 Statements
[Link].6 Event Handling
[Link].7 Timing Events
[Link].8 Functions and objects
1.2 Website Backend Creation
mo
1.2.1 Database Creation
.c
et
tv
sy
1.2.2 Introduction to MYSQL
ea
1.2.3 File systems and databases
1.2.4 Relational database Models
1.2.5 SQL
1.2.6 Entity Relationship modelling
1.2.7 Normalization of database tables
1.2.8 Database design
1.2.9 Working with Database Schemas
1.2.10 Create-Read-Update-Destroy
(CRUD)
1.2.11 Joins
1.2.12 Aggregate Functions and Groups
1.2.13 Sub Queries
1.3 Website application frontend and
75
©TVET CDACC, 2025
backend integration
1.3.1 PHP
[Link] Importance of PHP
[Link] Fundamentals of PHP
Development
[Link] Various Data Types
[Link] Advanced PHP Functions
[Link] Classes
[Link] Objects
[Link] Various Database concepts
[Link] Cookies and Session
Management
[Link] How to work with forms and
system file
[Link] Error Handling
[Link] Secure PHP Programming
om
[Link] Performance Optimization
.c
et
tv
sy
of PHP Applications
ea
[Link] Model View Controller
(MVC)
1.3.2 Jquery:
[Link] Introduction to JQuery
[Link] Selectors
[Link] Jquery – DOM
[Link] Jquery Events
[Link] Ajax
[Link] UI (User Interface)
2. Host the 2.1 Website application hosting platform • Practical test
Website 2.1.1 Introduction to website hosting • Projects
2.1.2 Types of website hosting services • Learner Portfolio of
2.1.3 Factors to consider when evidence
76
©TVET CDACC, 2025
selecting a host • Oral questioning
2.1.4 Website hosting process • Interviews
2.2 Server environment setup • Third party report
2.2.1 Configuring hosting environment • Written tests
(cPanel, Plesk) • Case study
2.2.2 Installing web servers (Apache,
nginx)
2.2.3 Database set up (MySQL,
PostgreSQL)
2.3 Uploading website application files.
2.3.1 Methods of uploading files
2.3.2 Connecting files to the server
2.4 Website server configuration
2.4.1 Importance of website server
configuration
2.4.2 Setting up virtual hosts
m
o
2.4.3 Configuring directory structures
.c
et
tv
sy
and permissions
ea
2.4.4 Managing server files and
directories
2.4.5 Implementing SSL/TLS
2.4.6 Firewall and access control
configurations
2.4.7 Backup configuration
2.4.8 Setting server monitoring tools
3. Test The 5.1 Website application test plan • Practical test
Website 3.1.1 Importance of website • Projects
application testing • Learner Portfolio of
3.1.2 Importance of website evidence
application test plan • Oral questioning
3.1.3 Preparation of website • Interviews
77
©TVET CDACC, 2025
application test plan • Third party report
5.2 Website application testing techniques • Written tests
selection • Case study.
3.2.1 Types of website application
testing techniques
[Link] Functionality Testing
[Link] Black box
[Link] Regression
[Link] unit
[Link] Usability Testing
[Link] Interface Testing
[Link] Compatibility Testing
[Link] Performance Testing
[Link] Security Testing
3.2.2 Factors to consider when
selecting website application
om
testing techniques
.c
et
tv
sy
5.3 Website application testing
ea
3.3.1 Website application testing tools
3.3.2 Website application testing
standards, procedures and user
requirements
3.3.3 Preparation of website
application test data
3.3.4 Perform website application
testing
5.4 Test report development
3.4.1 Importance of website
application test report
3.4.2 Website application test report
development tools
78
©TVET CDACC, 2025
3.4.3 Preparation of website
application test report
4. Maintain The 4.1 Website monitoring • Practical test
Website 4.1.1 Importance of website • Projects
maintenance. • Learner Portfolio of
4.1.2 Website monitoring tools evidence
4.1.3 Integrate website monitoring • Oral questioning
tools (Google analytics) • Interviews
4.1.4 Analysis of website traffic and • Third party report
performance data • Written tests
4.2 Development of Monitoring report
• Case study.
4.2.1 Importance of Monitoring report
4.2.2 Website monitoring via logging
practices
4.2.3 Preparation of Monitoring report
4.3 Fixing website application bugs
mo
4.4 Updating website application
.c
et
tv
sy
4.4.1 Updating and archiving of
ea
website content
4.4.2 Creation of website pages
4.4.3 Website version upgrading
4.4.4 Vulnerability scans and updates
4.5 Backing up Website
4.5.1 Importance of website data back
up
4.5.2 Types of website data back up
4.5.3 Website data backup tools
Suggested Delivery Methods
• Demonstration by trainer
79
©TVET CDACC, 2025
• Practical work by trainee
• Viewing of related videos
• Group discussions
• Direct instructions
• Instructor led facilitation using active learning strategies
Recommended Resources for 25 Trainees
S/No. Category/Item Description/ Quantity Recommended
Specifications Ratio
(Trainee: Item)
A Learning Materials
1. Textbooks 5pcs 5:1
2. Installation manuals
m
o
.c
et
tv
3. Charts
sy
ea
4. PowerPoint presentations For trainer’s use
B Learning Facilities &
infrastructure
1. Lecture/theory room 1 25:1
2. Computer Laboratory 1 25:1
C Consumable materials
3. Printing papers 1 ream 1:20
4. Toners 2 pcs 13:1
5. Assorted colour of whiteboard
markers
80
©TVET CDACC, 2025
D Tools and Equipment
6. Computers 25 pcs 1:1
7. Projector 1pc 25:1
8. Printers 5 pcs 5:1
9. Whiteboard 1pc 25:1
10. flash drives 5 pcs 5:1
11. External Hard drive 5 pcs 5:1
12. Microsoft Access 25 pcs 1:1
13. MYSQL 25 pcs 1:1
14. Test Data Generator 25 pcs 1:1
15. WAMP/XAMP 25 pcs 1:1
om
.c
et
tv
sy
ea
81
©TVET CDACC, 2025