Introduction to Databases INF 282
Core concepts for the design, creation, and manipulation of relational databases. Analysis of data requirements, conceptual modeling, definition of the relational model, relational database design and normalization, and database implementation; manipulation of relational databases using relational algebra with SQL.
Correlated Learning Outcomes
- IM-01 Contrast the difference between information and data. [Analyzing]
- IM-02 Describe the advantages and disadvantages of central organizational control over data. [Understanding]
- IM-04 Describe proven techniques to secure data and information. [Understanding]
- IM-05 Describe approaches to scale up information systems. [Understanding]
- IM-06 Explain the characteristics that distinguish the database approach from the approach of programming with data files. [Understanding]
- IM-07 Diagram the components of a database system and give examples of their use. [Applying]
- IM-08 Explain the concept of data independence and its importance in a database system. [Understanding]
- IM-09 Formulate queries in SQL or a similar query language to elicit information from a database. [Creating]
- IM-11 Contrast appropriate data models, including internal structures for different data types. [Analyzing]
- IM-12 Diagram a relational data model for a given scenario that addresses security and privacy concerns. [Applying]
- IM-13 Describe the differences among relational data models and other models. [Understanding]
- SP-11 Discuss the rationale for legal protection of intellectual property. [Understanding]
- SP-12 Outline the need for legal protection of personal privacy. [Analyzing]
- SP-13 Investigate threats to privacy rights in personally identifiable information (PII). [Applying]
- SP-15 Analyze technological solutions to privacy concerns. [Analyzing]
- SP-16 Use effective oral, written, electronic, and visual communication techniques with stakeholders. [Applying]
- SP-18 Develop technical artifacts. [Creating]