Data Principles and Database Development

This module lays the foundations for the key principles of Data, and its use within Databases. It covers concepts such as the Data Lifecycle, Relational Databases, MySQL and Database Management.

Assignment 1

Assignment 1 focused on collating all the knowledge surrounding Data and Databases and it’s surrounding considerations such as Law and Legislation and Ethics. This collation was put into the form of a powerpoint, then presented to my peers and lecturers.

Thanks to this assignment, I improved my comprehension of fundamental practices regarding data and databases. I learned to breakdown the life-cycle of data, such as the 8-stage model, and the differing database types and their use cases. This assignment also improved my understanding of law and legislation surrounding data, particularly how processing and storing data relates to UK legislation such as the UKGDPR. Along with this, I have developed skills in identifying and mitigating ethical concerns, and how potential policies such as privacy policies and training/awareness can be used to help maintain proper standards.

Assignment 2

Assignment 2 put alot of my knowledge gained from Assignment 1, and made me apply it by creating and documenting a database with SQL to a clients specification, along with a set of queries and diagrams.

This assignment challenged my database knowledge and skills. Most prominently my ability to write and make use of SQL, in this case using mySQL to navigate and initialise the database. I was also able to glean more experience in creating diagrams and models for the database, this was presented as conceptual, logical and physical data models as well as data flow and entity relationship diagrams. Additionally, I further developed the ability to conduct comprehensive testing, now being able to identify issues and incorrect use of SQL to create queries.