Problem 1: Spreadsheets have become quite powerful for data management. What can be done with database management systems that cannot be done with spreadsheet applications? Give several examples.
Problem 2: DBMSs are usually bundled with powerful programming language modules. Why?
Problem 3: What are the advantages and disadvantages of object-oriented databases?
Problem 4: When constructing a database, the designer must know what types of relationships exist between records in different data sets, such as one-to-many or many-to-many. Give three examples for each of these relationships.
Problem 5: What is SQL? In which database model does it operate? Why is it so popular?
Problem 6: Why is it not advisable to query data from transactional databases for executive decision making the same way you do data warehouses?
Problem 7: What does it mean to cleanse data before it is stored in a data warehouse?