CS340: Introduction to Database Systems

Describe basic database concepts, architecture, and DBMS principles. Demonstrate knowledge of emerging topics in databases

Develop conceptual modeling concepts and notations using Entity-Relationship or UML diagrams to analyze and design complex database applications

Create a logical database design based on the conceptual ER model

Apply normalization forms (1st, 2nd, 3rd, BCNF forms) and functional dependencies to optimize relational models

Create a relational database schema that incorporates key, entity integrity, and referential integrity constraints and use declarative query languages (Relational Algebra and SQL) to elicit information from a database