what is a database?
a structured set of related data that contains information on a topic.
what is a table?
an entity; a collection of rows and columns that is used to store data.
what is a field?
an attribute; a column in a table with a corresponding data type
what are the 7 types of data
- text
- number
- date
- time
- container
- calculation
- summary
what are 6 examples of data validation?
- value lists
- ranges
- required value
- unique
- verification of type
- auto-entered
what is a record?
a full set with a value for each field in the table; a row in a table
what is a primary key?
a field that uniquely identifies each record
what is a foreign key?
a non-unique field that links to a related table.
what are 3 types of relationships and give an example of each one
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
what does a report do?
sorts or summarizes data
what does a report display?
different sets of data in different ways
what does a query do?
searches through the data to look at a specific part of it.
what are 3 benefits to using a database over a spreadsheet?
- databases show connections between different sets of data
- databases can store large amounts of data
- you don’t need to store things a bunch of times (i.e. Album data in the songs table)
what are 4 questions you should ask when creating a database?
- what things do I want to keep track of?
- are these things all the same or are there distinct differences?
- will data need to be repeated in order to have a complete database?
- what are the types of information?
