Unit 10 - Database Development

Welcome to Unit 10: This unit is all about providing an in-depth exploration of database systems and how they work. We firstly got some general and important information about databases and then we focused on the skills necessary for effective database management. The coursework has been both challenging and rewarding, particularly as we had to work into comparing, designing, and creating databases in a given scenario. It was organised in three tasks

This Units purpose it to get knowledge about:

Creating Tables.

Creating Forms.

Creating Queries.

Understanding Validation Rules.

Creating Reports.

Understanding Sub forms.

Understanding Data Types.

Task 1:

In Task 1, we conducted a detailed and comprehensive comparison of two different database systems (Database 1 & 2). This was crucial and very important in understanding the strengths and weaknesses of various database technologies and helped us develop a critical eye for evaluating database solutions.

Task 2:

Task 2 involved designing a database for a doctor's surgery (GP) that needed an improved database management system to efficiently manage patient information, appointments and doctors info. This task required us to apply our knowledge of database design principles which includes the identification of necessary data types and the structuring of data to ensure efficiency and accessibility.

Task 3:

The final assignment focused on the actual creation of the database designed in Assignment 2. This practical exercise involved building tables, forms, queries, and reports, organise the datasheet view in a way that is easy manageable which indeed was beneficial. It played a part of transforming our theoretical designs into a functional database system.

Evaluation:

Throughout this unit, I have gained useful knowledge and wide variety of various skills crucial for database development. This unit has significantly enhanced my understanding of database development and management. Even though it was not easy in the beginning, once you get used to it is completely manageable and I am confident in the abilities I gained to design, create, and maintain effective database systems, and I look forward to applying these skills in real-world scenarios. 

Unit 10 Overall Grade: Distinction*