BTEC IT Week 3 Unit 2 Creating systems

BTEC IT – Week 3 - Unit 2 Creating systems to manage information The purpose and structure of relational database management systems

Task 4 a - Data & databases Data is all around us, your social media newsfeed, mobile phone call list, the weather forecast, etc. Data becomes information when it is useful to us and we can use it in a meaningful way. • Think of all the sources of data that you have accessed recently. Add at least five examples For each of the above sources • Were these sources of data useful to you? • Could they have presented the data in a different way to make it more useful. • What are the implications if the data is inaccurate?

Relational Database Management Systems There a number of types of RDMS, which can broadly be categorised in the following ways • Desktop systems – e. g. Access • Clint-server database systems • Open source database system – e. g. My. SQL • Proprietary database systems – e. g. Oracle Database

Example database creation – Customer orders Image that you have ordered all of your Christmas presents from a single online store. As you will have placed a number of orders, they would keep the data in at least two (probably three or even four) tables. One table would hold the information about you, the customer, the other would hold the information about the orders that you have placed. In theory this data can be held in one table, but then every time you placed an order you would need to include all of your details again. This would mean duplicating a lot of data; therefore, it is much better solution to split the data into different tables. However, there needs to be a way to link (relate) the two tables together so that the store know which customer has placed which order. The best solution is to use a unique identifier (a customer number).

Task 4 b - Example database creation – Customer orders Complete the table below. Using the following information: • Data types – Text, Number, Auto. Number, Date/Time & Currency are the only data types required in the two tables below. Pick one for each field. • If you have chosen Text for the data type add a field size otherwise put NA into the cell. • Add an example piece of data for each field. Field name Data type Field size Example Field name Cust_No Order# F_Name Cust_No S_Name Product. ID Addr_1 Product Addr_2 Price Town Qty Postcode Total Phone# Order_Date Email Data type Field size Example

BTEC IT – 2020 Summer Induction tasks Week 3 - Task 4 a - Data & databases Answer the questions either on the slide or in a separate document Week 3 - Task 4 b – Example database creation – Customer orders Complete the database design table Submit your finished work to heleyt@Vandyke. cbeds. co. uk by Friday 3 rd July 2020