Database Flashcards
name two main types of database in use today
OPerational and analytical databases
What are operational databases
Databases that need to collect, modify, maintain data on daily basis
What are analytical databases
Need to store and track historical and time-dependent data
What type of data does an analytical database store
Static data that never rarely changes
What two data models used in the beginning of database management
hierarchical and network
Describe a parent/child relationship
A parent can be associated with more than one child table, a child table can only be associated with one parent table
What is a set structure
Establishes relationships in network database models.
What two math theories do relational model is based
Set theory and first order predicate logic
How do relational db store data
Stored as relations. WHich user perceives as tables. Each relation composed of tuples, records, attributes, or fields
Three types of relations
one to one
one to many
many to many
how to retrieve data in relational
Use SQL (structured query langauge)
State two advantages of a relational database
Built in multilevel integrity
logical and physical data independence from database app
Guaranteed data consistency and accuracy
easy data retrieval
