CS 342 Database Development

This course introduces students to the essentials of database development and construction. Throughout the course students will use a database management system to create tables, joins, queries, forms, reports, macros and switchboards. In addition, by exploring the concepts of normalization and entity relationship diagrams, students will learn how to create a structurally sound database that minimizes data redundancy.

Credits

3

Offered

Fall, Spring B

Outcomes

1. Apply theoretical knowledge to develop database applications using DBMS and SQL language
2. Effectively use the Entity Relationship diagram for the representation of conceptual schemas
3. Identify functional dependencies and apply normalization algorithms
4. Use Data Definition Language to define database schemas
5. Construct data retrieval procedures using the Data Manipulation Language
6. Develop data retrieval procedures using Relational Algebra
7. Understand the mapping process of the ER and EER Models to the Relational Model