Database Management Systems (CMPE354)

This course introduces the student to the fundamentals of database management. Topics covered include: the Entity-Relationship model; the Relational model and its mathematical foundations; most important features of Structured Query Language (including basic structure, aggregate functions, nested queries, index definition, stored procedures and functions, views, database modification, domain constraints, assertions, triggers, transaction definition, data definition language, granting privileges, security), query languages Datalog and QBE; Object-Oriented and Object-Relational databases; design principles of Relational databases (normal forms, functional dependencies, decomposition).

Related Programs

• Software Engineering Undergraduate Program
• Computer Engineering Undergraduate Program
• Computer Engineering Master's Program (with Thesis)
• Computer Engineering Doctoral Program
• Software Engineering - Computer Engineering Double Major Program
• Computer Engineering - Software Engineering Double Major Program
• Computer Engineering - Information System Engineering Double Major Program
• Software Engineering Master's Program (with Thesis)