Databases

Question 1

5 database datatypes

Answer 1

Number: Used for both integers and real numbers
Text: Used for both strings and chars
Date/Time: Used for the date and/or time
Boolean: Yes/No or True/False
Currency: Used for money

Question 2

field

Answer 2

One piece of information about an object

column

Question 3

record

Answer 3

A collection of fields about the same object

row

Question 4

table

Answer 4

collection of records about the same entity

Question 5

primary key

Answer 5

field that uniquely identifies each record

Question 6

database

Answer 6

persistent and structured collection of data