dataabse system working area introduction.pptx

dataabse system working area introductio

1. DATABASES IGCSE Computer Science Chapter 9 START

2. A database is an organised collection of data. In a database, you can organise data in a table format . ID Name Age House Students Info

3. BRAINSTORM What are some usages of databases?

4. 9.1 CHAPTER OUTLINE Important terms related to databases 9.2 Types of databases 9.3 Creating a database 9.4 Using query

5. THE FOLLOWING TUTORIALS ARE MADE USING MICROSOFT ACCESS

6. Step 2: Select Design View and you will be prompted to create a table.

7. Step 4: Add validation to your fields - Age. Restrict age to be between 7 to 18.

8. Step 5: Select table and enter data into it.

9. Testing out validation Try to enter a value >18 into the Age field.

10. Queries Queries are used for working with data in a database. You can search data by certain criteria such as "searching the records in which students are aged 11 or older". ID First Name Age House Last Name 001 Jay 11 Yellow Chou 002 Jane 10 Red 003 Will 13 Blue Smith 004 Max 12 Green Verst 005 Anna 11 Yellow Maria Watson Query: Can you show me only the records of students who are 11 years old. Student Data Structured Query Language ID First Name Age House Last Name 001 Jay 11 Yellow Chou 005 Anna 11 Yellow Maria

11. Method 1: Using Query-by Step 4: Click Run Step 5: Result!