1.1 Overview

  • Database Design: How can a user descirbe a real-world enterprise in terms of the data stored in a DBMS? What factors must be considered in deciding how to organize the stored data?
  • Data Analysis: How can a user answer questions about the enterprise by posing queries over the data in the DBMS?
  • Concurrency and Robustness: How does a DBMS allow many users to access data concurrently, and how does it protect the data in the event of system failures?
  • Efficiency and Scalability: How does a DBMS store large datasets and answer questions against this data efficiently?