Introduction to Database Management Systems
|
EECS-3421
|
Syllabus
|
Semester:
|
Fall 2018
|
Course/Sect#:
|
EECS-3421
|
Time:
|
Monday 7:00PM
|
Location:
|
|
|
Instructor:
|
Jarek Gryz
|
Office:
|
2049 Lassonde Bldg.
|
Office Hours:
|
TR 4-5PM
and by appointment
|
Ph#:
|
416-736-2100 x70150
|
e-mail:
|
jarek@cs.yorku.ca
|
|
T.A.:
|
Wenxiao Fu
|
Office:
|
Lassonde 2053
|
Office Hours:
|
TBA
|
Project:
|
1A and 2
|
e-mail:
|
vanessafoo.foo@gmail.com
|
|
|
T.A.:
|
Nasim Razavi
|
Office:
|
Lassonde 2053
|
Office Hours:
|
TBA
|
Project:
|
1B and 3
|
e-mail:
|
nasim@eecs.yorku.ca
|
|
|
Announcements
- Grades for the final exam are on ePost.
- Marks on ePost are not updated after remarking.
- Grades for Project 3 (out of 15 points) are on
ePost.
The TA, Nasim Razavi, will have office hours on Wednesday and Thursday, Dec 19 and 20,
11:00am to 12:00pm if you want to discuss the grading.
- Sections of the textbook to be covered on the final exam:
1, 2, 3.1-3.5, 4.1-4.6, 5.1, 6, 7, 10.1, 18.1-18.4, 19.1-19.2.
You are also responsible for the material covered in class and on slides.
- My office hours on Thursday, Dec 6 are cancelled. Instead, I will
have office hours on Friday, Dec 7 at 12-1:30PM.
- Grades for Project 2 (out of 10 points) are on
ePost.
The TA, Wenxiao Fu, will have office hours at 6:00PM on Monday, Dec 3 and 13:00-14:00PM Wednesday, Dec 5.
- The deadline for project 3 has been extended to 11:59PM on Dec 5.
- Project 3 has been posted.
Questions related to the project should be directed to the TA, Nasim Razavi.
Her office hours are: Thursday Nov 22 2pm-3pm,
Wednesday Nov 28 2pm-3pm,
Thursday Nov 29 2pm-3pm,
Tuesday Dec 4th, 4:00pm-5:00pm
- Material from the textbook covered so far: 1, 2, 3.1-3.5, 4.1-4.6, 5.1, 6, 7
- Grades (out of 12 points) for Project 1 part B are on
ePost.
The TA, Nasim Razavi, will have office hours on Wed, Nov 7 and 14, 2-3PM in 2053.
- Project 2 has been posted.
Questions related to the project should be directed to the TA, Wenxiao Fu.
Her office hours are 6:00-7:00PM November 5th (next Monday) and at 4:00-5:00PM November 15th (the following Thursday).
- Grades (out of 20 points) for the midterm exam are on
ePost.
I will discuss the midterm in class.
- Material from the textbook to be covered on the midterm:
1, 2, 3.1-3.5, 4.1-4.6, 5.1.
You can find previous tests on Prof. Godfrey's page (we have often joint exams),
for example here.
- Deadline for Project 1B has been extended to Oct 16.
Solution and
More solutions.
- Grades (out of 8 points) for Project 1 part A are on
ePost.
The TA will have office hours on Oct 22, 6-7PM in 2053, to answer any questions related to the project.
- Project 1B is due on Oct 15.
Note, that there was a missing comma between 'role' and 'actor' in the Cast table; fixed now.
- Project 1 has been posted.
Submit Part 1 only by Sep 27.
(I have looked again at the description of the ZOO
and there is nothing I need to add to it).
Solution.
Course Materials (to accumulate over the semester)
- Slides
- Sections of the textbook to be covered in class (subject to change): 1, 2, 3.1-3.5, 4.1-4.6, 6, 7, 8, 10.1, 10.6-7, 18.1-18.4, 19.1-19.2.
The Course
Description (from the academic calendar)
The
purpose of this course is to introduce the fundamental concepts
of database management,
including aspects of data models, database languages, and database design.
At the end of this course, a student will be able to understand and apply
the fundamental concepts required for the use and design
of database management systems.
Course Objectives
Students
will become proficient at modeling databases at a conceptual and
physical level of design.
Students will be able to develop database schemas that enforce data integrity.
Students will also become knowledgeable in the creation, altering,
and manipulation of tables, indexes,
and views using relational algebra and SQL.
Specific topics to be covered include:
- Relational Model
- Conceptual Design and the ER Model
- Normalization
- Relational Algebra
- SQL Query Language
- Transaction Management, Concurrency Control, and Recovery
Learning Outcomes for the course:
After successful completion of the course, students are expected to be able to:
- Model databases proficiently at conceptual and logical levels of design. Use
entity relationships (ER) models and ER diagrams with extension.
- Develop relational database schemas which respect and enforce data integrity
represented in ER models.
- Implement a relational database schema using structured query language
(SQL): create and manipulate tables, indexes, and views
- Create and use complex queries in SQL
- Write database application programs with an understanding of transaction
management, concurrency control, and crash recovery.
Books / Reading
Required Textbook / Reading
- Database Systems: The Complete Book
- H. Garcia-Molina, J.D. Ullman, & J. Widom
- 2nd edition, 2009
- Pearson / Prentice Hall
- ISBN: 0-13-187325-3
Useful Books / Reading
The textbook we use for many exercises done in class:
- Database Management Systems.
- Third Edition, 2003.
- Raghu Ramakrishnan and Johannes Gehrke
- WCB/McGraw Hill.
- ISBN: 0-07-232206-3
- URL:
http://highered.mcgraw-hill.com/sites/0072465638/student_view0/
Other books:
- Understanding the New SQL: A Complete Guide
- First Edition, 1993.
- Jim Melton and Alan R. Simon.
- Morgan Kaufmann Publishers.
- ISBN: 1-55860-245-3
- Using the New DB2:
IBM's Object-Relational Database System
- First Edition, 1996.
- Don Chamberlin
- Morgan Kaufmann Publishers.
- ISBN: 1-55860-373-5
Grading Criteria / Course Requirements
|
Percentage
|
When
|
Midterm
|
30%
|
Oct 29
|
Final Exam
|
40%
|
TBA
|
Project
|
30%
|
TBA
|
The grading policy is a standard one.
The instructor will grade the exams.
The TA will grade the projects.
York University's rules for academic honesty
and plagiarism always remain in effect.
Discussion is fine on the projects.
However, collaboration is not.
The work must be your own.
Exams, of course, must be done on your own.
If you miss a test for good reason
(e.g., illness with a medical document),
your Final Exam grade will count for both the final exam and the missed test.
Course Policies
Policy on e-mail from students on course materials, and questions
- I will not answer these e-mails in general.
My time is spent more productively for the class's
sake in different ways.
For pertinent questions on the materials that students send me by
e-mail, or for questions that many people seem to be having, I will
try to address them in class.
- If you have a burning question I have not addressed, come see me
during my office hours, or make an appointment if you need to.
Many students do this already, and it is a good use of my time and
theirs.
I can usually answer a question a student asks in person
in about a tenth the time than by an e-mail exchange.
This is because writing it out takes much longer.
Also, 80% of the questions people send me,
I have no idea what they are asking.
We would have to go back and forth by e-mail
several times before I get to the bottom of it.
- For personal requests, such as "I cannot make the test",
and so forth, e-mail is fine and I will attempt to answer you directly.
However, I will NEVER answer emails sent from non-York accounts.
I will NEVER answer emails which are not signed.
So I do not mind students sending questions by e-mail.
By all means, continue.
Just do not necessarily expect a direct reply.
I do read them,
and mostly I try to address the issues and questions people have raised.
If your question or issue remains after some time,
let me know.
For anyone who believes that I am purposely ignoring them,
my apologies.
Policy on project/test regrading or reappraisal
You have two weeks to request a project or test reappraisal.
This is a strict deadline.
The projects and the tests are marked by a TA.
I have a fixed TA office hours budget and cannot ask them to work for free
overtime.
If you miss the two week deadline, your only option would be to submit a
petition to the department after the end of the course.
Useful On-line Information