The internet is an amazing place! It is generally a positive experience. It's a place where we can live a virtual life, chatting with friends on Social Networking sites, sharing messages and emoticons. We can create an account with an eCommerce site and browse products that we might want to buy. We can pay for it electronically, too. When we're hungry we can go to a food delivery website and order our favourite dishes. Wow! Is there nothing we can't do?! But what most people don't realise is that most websites are really just boring databases made to look pretty!
Look at the image above - users connecting to the different online services never thinking of the database that works tirelessly in the background.
Introduction: You will be introduced to a database! You will learn about the basic structure of a database table (fields and records) and you will look at a quick way to sort and filter data.
Queries! In this unit, you will learn how to make basic queries - this just means that we are filtering and sorting data but we can design a query and save it. This is very convenient if we want to run the same query many times.
And/Or In this unit, you will learn how to filter data using 2 very useful keywords in your query design.
Grouping Data In this unit, you will learn how to filter data into groups. For example, we may have a table of data with many records about people and we want to group the data by Nationality and display a count of each nationality or the average age of people from each country listed in the database table.
Data Validation - research techniques to ensure data entered into a database table is valid.
Calculated fields - calculating new data using stored data - this saves precious storage space!
Reports - generating formatted reports from table and query data.
This unit will introduce you to relational databases. These are databases with more than 1 table and some of the tables have related data in them.
This is another chance to consider a situation using a relational database. It introduces the class Library Database and shows us how to create a useful Data Entry Form.
Mini Project - you will develop a relational database using your own design idea.