Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/15

Click to flip

15 Cards in this Set

  • Front
  • Back
What is a database?
an organized collection of data used for the purpose of modeling some type of organization or organizational process
What are two types of databases?
operational databases & analytical databases
What is meant by an operational database?
operational databases are collect, modify, and maintain data on a daily basis - ie a retail operation, or a bank operation
What is meant by an analytical database?
Analytic databases store static data - they track historical and time dependent data - the info gleaned from an analytic database reflects a point-in-time snapshot of the data
What type of database model preceded the relational database?
the hierarchical and the network
How is a the hierarchical model diagrammed
usu as an inverted tree, a single table is the root and other tables act as branches flowing from the root
what is the relationship between tables in the hierarchical model called
parent/child
what are advantages to the hierarchical model
data access is quick because there are explicit links between the tables; secondly, referential integrity is built in
what are problems to the hierarchical model?
a child record cannot be inserted without a parent table; complex, many-to-many data cannot be modeled without redundancy
How is the structure of a network database modeled
nodes & set structures
What is a node?
a node, in the network database model, is a collection of records
what is a set structure?
in the network database model, establishes and represents a relationship - one node is an owner, the other node is a member
what did the network database model do - in relation to hierarchical models
data could be traversed from any side of a relationship in the network data model, there could also be many to many relationships
Origins of the relational database model?
conceived in 1969 by Dr.Edgar F.Codd, IBM research scientist, looking into ways to better handle large amts of data -
What does the name relational database stem from?
Set Theory