Database Systems Test CMPE 180B

Time and Location:
Fall 2020 TBD

Note: Be sure to arrive early, if you are late for any reason, you will not be allowed to take the test. As exam day and time can be subject to change, check this webpage often for possible updates

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.