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

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

  • Identify different database design approaches by following workplace procedures.
  • Choose the right database design tools based on what users need.
  • Determine database structures accurately according to given specifications.
  • Develop a database design architecture that meets user requirements.
  • Perform database normalization correctly to fit application needs.
  • Create clear database model diagrams that satisfy both user and application requirements.
  • Generate a complete and professional database design report following workplace procedures.

These skills will help you build strong, efficient database systems that make managing information easier and more reliable in any workplace.

The rest of this chapter
🔒

Create a free account to open more of this chapter.

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

Create a free account
🔒1.2 Identification of database design tools

…

🔒1.3 Database structures.

…

🔒1.4 Database design architecture

Database design architecture is the overall structure that decides how a database is described, how the database management system (DBMS) is organised into layers and components, and how data, users and servers are arranged across machines and networks. A good…

🔒1.5 Database normalisation.

…

🔒1.6 Entity Relationship diagrams

…

🔒1.7 Database design report

…

Chapter Practical Activities

Practical 1: Establish Database Requirements for a School Management System

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.  Gather and document detailed database requirements for a school management system including entities, attributes, and relationships with at least six entities.
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.)
Data Modelling Tool (Lucidchart, EdrawMax, Draw.io etc.)
Notebook and Pen for notes
⬇ 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
3Notebook and Pen for notes1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Requirements Gathering
Candidate uses appropriate database requirements gathering techniques (interviews, questionnaires, observation)
(Award 1 mark for each technique correctly applied)		3
Candidate identifies and lists at least six relevant entities for the school management system
(Award 1 mark for each correctly identified entity, max 4)		4
Candidate specifies relevant attributes for each identified entity
(Award 1 mark for each entity with at least 2 appropriate attributes)		6
Candidate defines appropriate relationships between entities with cardinalities
(Award 1 mark for each correctly defined relationship with cardinality, max 4)		4
Candidate documents primary keys for each entity
(Award 1 mark for each entity with correctly specified primary key, max 3)		3
Candidate presents the gathered requirements clearly and logically using the data modelling tool
(Award 3 marks for clear, well-structured documentation and diagrams)		3
Sub-Total23
PRODUCT CHECKLIST
Complete and clear database requirements documentation including entities, attributes, primary keys, and relationships with cardinalities
(Award 7 marks for completeness, clarity, and accuracy of the documented requirements)		7
Sub-Total7
GRAND TOTAL30
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)

Practical 2: Explain DBMS Fundamentals and Key Concepts

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.  Prepare a documented explanation of DBMS fundamentals including definitions, functions, and key concepts in a report of minimum 3 pages.
2.  You have been provided with the following resources for the practical task:
Tools & EquipmentMaterials
Relational Database Management System (MySQL 8.0 or PostgreSQL 13)integer
Data Modelling Tool (Draw.io or Lucidchart)varchar
Rewritable Compact Disc (CD-RW)date/time
⬇ PDFResources Required (Cutting List)
S/NItemQuantity
1Relational Database Management System (MySQL 8.0 or PostgreSQL 13)1 Instance per Candidate
2Data Modelling Tool (Draw.io or Lucidchart)1 License per Candidate
3Rewritable Compact Disc (CD-RW)1 Pc per Candidate
⬇ PDFAssessor Guide
Items to be EvaluatedMarks AvailableMarks ObtainedComments
TASK 1: Explain DBMS Fundamentals
Candidate defines DBMS and explains its purpose
(Award 1 mark for each correct aspect: definition, purpose, example)		3
Candidate correctly defines key terms: database, DBMS, schema, instance
(Award 1 mark for each term correctly defined)		4
Candidate explains at least four main functions of a DBMS
(Award 1 mark for each function clearly explained: storage, retrieval, security, backup)		4
Candidate demonstrates use of the RDBMS tool to create a sample database schema with at least two tables
(Award marks for correct creation of schema, tables, attributes, and primary keys)		5
Candidate uses Data Modelling Tool to diagrammatically represent the database schema
(Award marks for clear, correct ER diagram with entities, attributes, and relationships)		3
Sub-Total19
TASK 2: Document and Present Findings
Candidate prepares a clear, concise written report explaining DBMS fundamentals
(Award marks for clarity, completeness, and correct terminology)		5
Candidate saves the report and ER diagram on the CD-RW and demonstrates retrieval
(Award marks for correct saving, naming, and retrieval of files)		3
Candidate answers assessor's questions on DBMS concepts confidently
(Award marks for accurate, clear verbal responses)		3
Sub-Total11
PRODUCT CHECKLIST
Written report is well structured, minimum 3 pages, with correct DBMS fundamentals and terminology
(Award marks for content accuracy, structure, and language)		5
Database schema created in RDBMS with at least two tables and primary keys correctly defined
(Award marks for correct schema creation and attribute specification)		5
ER diagram correctly drawn showing entities, attributes, and relationships
(Award marks for completeness and clarity)		5
Report and ER diagram saved and retrieved successfully from CD-RW
(Award marks for file management and demonstration)		4
Sub-Total19
GRAND TOTAL49
ASSESSMENT OUTCOME:   ☐ Competent    ☐ Not Yet Competent (competent if at least 50%)
🔒

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

Create a free account
🔒Identify and Classify Real-World Database ApplicationsPractical 3
🔒Classification and Explanation of Database Management System TypesPractical 4
🔒Describe and explain the major components of a DBMS environmentPractical 5
🔒Illustrate and explain the three levels of database architecturePractical 6
🔒Comparison of Database Models with Sample ImplementationsPractical 7
🔒Design a Conceptual Database Schema Using ERD for a School Management SystemPractical 8
🔒Physical database design implementation for a school management systemPractical 9
🔒Design a Hierarchical Database Model Diagram for a Library Management SystemPractical 10
🔒Model a network database diagram for a library management systemPractical 11
🔒Design an Object-Oriented Database Model for a Library SystemPractical 12
🔒Design a dimensional database model for sales data warehousePractical 13
Am I competent?

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

  • Identify different database design approaches by following workplace procedures.
  • Choose the right database design tools based on what users need.
  • Determine database structures accurately according to given specifications.
  • Develop a database design architecture that meets user requirements.
  • Perform database normalization correctly to fit application needs.
  • Create clear database model diagrams that satisfy both user and application requirements.
  • Generate a complete and professional database design report following workplace procedures.

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 2: To create database system →