Database Systems Test CMPE 180B

Time and Location:
Friday 08/23/2019 in E189 starting at 3:00 p.m.  Please allow 60-90 minutes for the exam

Note: Be sure to arrive early, if you are late for any reason, you will not be allowed to take the test.

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.