|
Database Management Systems EECS-4411 York University Winter 2016 |
|
|
|
||||||||||||||||||||||||||||
| Class URL: http://www.cs.yorku.ca/~jarek/courses/4411/W16 | ||||||||||||||||||||||||||||||
HW1 (10 points): Due Jan 28 at noon in drop-off box: 8.4 (5,6,10,11,12), 8.8 (a case when no record qualifies), 9.6, 9.8, 9.16, 10.2 (1-5), 10.6, 11.2 (6-7), 11.6, 13.4 (b,d,e) (homework complete) Solutions
HW2 (8 points): Due March 10 at noon in drop-off box: 14.6 (there is a typo in 14.6: where it says "in Exercise 14.1" should say "Exercise 14.4"), 15.2 (c,d,g,h for points 1,2,3,4), 15.4 (2,3) , 22.6 (4,6) (homework complete)
Solutions (note that the numbering of the exercises here is different than in the current textbook).
HW3 (6 points): Due Apr 7 at 2PM in drop-off box:
We will cover (at least) chapters: 8, 9, 10, 11, 12, 13, 14, 15, 22, 25, 26 from the textbook.
Lecture slides can be found here. (Note, they are only accessible from York CS machines).
|
This course is the second course in database management. It introduces concepts, approaches, and techniques required for the design and implementation of database management systems. |
|
In this course, we go "under the hood" to learn how a relational database management system is built. Students will learn the issues involved in designing efficient database systems, and the strategies, data-structures, and algorithms used in the implementation of such systems. Additionally, we shall also explore some advanced topics in databases. The course is designed in three parts: the physical database, query processing, and advanced topics. Specific contents include the following.
|
|
The grading policy is standard. Collaboration and discussion on the assignments is fine. Note however, that unless you work through the exercises yourself, you will not get much benefit from them.
York University's rules for academic honesty and plagiarism always remain in effect.
There will be 3 assignment sets through the semester. You will get a check-mark for turning in each assignment. The assignments, however, will not be graded. It is important to put effort into the assignments, however, for understanding of the materials, and because similar problems will appear on the exams. Solutions to assignment sets will be made available after the turn-in dates for study purposes.
All written work for the assignments need not be typed; but if you hand-write them, you must write legibly for credit. Late assignment sets will be accepted with 50% credit reduction for each day overdue.
The project description is here. Please keep visiting this page as we may add new information there.
Exams must be taken when scheduled. If a student misses a test and has a medical documentation or can demonstrate special circumstances, credit for that test will be moved to the final exam (for example, after missing one test his/her final exam will count for 60% of the total grade).
Class attendance is important as the student will have an opportunity to ask for clarification of course and text material. There will be problem solving sessions during each class period so that students gain experience applying the theory in practice.
Plagiarism is defined as taking the language, ideas, or thoughts of another, and representing them as your own. If you use someone else's ideas, cite them. If you use someone else's words, clearly mark them as a quotation. Note that plagiarism includes using another's computer programs or pieces of a program. All instances of plagiarism will be reported.
These policies are not intended to keep students from working with other students. One can learn much working with other, so this is to be encouraged. Should you encounter any situations for which you are uncertain whether such collaboration is permitted or not, please ask.