Course Catalog URL
Identifier
COMS 3630
Professor(s)
Last Updated: Spring 2025
Offered during Fall and Spring Semesters each year.
- Credits and contact hours: 3 credits
- Text book, title, author, and year: None required
- Other supplemental materials: Database Management Systems, 3rd edition, R. Ramakrishnan and J. Gehrk
Specific course information
- 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.
- Prerequisites or co-requisites: Minimum of C- in COM S 2280 and MATH 1650; ENGL 2500
- Required, elective, or selected elective? Selected Elective
Specific goals for the course
- Specific outcomes of instruction:
- Design and implement database applications using commercial DBMS
- 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