CS 275 Introduction to Databases

Instructor: Hema Jyothi Yalamanchi

Meeting: MTWR 1:00 - 1:50 PM at Covell 218

Office hrs: MTW 11 AM - noon at Dearborn 119

Web Page: The students need to access the lecture notes and the Assignments through the blackboard. The blackboard can be accessed from here.

Course Description: Design and implementation of relational databases including data modeling, ER/UML diagrams, 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 Objective:

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 class diagram), 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 Assignments(10%)

Midterm(25%)

Final(25%)

Quizzes(20%)

Note: There will be a penalty for late submission of assignments and a high penalty if you miss a quiz.

Homework Assignments:

There would 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 three to four quizzes based on the time we have. The dates will be announced in class.

Midterm:

The midterm would be an hour-long exam and the date of the midterm would be decided in the class. As of now a date is mentioned in the schedule, but will be changed based on the decision in class

Final:

The final would be a two-hour exam and would be comprehensive.

Academic Dishonesty:

You are encouraged to discuss problems with each other. But, assignments must be an individual effort. Do not share the solutions to the assignments. Please read the academic dishonesty policy at http://eecs.oregonstate.edu/undergraduate/cs/dishonesty.html adopted by the Department of Computer Science. It will be vigorously enforced without exceptions.