Instructor: Hema Jyothi Yalamanchi
email: yalama@eecs.oregonstate.edu
Meeting: MTWRF 1:00 - 1:50 PM at Covell 218
Office hours: MW After class
Web Page: Students need to access lecture notes and assignments through the blackboard. The blackboard can be accessed from here.
Course Description: Design and implementation of relational databases including data modeling, ER/UMLdiagrams, relational schema, SQL queries, normalization, user interfaces and administration.
Required Textbook: “Fundamentals of Database Systems”, Ramez Elmasri and Shamkant B. Navathe. Addison Wesley, ISBN 0-321-12226-7.
Optional Textbook: “Web Database Applications with PHP & MySQL”, Hugh E. Williams and David Lane. O'Reilly, ISBN 0-596-00041-3.
Course Objectives:
On completion of the course, students must demonstrate the ability to:
1. Design and implement a simple relational database and formulate SQL queries.
2. Explain the principles of data modeling, create an ER diagram (or UML classdiagram), and generate a relational schema from such a diagram.
3. Understand a mechanism for database access from an application program and create a simple database application with a graphical user interface
Grading:
Assignments(20%)
Programming Assignment(15%)
Quizzes(10%)
Midterm(25%)
Final(25%)
Class participation (5%)
Note: There will be a penalty for late submission of assignments.
Homework Assignments:
There will be an assignment every week and it is due at the beginning of the class on the due date. You will mostly have a week to work on each assignment. Hard copies of the homework must be turned in.
Quizzes:
We will have two quizzes worth 5% each. The dates will be announced in class.
Midterm:
The midterm would be an hour-long exam and the date of the midterm will be decided in the class.
Final:
The final would be a two-hour exam and would be comprehensive.
AcademicDishonesty:
Youare encouraged to discuss problems with each other. But, assignments must be anindividual effort. Do not share the solutions to the assignments. Please readthe academic dishonesty policy at http://eecs.oregonstate.edu/undergraduate/cs/dishonesty.htmladopted by the Department of Computer Science. It will be vigorously enforcedwithout exceptions.