Departments› Software Development› Module III› Computerised Database Systems Management› Ch 2: To create database system
Software Development  ·  Level 6
Computerised Database Systems Management
Chapter 2: To create database system
📚 8 Topics
← Chapters ⬇ Download PDF
⚑ What you will be able to do

By the end of this chapter, you will be able to:

  • Choose the right database management software based on the system needs.
  • Set up the database development environment correctly to match application requirements.
  • Create database objects accurately by following design plans.
  • Apply data attributes properly as detailed in the database design.
  • Build data relationships correctly according to the design specifications.
  • Follow workplace safety and health practices that meet OSHA standards.
  • Identify the correct methods for storing and disposing of e-waste safely.
  • Demonstrate proper e-waste management following OSHA guidelines.

These skills will help you build reliable database systems while keeping your workplace safe and environmentally responsible—key qualities for success in the tech trade!

Chapter Practical Activities

Practical 1: Create a student registration database with tables and fields

Software Development · Level 6
Computerised Database Systems Management
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Create a database named 'StudentRegistration' with three tables: Students (StudentID, FirstName, LastName, DateOfBirth, Email), Courses (CourseID, CourseName, DurationMonths), and Enrollments (EnrollmentID, StudentID, CourseID, EnrollmentDate) with appropriate data types and primary keys.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Relational Database Management System (MySQL, PostgreSQL, MS SQL Server)Rewritable Compact Disc (CD-RW)
Data Modelling Tool (Lucidchart, EdrawMax, Draw.io)
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Relational Database Management System (MySQL, PostgreSQL, MS SQL Server)1 Pc per Candidate
2Data Modelling Tool (Lucidchart, EdrawMax, Draw.io)1 Pc per Candidate
3Rewritable Compact Disc (CD-RW)1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Create database and tables
Created database named 'StudentRegistration'
(Award 1 mark for correct database creation)		1
Created table 'Students' with fields and appropriate data types
(Award 1 mark for each correct field and data type: StudentID integer PK, FirstName varchar, LastName varchar, DateOfBirth date, Email varchar)		4
Created table 'Courses' with fields and appropriate data types
(Award 1 mark for each correct field and data type: CourseID integer PK, CourseName varchar, DurationMonths integer)		3
Created table 'Enrollments' with fields and appropriate data types
(Award 1 mark for each correct field and data type: EnrollmentID integer PK, StudentID integer FK, CourseID integer FK, EnrollmentDate date)		4
Set primary keys on StudentID, CourseID, EnrollmentID fields respectively
(Award 1 mark for each primary key defined)		3
Set foreign key constraints on Enrollments.StudentID and Enrollments.CourseID referencing Students and Courses respectively
(Award 1.5 marks for each foreign key constraint)		3
Used consistent naming conventions for tables and fields
(Award 2 marks for consistent and meaningful naming)		2
Sub-Total20
PRODUCT CHECKLIST
Students table with fields: StudentID (integer, PK), FirstName (varchar), LastName (varchar), DateOfBirth (date), Email (varchar)
(Award 3 marks for correct fields, data types, and primary key)		3
Courses table with fields: CourseID (integer, PK), CourseName (varchar), DurationMonths (integer)
(Award 2 marks for correct fields, data types, and primary key)		2
Enrollments table with fields: EnrollmentID (integer, PK), StudentID (integer, FK), CourseID (integer, FK), EnrollmentDate (date)
(Award 3 marks for correct fields, data types, primary key, and foreign keys)		3
Referential integrity enforced via foreign keys between Enrollments and Students, and Enrollments and Courses
(Award 2 marks for correct foreign key constraints)		2
Database structure follows normalization and best design practices
(Award 2 marks for normalization and consistent naming)		2
Sub-Total12
GRAND TOTAL32
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)

Practical 2: Define Primary and Foreign Keys in a Student-Subject Database

Software Development · Level 6
Computerised Database Systems Management
PRACTICAL ASSESSMENT
TIME: 4 HOURS
⬇ PDFCandidate Instructions (Candidate Tool)

Type: Individual

INSTRUCTIONS TO CANDIDATE:
1.  You are required to perform the following task:
i.  Create six (6) database tables with defined primary keys and foreign keys.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Relational Database Management System (MySQL, PostgreSQL, MS SQL Server etc.)integer
Data Modelling Tool (Lucidchart, EdrawMax, Draw.io etc.)varchar
Rewritable Compact Disc (CD-RW)date/time
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Relational Database Management System (MySQL, PostgreSQL, MS SQL Server etc.)1 Pc per Candidate
2Data Modelling Tool (Lucidchart, EdrawMax, Draw.io etc.)1 Pc per Candidate
3Rewritable Compact Disc (CD-RW)1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Define Database Keys
Mapped entities from the ERD into six (6) relations
(Award 1 mark per correctly mapped relation, zero if incorrect)		3
Specified attributes for the six (6) relations
(Award 1 mark per table for correct attributes with data types)		6
Specified primary keys for the six (6) relations
(Award 0.5 mark per correct primary key per table)		3
Specified composite primary keys for the marks and subject-teacher relations
(Award 1 mark per correct composite primary key)		2
Enforced referential integrity by specifying foreign keys in the referencing relations
(Award 1 mark per correctly defined foreign key with constraints)		4
Printed the relational schema
(Award 1 mark for clear, complete printed schema)		1
Sub-Total19
PRODUCT CHECKLIST
Created database and six (6) tables with required attributes and data types
(Award 2 marks per table created with correct attributes and data types)		12
Enforced entity integrity (primary key) constraints in the six (6) tables
(Award 1 mark per table for correct primary key enforcement)		6
Enforced referential integrity (foreign key) constraints in the six (6) tables
(Award 1 mark per table for correct foreign key enforcement)		6
Utilized best practices in Database Design: (a) Well normalized relations (b) Consistent naming scheme for relations and attributes
(Award 2 marks for normalization, 2 marks for consistent naming)		4
Sub-Total28
GRAND TOTAL47
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)
🔒

Free: practical guides, quick cards, workplace scenarios and more.

Create a free account
🔒Link tables by establishing data relationships in a student database systemPractical 3
🔒Create a one-to-one relationship between Employee and EmployeeDetail tablesPractical 4
🔒Establish a one-to-many relationship between Customers and Orders tablesPractical 5
🔒Establish Many-to-One Relationship Between Customer and Orders TablesPractical 6
🔒Create a Junction Table to Implement Many-to-Many RelationshipsPractical 7
🔒Create Queries to Retrieve Data from a Student DatabasePractical 8
🔒Design and Create User-Friendly Database Forms for Student RecordsPractical 9
🔒Generate Formatted Database Reports from Student Performance DataPractical 10
🔒Create and Use Database Macros for AutomationPractical 11
🔒Implement Database Indexing for Performance ImprovementPractical 12
🔒Create and manage records within database tablesPractical 13
🔒Create and manage database objects for student performance trackingPractical 14
🔒Development of a Student Performance Database SystemPractical 15
Am I competent?

At the start of this chapter we promised you would be able to:

  • Choose the right database management software based on the system needs.
  • Set up the database development environment correctly to match application requirements.
  • Create database objects accurately by following design plans.
  • Apply data attributes properly as detailed in the database design.
  • Build data relationships correctly according to the design specifications.
  • Follow workplace safety and health practices that meet OSHA standards.
  • Identify the correct methods for storing and disposing of e-waste safely.
  • Demonstrate proper e-waste management following OSHA guidelines.

Tick each one you can genuinely do.

So, are you there yet?

You're competent when you can confidently do 50% or more of what this chapter promised.

Sign in to record how you're doing.

← Ch 1: To design database system Ch 3: To manipulate computerized database →