CSCI-C 442 Database Systems
- Prerequisites: None
- Delivery: On-Campus
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.
- Describe the role of data modeling in the development life cycle of the entire system.
- Model data using the relational database approach.
- Draw E-R diagrams with common constructs to represent a business situation.
- Transform E-R diagrams to a logically equivalent set of relations.
- Use normalization to eliminate anomalies and create well-structured relations.
- Perform physical database design in choosing storage formats, file organization, and indexes.
- Implement a database from a given design using the SQL data definition language.
- Describe the data quality and integration process’s purpose, importance, and characteristics.
- Describe issues related to security, recovery, availability, and tuning of databases.
There is not a syllabus available for this course.