CSCI-C 442 Database Systems
3 credits
- Prerequisite(s): CSCI-C 310 or CSCI-C 343 or CSCI 36200
- Delivery: On-Campus, Online
- Semesters offered: Fall, Spring, Summer (Check the schedule to confirm.)
- Equivalent(s): CSCI 44300 Database Systems
Description
Study of fundamental concepts, theory and practices in design and implementation of database management systems. Topics include data independence, data modeling, ER modeling, functional dependencies, normalization, relational, hierarchical, network and object oriented data models, relational algebra, relational calculus, data definition and manipulation languages, recovery, concurrency, security, and integrity of data.
Learning Outcomes
- Design and implement relational databases to model, store, and manage data using tables, keys, relationships, and SQL commands, considering both user and operational needs. CS 4
- Diagram a relational database design to represent a business situation using entity–relationship diagrams (ERDs) and crow’s foot notation to enforce referential integrity, and transform ERDs to a logically equivalent set of relations. CS 4
- Evaluate tables for compliance with third normal form and perform normalization procedures on noncompliant tables, using normalization to eliminate anomalies and create well-structured relations; select storage formats, file organization, and indexes. CS 4
- Formulate queries in relational algebra using selection, projection, restriction, Cartesian product, join, and set operators; write triggers to handle events and enforce business rules; create views within a relational database. CS 4
- Evaluate the data lifecycle, including curation, stewardship, preservation, availability, recovery, tuning, and security issues; apply and evaluate methodologies employed in the data quality and integration process. CS 4
- Evaluate the social and ethical implications of data management. CS 6
Policies and Procedures
Please be aware of the following linked policies and procedures. Note that in individual courses instructors will have stipulations specific to their course.