Relational Database Design Into
Terms
undefined, object
copy deck
- 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