Course Description
A practical introduction to databases and Web app development. Databases: terminology and applications; creating, querying and updating databases; the entity-relationship model for database design. Web documents and applications: static and interactive documents; Web servers and dynamic server-generated content; Web application development and interface with databases.
Required Background
Some experience with programming in an imperative language such as Python, Java or C. This course may not be taken after - or concurrently with - any C- or D-level CSC course.
Course Information & Schedule
- Instructor: A. Attarwala
- Lecture: Mondays 9am - 11am in SW319
- Email: Abbas.Attarwala@utoronto.ca
Rough Semester Plan
Please check on Blackboard for the actual weekly schedule. Changes to the schedule will be announced in class as well. The main topics that we will cover in this course are:
- Databases: Terminology and applications, creating, querying and updating databases, and the E-R model for database design
- Web Applications: Static and interactive documents, web servers and dynamic server-generated content; web application development, and integration with databases.
Grading Scheme
Assignments
There are three assignments. You may be asked to work in pairs in some of these assignments. Please check the assignment handout for these details for the exact due date and whether you can work in groups or not. DO NOT EMAIL YOUR ASSIGNMENTS TO US. We will use MARKUS for the submission of all assignments. ALL ASSIGNMENTS WILL MARKED ON UTSC LAB MACHINES. IT IS IMPORTANT BEFORE SUBMITTING YOUR ASSIGNMENT, TO MAKE SURE THAT IT COMPILES AND EXECUTES ON THE UTSC LAB MACHINES. A STRICT silent policy takes effect 12 hours before an ASSIGNMENT or EXAM is due. This means no question about the assignment will be answered by instructor or the TA whether it is asked on the bulletin board, by email or in person.
Textbook & Lecture Notes
- There is no required textbook, however, mandatory readings will be assigned using various web pages from the internet.
- Lecture notes will be available on Blackboard. You are EXPECTED to read the assigned readings before coming to lecture.
Re-marks
If a piece of work has been mis-marked or if you believe the rubric used to evaluate the work is not appropriate, you may request a re-mark. For a re-mark to succeed, you must clearly and concisely express what you believe was mis-marked or unfairly marked. To request a re-mark, set up an appointment with the instructor and the TA that has marked your assignment/exam. PLEASE DO NOT USE THE DISCUSSION BOARD REQUESTING FOR REMARKS. Be prepared for the entire work to be re-evaluated and for the mark to be adjusted up or down after the re-evaluation. Remark request MUST be made in 5 regular days time after the mark is made available. No remark request will be accepted after 5 regular days.
Labs & Final Exam
- During Labs, attendance is mandatory and on some occasions the TA will take attendance and assign you small in lab exercises. Labs are a great way for you to get some hands-on practice at programming.
- There is a 3hrs final exam. The final exam is comprehensive, and you must obtain a mark of at least 40% to pass the course; otherwise, a grade of no higher than 47% will be assigned.
Late & Plagiarism Policy
There are no grace days; all due dates are firm. In case of illness, please have a doctor complete an official U of T medical certificate. For other emergencies, be prepared for us to request some kind of documentation. If you submit an assignment late or miss a midterm test due to illness or personal issue, first contact the instructor as soon as possible. Then, please follow the procedure described at https://www.utsc.utoronto.ca/aacc/petitions. For course work petitions, a Petition Form for Term Work form needs to be filled and given to the course instructor. This will not be accepted if submitted two days after the due date.
Plagiarism and cheating will not be tolerated. These are serious academic offences with severe consequences that you should be aware of; for details, please read the information in Chapter 6: Academic Regulations available at http://www.utsc.utoronto.ca/aacc/academic-integrity. If you any questions about cheating or plagiarism, ask your instructor.
Accessiblity Needs
The University of Toronto is committed to accessibility. If you require accommodations for a disability, or have any accessibility concerns about the course, the classroom or course materials, please contact Accessibility Services as soon as possible: disability.services@utoronto.ca or http://www.utsc.utoronto.ca/~ability/.