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&C 210B
 ProgramsContaining IT&C 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).

Application Development

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

Systems and Administration

Compare and contrast installation, management, modeling and security features of current database management systems.

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.