Data Storage

Question 1

What is a Field in a database?

Answer 1

Field – the type of information that is needed in the record (e.g. name, address)
For example, our school gives out merits to students who have worked well.
To produce a merits database, you would include fields such as Student Name, Tutor Group, Subject, Date, Reason for Merit, Teacher, etc.

Question 2

What are the data types in a database?

Answer 2

Text, Number, Currency, Date/Time

Question 3

What is a Data type?

Answer 3

Data type – the type of data a field must hold (e.g. date of birth, date)
. E.G data type for your name would be “text”, data type for date of birth would be “date/time”

Question 4

What are relationships used for in a database?

Answer 4

Relationship – the connection between two or more tables. Once the tables have been set up, a relationship can be created to link them together

Question 5

What is a Online Database?

Answer 5

An online database is a database accessible from a network, including from the Internet

Question 6

What is a Database Management Systems (DBMS)?

Answer 6

A DBMS is an application designed to control all aspects of a database.
Allows different users to access the database at the same time.

Question 7

What is a Record?

Answer 7

Record – an item stored with relevant information (e.g. every single detail about a member)