Database Systems Test CMPE 180B

Time and Location:
Aug. 17th, 2021 @ 7:00 pm (online)

Test Scope 

  • Database system concepts and architecture 
  • Entity-Relationship (ER) Model, relational data model, and constraints
  • SQL queries, schema modification, views, and triggers 
  • Relational algebra, and ER-to-Relational mapping 
  • Normalization, and functional dependencies 
  • Transaction, concurrency control, and recovery

Reference Textbooks 

R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7th edition, Pearson, 2015
For test rules please click here.