Course: CMPE 226, Section 1Semester: Spring 20071. Course InformationCourse TitleAdvanced Database DesignCourse CodeCmpE 226Section1Class Hours & LocationThursday 6:00 p.m. to 8:50 p.m. (18:00 to 20:50) Engr. Room 331Office HoursThursday: 3:50 p.m. – 5:50 p.m. (2 hrs)Friday: 3:50 p.m. – 5:50 p.m. (2 hrs)Office LocationENG 283IOffice Phone(408) 924-7364E-mail:[email protected] ContactThrough e-mailDepartment Fax(408) 924-4153Course Web PageCourse Catalog Descriptiona. Grading PolicyCOMPUTER ENGINEERING DEPARTMENTCourse: CMPE 226, Section 1Course Title: Database DesignSemester: Spring 2007______________________________________________________________________________1. Course InformationInstructor: Dr. M.E. FayadComputer Engineering, College of Engineering, San Jose State UniversityWeb page: http://www.engr.sjsu.edu/fayad Course Title Advanced Database DesignCourse Code CmpE 226Section 1Class Hours & LocationThursday 6:00 p.m. to 8:50 p.m. (18:00 to 20:50) Engr. Room 331Office HoursThursday: 3:50 p.m. – 5:50 p.m. (2 hrs)Friday: 3:50 p.m. – 5:50 p.m. (2 hrs)Other times: Send an e-mail to schedule an appointment.Office LocationENG 283IOffice Phone(408) 924-7364E-mail: [email protected] Preferred Contact Through e-mailDepartment Fax (408) 924-4153Course Web Pagehttp://www.engr.sjsu.edu/~fayad /current.courses/cmpe226-spring20071 of 8COMPUTER ENGINEERING DEPARTMENT2. Course Descriptiona. Course Overview and Description:Course Catalog DescriptionDatabase concepts and architecture. Logical and physical data organization. Relational, hierarchical and network databases. Security/integrity, recovery/ concurrency. Design projects. 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 concepts and 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 theseconcepts 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 two or three projects that are designed to illustrate a variety of uses of database systems (all subject to change):b. Prerequisites: CmpE126/CS046B (Algorithms & Data Structures), or CmpE 200 (Computer Arch.) or Instructor Consent -- Good background in the practical use of an object-oriented programming language is a plus.c. Required & Recommended Texts: Any book is fine. You can count on the information that I provide for you on the website.2 of 8COMPUTER ENGINEERING DEPARTMENTd. Other Reading Materials: Supporting Texts:1. Ramez Elmasri and Shamkant Navathe. Fundamentals of Database Systems, 4th Edition, Addison-Wesley, July 2003, ISBN 0321122267Chapters: 1, 3, 7, 8, 11, and 12Chapters’ sections of 2, 4, 19, 21, and 26.** Good notes will be provided for the above chapters.2. Peter Revesz, Introduction to Constraint Databases, Springer, New York, 2002, ISBN 0-387-98729-03. Paul DuBois. MySQL Cookbook, 1st Edition, O’Reilly & Associates, November 2002, ISBN 0596001452Required Articles, Columns, Case Studies, and Patterns will be posted on the web later.Other Resources: Instructor notes will be available on the course web page. e. Student Learning Objectives:On Successful completion of this course students shall be able to:1. Model and design conceptual databases using Entity-Relationship model, the traditional and stable class diagrams2. Understand and apply the relational algebra and SQL3. Learn and work on database issues, such as normalization and security4. Explore and examine database current trends, such as Constraints Database, Spatiotemporal Database, Data Visualization, and Data Animation5. Explore and learn database emerging trends, such as web technologies, XML, data warehousing, and data mining 3. Course Requirementsa. ProjectsProjects are team-oriented. The class will be divided into groups of 4-3 (three preferred) for team projects. Students will be responsible for forming groups. Students of the best 3 or 4 teams’ projects will give final presentations of their project work if asked. Grading criteria and project ideas will be posted in a project Web page. Teams are responsible for two projects and the third project is optional for extra points. Team must deliver if they select project #3 otherwise each team member will be penalized for 4 whole points each. Project 1: This project will focus on database modeling and design using UML Class Diagram and Normalization..3 of 8COMPUTER ENGINEERING DEPARTMENTProject 2: This project will focus on relational databases and SQL. For this you can use either the MLPQ system, which was developed at UNL. In this project, each team will be allowed to select one project out of many that are related to constraint database. MLPQ system will be used in this project.Project 3 (Optional): This project is an advanced project and is based on stabilization of data using enduing concepts
View Full Document
Unlocking...