Task: Design This Database

Blog Task 1

Answer the following questions:

1. What does a column in a table represent? Field
2. What does a row in a table represent? Record - A group of records about a certain object or person that has been applied to the selected fields
3. What does DBMS stand for?
A Database Management System (DBMS)

4. What is a primary key in a table used for? The Primary Key is used for the ID itself and is able to identify it in the database.

5. Why is the ID column such a useful field? The ID column is useful because it gives a indication what was inputted into the system first

6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ? To store the string “18 Segway Drive, Moonville” a text data type of would be used.

7. What Access data type would you use to record True/False values? The Yes/No data type.

8. What Access data type would you use to store a number? The number data type would be used since this can be inputted for further calculations such as a pricing of an item.

9. What Access data type would you use to store a long string such as an essay or report?

10. A database is a collection of what? A database is a collection of data that is stored in a structured format of columns and rows.

11. A table is made up of what?
A Table is a group of releated records that contain the same fields

12. What is a record? A record is a group of related field that contain all valuable information about an object or person.

13. Are spaces allowed in field names? You're welcome to put spaces in your field names but its not necessary

Activity 1: Create a database