Database Systems Test CMPE 180B

Time and Location:
Thursday 01/31/2019 @ 4:30 pm in E278

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
  • Relational data Model, constraint, retrieval queries, triggers, and views
  • Relational algebra, Entity-Relationship (ER) Model, and database design
  • Normalization, and functional dependencies
  • Indexing, hashing, transaction, and concurrency control

Reference Textbooks
  • R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 6th edition, Addison-Wesley, 2011
  • G. Powell, Beginning Database Design, Wiley Publishing, 2006
For test rules please click here.