Introduction to Database Management Systems

Identifier
COMS 3630
Professor(s)

Last Updated: Spring 2025

Offered during Fall and Spring Semesters each year. 

  1. Credits and contact hours: 3 credits
  2. Text book, title, author, and year: None required
  3. Other supplemental materials: Database Management Systems, 3rd edition, R. Ramakrishnan and J. Gehrk

Specific course information

  1. Brief description of the content of the course: Relational, object-oriented, semistructured and query languages. SQL, XML, and NO-SQL. Database design using entity-relationship model, data dependencies, and relational database design. Application development in SQL-like languages and general-purpose host languages with application program interfaces and a commonly used Object Relational Mapping framework. Web application development. Programming Projects.
  2. Prerequisites or co-requisites: Minimum of C- in COM S 2280 and MATH 1650; ENGL 2500
  3. Required, elective, or selected elective? Selected Elective

Specific goals for the course

  1. Specific outcomes of instruction:
    1. Design and implement database applications using commercial DBMS
    2. Understand the implementation of a typical DBMS

Brief list of topics to be covered

  • Design and implementation of database applications
    • ER-model
    • Relational data model and mpaing from ER to relations
    • Implementation of a database system design
    • Relational algebra
    • MySQL, Neo4J, and MongoDB
  • Internal of database management systems
    • Storage management
    • Implementation and cost estimation of basic operators
    • Query optimization
    • Transaction management