2025/2026
Designing
Student
Database
Unit 4: Database Design and Development
HNC COMPUTING
NEWCASTLE AND STAFFORD COLLEGES GROUP
, Contents
Purpose..................................................................................................................................................1
Data Dictionary......................................................................................................................................4
Table 1: Students...........................................................................................................................4
SQL Code:.......................................................................................................................................4
Table 2: Courses.............................................................................................................................5
SQL Code:.......................................................................................................................................5
Data Validation:.................................................................................................................................5
Table 3: Staff..................................................................................................................................6
SQL Code:.......................................................................................................................................6
Data Validation:.................................................................................................................................6
Table 4: Classes..............................................................................................................................7
SQL Code:.......................................................................................................................................7
Data Validation:.................................................................................................................................7
User Interface........................................................................................................................................8
Input Design.......................................................................................................................................8
Output Design....................................................................................................................................9
Data integrity.......................................................................................................................................10
Data validation.....................................................................................................................................10
Data security........................................................................................................................................11
Data controls.......................................................................................................................................11
Assessment of the Design....................................................................................................................12
Strengths.........................................................................................................................................12
Weaknesses.....................................................................................................................................12
Object Orientate Database Systems....................................................................................................13
References...........................................................................................................................................14
Purpose
A database is a structured collection of data organized to facilitate
efficient retrieval, storage, and manipulation of information. Its role is
central to modern information management, serving as a repository for
various types of data crucial to organizational operations. Databases play
a vital role in enabling businesses, institutions, and individuals to store,
1
Jessreen Sandhu
Designing
Student
Database
Unit 4: Database Design and Development
HNC COMPUTING
NEWCASTLE AND STAFFORD COLLEGES GROUP
, Contents
Purpose..................................................................................................................................................1
Data Dictionary......................................................................................................................................4
Table 1: Students...........................................................................................................................4
SQL Code:.......................................................................................................................................4
Table 2: Courses.............................................................................................................................5
SQL Code:.......................................................................................................................................5
Data Validation:.................................................................................................................................5
Table 3: Staff..................................................................................................................................6
SQL Code:.......................................................................................................................................6
Data Validation:.................................................................................................................................6
Table 4: Classes..............................................................................................................................7
SQL Code:.......................................................................................................................................7
Data Validation:.................................................................................................................................7
User Interface........................................................................................................................................8
Input Design.......................................................................................................................................8
Output Design....................................................................................................................................9
Data integrity.......................................................................................................................................10
Data validation.....................................................................................................................................10
Data security........................................................................................................................................11
Data controls.......................................................................................................................................11
Assessment of the Design....................................................................................................................12
Strengths.........................................................................................................................................12
Weaknesses.....................................................................................................................................12
Object Orientate Database Systems....................................................................................................13
References...........................................................................................................................................14
Purpose
A database is a structured collection of data organized to facilitate
efficient retrieval, storage, and manipulation of information. Its role is
central to modern information management, serving as a repository for
various types of data crucial to organizational operations. Databases play
a vital role in enabling businesses, institutions, and individuals to store,
1
Jessreen Sandhu
