Home | Syllabus
| Schedule | Homework,
Projects, & Handouts | Announcements
For exam, we will cover chapters 1-8 base on 5th edition of the
textbook in addition to the slides on web site relate to that.
It includes:
Database and Database users
Database system concepts and architecture
Data Modeling using the ER model
Enhanced EER model
Relational data Model and Relational database
Constraints
Relation Algebra and Calculus
Relational Database Design by ER mapping
and SQL, schema definition, constraints ( Simple SQL queries)
To prepare for exams, please read the examples
from book, read the words in bold ( for example meta-data is bold in chapter 1)
logical DESIGN AND PHYSICAL DESIGN are BOLD IN
CHAPTER 1
Please go over the review questions/some simple
exercises at end of chapter.
Questions in Exam will be made from material
taught and discussed in class. Some questions will be based on homeworks
I will bring a sample set of questions in class on
Tuesday (22th Sept) and again on Thursday (24th Sept), 2015
For example, I may give you an English query and
ask you to give an relational algebra expression and SQL query to execute the
English query. I may give you a relational algebra query and ask you an
equivalent relational calculus query.
There will be small question with weight of 1/2
or 1 point. So there will be about 7 questions with multiple parts.