CISP 547 - Database Design

3 Credits
This course will examine the major types or data models of Database Management Systems (DBMS): hierarchical, network, relational, and object-oriented. The principles and problems of database design, operation, and maintenance for data models will be discussed and compared. Topics that will be covered include design theory, query language, relational expressions, SQL, stored procedures, client-server interfaces, entity relationship diagrams, normalization, and database security.

Course Learning Outcomes:
1. Design a database for scalability, performance, and security, incorporating indexing strategies to support complex business applications.
2. Create SQL queries for business needs.
3. Implement entity-relationship models for databases.
4. Compare the characteristics of different types of data design.
5. Apply various modeling, normalization, and design techniques.
6. Explain the data structures, including security related to business needs.