DOC PREVIEW
SJSU CMPE 226 - Syllabus

This preview shows page 1-2 out of 5 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 5 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 5 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 5 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Course: CMPE 226Semester: Fall 2003Instructor Information and Course DescriptionCourse Meeting Place/Time: Lecture: IS 216, Tuesday 6:15 p.m. to 9:00 p.m. (18:15 to 21:00)Office Hours: Monday: 11:30 a.m. – 1:30 p.m.Tuesday: 3:00 p.m. – 5:00 p.m.Course Catalog DescriptionCourse OutlineCOMPUTER ENGINEERING DEPARTMENTCourse: CMPE 226Course Title: Database DesignSemester: Fall 2003______________________________________________________________________________Instructor Information and Course DescriptionInstructor: Dr. M.E. Fayad, Office Engr 283I, [email protected], (408) 924-7364Web page: http://www.engr.sjsu.edu/~fayad Course Meeting Place/Time: Lecture: IS 216, Tuesday 6:15 p.m. to 9:00 p.m. (18:15 to 21:00) Office Hours: Monday: 11:30 a.m. – 1:30 p.m.Tuesday: 3:00 p.m. – 5:00 p.m.Other times: Send an e-mail to schedule an appointment.Course URL: http://www.engr.sjsu.edu/~fayad /current.courses/cmpe226-fall03Course Catalog DescriptionFor over 30 years, computerized database systems have been developed and used to help computers manage the increasing amount of data that we store and manipulate. This course presents an overview modern database systems and some advanced issues.Prerequisites: CmpE126/CS046B (?), (Data Structures & Algorithms), or instructor’s per-mission -- Good background in the practical use of an object-oriented programming language is a plus.Required Textbooks: 5-7 chapters will be covered from 1st book.1. P. Revesz, Introduction to Constraint Databases , Springer, New York, 2002, ISBN 0-387-98729-02. C.J. Date and C.J. Date. An Introduction to Database Systems, 8th Edition, Pearson Addison Wesley, July 2003, ISBN 03211978443. Ramez Elmasri and Shamkant Navathe. Fundamentals of Database Systems, 4th Edition, Addison-Wesley, July 2003, ISBN 0321122267Required Articles, Columns, Case Studies, and Patterns will be posted on the web later.Supporting Textbooks:Paul DuBois. MySQL Cookbook, 1st Edition, O’Reilly & Associates, November 2002, ISBN 0596001452Other Resources: Instructor notes will be available on the course web page.Course Objectives: 1 of 5COMPUTER ENGINEERING DEPARTMENT This course develops your understanding of database system CONCEPTS that are independent of any specific database system. As an analogy, if you took a driver’s education class, you learned there driving, which is independent of any specific car. This distinction between conceptsand tools is important to keep in mind in this course (especially by students who like to list on their resumes a long list of specific operating systems, programming languages, and database systems).These concepts include: data abstraction levels; data independence; data models, including relational, constraint, spatial, and spatiotemporal data models; query languages, including relational algebra, and SQL; database design concepts, including integrity constraints; and interoperability, including data and query interoperability. Many of these concepts have a remarkable staying power, while the specific systems change all the time. In fact, the more basic the concept the more likely it is to endure. For example, the concept of data abstraction endured even as new data models were invented: hierarchical in the 1950s, network in the 1960s, relational in 1970, and various spatial data models used in GI in more recent years. As another example, the QL language, invented in the early 1970s,is still the primary language of relational database systems today, whether they come from Oracle, IBM, Microsoft, MySQL, ybase, Empress, etc.By understanding well the concepts and not just a specific system on a specific platform, you should be able to adjust better to future changes in the database systems area. In particular, GI is emerging as a very important extension of relational databases, with some estimates putting the word-wide GIS market at about one billion dollars annually, while the relational database market is about six billion dollars annually. Hence we will learn about GIS too in this course. This course will contain three projects that are designed to illustrate a variety of uses of database systems (all subject to change):Project 1: This project will focus on relational databases and QL. For this you can use either the MLPQ system, which was developed at UNL, or the My QL system, which is a free relational database software. However, the classroom examples will be based on MLPQ.Project 2: This project will focus on constraint and spatial data storage. For this you need to use the complete MLPQ/PRe TO system, which is like a GI system, and students in the past used it for various interesting projects that needed to store maps or drawings. Note that for this you cannot use MySQL.Project 3: This project will focus on web accessible MLPQ databases. You need to set up a webpage with embedded QL queries that can remote access an MLPQ database.BACKGROUND: This course is targeted to those individuals who are interested in database design and would like to learn several database design and systems. Course OutlineCheck Course Outline. Grading PolicyYour grade in this course will be based on your performance on written homework, test, and a programming project.2 of 5COMPUTER ENGINEERING DEPARTMENT4 Assignments 60Midterm 45Final Exam 602 Team Projects 60Total 225Your lowest homework grade will be dropped hence the maximum will be 210 points that you can earn without extra credits. Your final grade will be based on the percentage of your total points (200 points counts as 100%). Your grade will be based on an overall curve.Final Grades:Letter grades will be assigned at the end of the course. Final grades will be based on a competitive curve. Graduate and undergraduate students are graded separately. Students will be informed of their standing at intervals throughout the course. Final grades are not negotiable. Unless there are mathematical errors, I will be unavailable to discuss final grades. Borderline cases will be considered with extreme care, and fair grades will be rendered. Class Attendance: Class attendance is mandatory. If you have more than four unexcused absences, then you will be dropped from the class. Due Dates:Late homework assignments, extra assignments, and projects are NOT ACCEPTABLE. There will be no make up tests.Group Projects:The class will be divided into groups of 2-3 (three preferred) for team projects. Students will be responsible for forming groups. Students will give a


View Full Document

SJSU CMPE 226 - Syllabus

Documents in this Course
SQL-99

SQL-99

71 pages

XML

XML

52 pages

XML

XML

14 pages

Chapter 9

Chapter 9

45 pages

Load more
Download Syllabus
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Syllabus and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Syllabus 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?