CS 5620 - Database Systems

• Students will develop the ability to design and implement a database based on models.
• Students will develop the ability to draw an entity-relationship diagram to model an enterprise.
• Students will develop the ability to embed SQL in a host programming language to implement transactions against a database.
• Students will develop the ability to express a database query as a relational algebra expression.
• Students will develop the ability to interactively code a database query in SQL.
• Students will develop the ability to interpret information presented on an entity-relationship diagram.
• Students will develop the ability to normalize a database into third normal form or Boyce-Codd normal form.
• Students will develop the ability to represent database constraints as functional dependencies.
• Students will gain an appreciation of the limitations of current database technology.
• Students will gain an understanding of database system components and how they fit together.
• Students will gain an understanding of relational database algorithms for normalizing databases, preserving dependencies, and ensuring the lossless join property.
• Students will gain an understanding of the basic operations of relational algebra.
• Students will gain knowledge of basic database vocabulary and concepts.
• Students will gain knowledge of current research efforts underway to expand current database capabilities.
• Students will gain knowledge of why and when databases are used.