Database Principles and Applications

Database Principles and Applications
Database theory and architecture; data modeling; designing application databases. Query languages, data security, database applications on the Web..
 Hours3.0 Credit, 2.0 Lecture, 3.0 Lab
 PrerequisitesC S 236 & IT 210B
 ProgramsContaining IT 350
Course Outcomes

Concepts and Terminology of Information Management

Define and apply the concepts and terminology of Information Management.

Conceptual and Data Modeling

Apply conceptual modeling concepts using standard techniques such as Entity Relationship and Universal Modeling Language diagrams and tools.

Use manual and automated techniques for mapping from conceptual to data models (e.g . ER to Relational).

Systems and Administration

Compare and contrast instalation, management, modeling and security features of current database managment systems

Application Development

Use conceptual and data models to design and implement distributed database access applications applying current languages, system technologies and tools.

Database Systems Integration and Test

Integrate, deploy, and demonstrate operational applications on database system infrastructure. Includes use of DDL, DML, programming interfaces and UI implementation.