Databases

Question 1

what is a database?

Answer 1

a structured set of related data that contains information on a topic.

Question 2

what is a table?

Answer 2

an entity; a collection of rows and columns that is used to store data.

Question 3

what is a field?

Answer 3

an attribute; a column in a table with a corresponding data type

Question 4

what are the 7 types of data

Answer 4

1. text
2. number
3. date
4. time
5. container
6. calculation
7. summary

Question 5

what are 6 examples of data validation?

Answer 5

1. value lists
2. ranges
3. required value
4. unique
5. verification of type
6. auto-entered

Question 6

what is a record?

Answer 6

a full set with a value for each field in the table; a row in a table

Question 7

what is a primary key?

Answer 7

a field that uniquely identifies each record

Question 8

what is a foreign key?

Answer 8

a non-unique field that links to a related table.

Question 9

what are 3 types of relationships and give an example of each one

Answer 9

one-to-many: one album has many songs
many-to-one: many letters can be sent to one address
many-to-many: many artists are on many albums

Question 10

what does a report do?

Answer 10

sorts or summarizes data

Question 11

what does a report display?

Answer 11

different sets of data in different ways

Question 12

what does a query do?

Answer 12

searches through the data to look at a specific part of it.

Question 13

what are 3 benefits to using a database over a spreadsheet?

Answer 13

1. databases show connections between different sets of data
2. databases can store large amounts of data
3. you don’t need to store things a bunch of times (i.e. Album data in the songs table)

Question 14

what are 4 questions you should ask when creating a database?

Answer 14

1. what things do I want to keep track of?
2. are these things all the same or are there distinct differences?
3. will data need to be repeated in order to have a complete database?
4. what are the types of information?