CIS 162 - Database Design and Development

1. Describe the role of data as a corporate resource, the reasons for using a database, and the relational model for databases
2. Demonstrate using SQL statements for creating, querying, modifying and deleting data from a relational database
3. Explain the purpose of database administration and the need for security, backup and recovery
4. Demonstrate database programming fundamentals by developing an application program interface (API) to access and maintain a relational database
5. Describe the concepts of data warehousing, data mining, and data analytics.

1. Overview of databases and database products
2. The Relational Database Model
   1. Keys
   2. Functional dependencies
   3. Multi-value dependencies
   4. Normal forms
   5. The normalization process
3. Entity Relationship (E-R) Modeling
4. Database Design
   1. Transforming a model into a design
   2. Relationships between various types of entities
   3. Column properties
   4. Enforcing referential integrity
5. Database Management – Selected Topics
   1. Atomic transactions
   2. Concurrency
   3. Lost updates
   4. Resource locking
   5. Transaction isolation