Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
17 Cards in this Set
- Front
- Back
|
What is a Database administrator?
|
Gatekeeper of an organization
|
|
|
What does a Database administrator do?
|
Database Security and database maintenance
|
|
|
What does a systems analysis do?
|
Reviews, evaluates, designs, implements and maintains companies databases
|
|
|
What is a database?
|
A collection of interrelated data items stored together without unnecessary redundancy, to serve one or more applications.
|
|
|
Main uses for databases?
|
OLTP (online transactional processing) and OLAP (online analytical processing)
|
|
|
What is OLTP processing?
|
Day to day transactions eg. Bank deposits
|
|
|
What is OLAP processing
|
historical data stored, used mainly for decision making, queries won't slow down performance on OLTP systems
|
|
|
What is a database model?
|
a specification describing how a database is structured and used
|
|
|
What is the aim of a database model?
|
to support the development of an information system by providing the definition and format of the data
|
|
|
Types of database models?
|
Flat file, Hierarchical, Network, Relational, Object oriented
|
|
|
What is the flat file Database model?
|
Each file isn't directly related to each other, earliest forms of database
|
|
|
How is a flat file database used today?
|
log files
|
|
|
What is the hierarchical database model
|
Allows one to one or one to many relationships between entity's, only uni-directional
|
|
|
why was the Hierarchical database model created
|
to avoid the administrative difficulties of updating data in multiple flat file databases
|
|
|
What are the advantages of a Hierarchical database
|
the design is simple, fast
|
|
|
What are the disadvantages of a Hierarchical database
|
Useful where requirements are not expected to change, need to have programing skills, lots of data redundancy, no direct access to data, not suitable for adhoc queries
|
|
|
What is a network database model?
|
|
