Chapter 9 - Database Systems
General Outcomes
- Recognize fundamental knowledge of the role, structure, and characteristics of database systems, e.g.,
- The rationale for collecting, processing, and analyzing data in various environments.
- Basic ideas of the relational models and alternatives to it.
- The kinds of files used to store data and important tradeoffs involved in designing and implementing the database for a particular purpose.
- Computers are used to analyze data for the purpose of discovering inferences that can be made from that data rather than to look of specific data (data mining).
- The capability of computer analysis to identify individuals without personally identifiable information, e.g., zip code and birthdate.
- Apply knowledge/understanding of database technology in examining security and societal issues, e.g.,
- Analyze actual or proposed uses of database technology legal, ethical/moral, information security, correctness, etc. issues taking into account the data and people involved.
- Analyze various issues to formulate responsibility and liability of various stakeholders, i.e., retail business, data brokers, purchasers of data, government, and users/consumers.
Reading Guide
In order to guide your reading we have designated each section into one of three categories:
- Essential - You should thoroughly read this material and be prepared to answer questions about this material in both discussions and on assessments.
- Important - You should read this material and be prepared to participate in potential discussions/activities about this material. While this material will not be directly assessed, your understanding of this may help you support/improve your answers to "Essential" material.
- Useful - We feel that this material is worth knowing and may supplement other material in the chapter. However, we do not plan on assessing or discussing (unless you ask questions).
Section | Essential | Important | Useful |
---|---|---|---|
9.1 Database Fundamentals | |||
9.2 The Relational Model | |||
9.3 Object-Oriented Databases | |||
9.4 Maintaining Database Integrity | |||
9.5 Traditional File Structures | |||
9.6 Data Mining | |||
9.7 Social Impact of Database Technology |
Video Resources