Kent Institute Database Fundamentals Project: College Admission System

This project showcases a comprehensive understanding of database fundamentals, focusing on the design and implementation of a relational database for a college admission system. The solution begins with an Entity Relationship Diagram (ERD) illustrating the relationships between entities such as students, degrees, modules, lecturers, and classes. It then details the creation of relational tables, defining attributes, data types, primary and foreign keys, and providing example data. The project includes the creation of forms for data input, followed by the population of these tables with sample data. Crucially, the solution demonstrates SQL queries, including select, join, and aggregate operations, to retrieve and manipulate data. Finally, a report summarizing the database's functionality is presented, alongside a bibliography of relevant academic sources. This project effectively covers the core concepts of database design, implementation, and querying, providing a practical example of database management principles.

Running head: DATABASE FUNDAMENTALS
Database Fundamentals
Name of the Student
Name of the University
Author’s note:

1DATABASE FUNDAMENTALS
Table of Contents
1. Entity Relationship Diagram:......................................................................................................2
2. Relational Tables:........................................................................................................................3
3. Create Database:..........................................................................................................................8
4. Forms:..........................................................................................................................................8
5. Input Data:.................................................................................................................................10
6. Query:........................................................................................................................................14
7. Report:.......................................................................................................................................17
Bibliography:.................................................................................................................................18

2DATABASE FUNDAMENTALS
1. Entity Relationship Diagram:
Figure 1: Entity Relationship Diagram of College Admission
(Source: Created by Author)

3DATABASE FUNDAMENTALS
2. Relational Tables:
Table: Student
Attribute Data Type Required Key Description Example
studentNumber Number Yes Primary The unique value that
helps finding the rows
uniquely
1
fullName Short Text Yes None The full name, first
and last name of the
student
Benjamin
Nangle
address Short Text Yes None The residential
address of the student
87 Jacabina
Court
phoneNumber Short Text Yes None The contact number of
student
(02) 4212
0358
degree Number Yes Foreign The reference to the
primary key of degree
entity
1
Table: Degree
Attribute Data Type Required Key Description Example
degreeCode Number Yes Primary The unique value that
helps finding the rows
1

4DATABASE FUNDAMENTALS
uniquely
title Short Text Yes None The name of the
degree course
B.E.
Table: DegreeModule
Attribute Data Type Required Key Description Example
degree Number Yes Primary The unique value that
helps finding the rows
uniquely
1
module Number Yes Primary The unique value that
helps finding the rows
uniquely
1
option Short Text Yes None This attribute defines
whether the module is
compulsory or not
compulsory
Table: Module
Attribute Data Type Required Key Description Example
moduleCode Number Yes Primary The unique value that
helps finding the rows
1

5DATABASE FUNDAMENTALS
uniquely
title Number Yes None The name of the
module
Python
credits Short Text Yes None The value of credit of
the module
10
department Short Text Yes None The department to
which the module
belongs to
CSE
Table: Class
Attribute Data Type Required Key Description Example
clasCode Number Yes Primary The unique value that
helps finding the rows
uniquely
1
module Number Yes Foreign The reference to the
primary key of
module entity
1
lecturer Number Yes Foreign The reference to the
primary key of
lecturer entity
1

6DATABASE FUNDAMENTALS
Table: Lecturer
Attribute Data Type Required Key Description Example
empCode Number Yes Primary The unique value that
helps finding the rows
uniquely
2
lecName Short Text Yes None The full name, first
and last name of the
lecturer
Isaac
Callaway
address Short Text Yes None The residential
address of the lecturer
21 William
Road
phoneNumber Short Text Yes None The contact number
of lecturer
(08) 8984
5285
unitCoordinator Number Yes Foreign The reference to the
primary key of
lecturer entity
1

7DATABASE FUNDAMENTALS
Figure 2: Dependency Diagram
(Source: Created by Author)

8DATABASE FUNDAMENTALS
3. Create Database:
4. Forms:

9DATABASE FUNDAMENTALS

10DATABASE FUNDAMENTALS
5. Input Data:
Student
studentNumber fullName address phoneNumber degree
1 Benjamin Nangle 87 Jacabina Court [phone] 1
2 Anthony Orr 11 Sunnyside Road [phone] 3
3 Zane Pethebridge 90 Point Walter Road [phone] 2
Degree
degreeCode title
1 B.E.
2 B.S.C.
3 B.A.

11DATABASE FUNDAMENTALS
DegreeModule
degree module option
1 1 compulsory
1 4 elective
2 2 compulsory
2 5 elective
3 3 elective
3 6 compulsory
Module
moduleCode title credits department
1 Python 10 CSE
2 Aljebra 10 Mathematics
3 History of Europe 8 History
4 Django 12 CSE
5 Geometry 8 Mathematics
6 World War 10 History