IU

IUPUI IUPUI IUPUI

Luddy School of Informatics, Computing, and Engineering Menu

Same school, new name. The School of Informatics and Computing is changing its name effective January 11, 2023. Learn more about the name change

CSCI-C 442 Database Systems

3 credits

  • 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.

    Learning Outcomes

    1. Describe the role of data modeling in the development life cycle of the entire system.
    2. Model data using the relational database approach.
    3. Draw E-R diagrams with common constructs to represent a business situation.
    4. Transform E-R diagrams to a logically equivalent set of relations.
    5. Use normalization to eliminate anomalies and create well-structured relations.
    6. Perform physical database design in choosing storage formats, file organization, and indexes.
    7. Implement a database from a given design using the SQL data definition language.
    8. Describe the data quality and integration process’s purpose, importance, and characteristics.
    9. Describe issues related to security, recovery, availability, and tuning of databases.

     

    Syllabi

    There is not a syllabus available for this course.