Name the two main types of databases in use today.  2. What type of data does an analytical database store?  3. True or False:  An operational database is used primarily in online transaction processing (OLTP) scenarios.

Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 5SAT
icon
Related questions
Question

1. Name the two main types of databases in use today. 
2. What type of data does an analytical database store? 
3. True or False: 
An operational database is used primarily in online transaction processing (OLTP) scenarios.
4. What two data models were commonly used in the days before the relational database
model? 
5. Describe a parent/child relationship. 
6. What is a set structure? 
7. Name one of the branches of mathematics on which the relational model is based. 
8. How does a relational database store data? 
9. Name the three types of relationships in a relational database. 
10. How do you retrieve data in a relational database? 
11. State two advantages of a relational database. 
12. What is a relational database management system? 
13. What is the premise behind the object-relational model? 
14. What is the purpose of a data warehouse?

15. What is data Normalization

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Fundamentals of Distributed DBMS
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning