Introduction to Database Management Systems
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.
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:
This corresponds to the following chapters from the textbook: 1, 2, 3, 4, 5, 6, 7, 17, 18 and possibly 5 and 10.
Learning Outcomes for the course:After successful completion of the course, students are expected to be able to:
Required Textbook / Reading
Useful Books / Reading
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.
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.
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.
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.