Database program / UC1PR2101

Database program / UC1PR2101

The assessment for the Programming and Databases course was to design and create a database program for an imaginary company. The company we were to treat as a client were the bookstore “Murder and Mischief” – a bookstore moving from physical...
SQLite / UC1PR2101

SQLite / UC1PR2101

Finally we were going to move from design and modelling, to actually writing some SQL scripts. For me, writing a language as SQL seemed easy, since it is very related to how I used to write CSS (Cascading Style Sheets). So it felt familiar, but – where the...
Data Quality / UC1PR2101

Data Quality / UC1PR2101

Data quality – where to begin? There are so many reasons why good quality data is important. Firstly, it can be a great source for having a great resource in your business or any other operation – but more importantly, bad data can be equally harmful. Most...
Normalisation / UC1PR2101

Normalisation / UC1PR2101

Normalisation is one of the learning points that I were really excited about. To begin with a little story; as previous mentioned I have worked with databases on a “maintenance” and lighter level for many years. And when I were called in for an interview...
Data modelling / UC1PR2101

Data modelling / UC1PR2101

After the introduction to databases and key concepts of what it is and how we can use it – it is time to get down to how we design it. In the past, I have through working in IT heard about database modelling, but never gotten into it properly. There are several...
Databases / UC1PR2101

Databases / UC1PR2101

I am very excited to start the new course – Programming and Databases. In the past I have had a lot to do with databases, especially working in Joomla. But, although I have had a lot to do with it – I have not programmed any of them from scratch. Most of...