Green SheetCourse Title: CS 157A - Database Management Systems Instructor: Prof. Sin-Min Lee Office: MH212 Tel. No.: (408) 924-5133CS 157 Section 3 MH 223 9:00-10:15 Office hours: TTh 10:15 – 11:30 e-mail: [email protected] It is a more efficient way of contacting me outside of office hours Course Description: Current, classical database systems. Entity-relationship andenhanced entity models. Relational model, algebra, calculus. Current, emerging SQLstandard. Embedded, Dynamic SQL. Application perspective on transactions andsecurity. Interactive and programmatic interfaces to database systems. Applicationprogramming project using commercial database system.Student Learning ObjectivesBy the end of the course, you will gain an understanding of normalization and referential integrity. You will also learn how to create relational objects through SQL and index design. You will develop an ability to communicate effectively. You will learn to use thequery languages of a DBMS. You will also learn the design and optimization of relationaldatabases - decomposition, lossless joins, dependency preservation, and normal forms. You will develop an ability to use the techniques, skills, and modern database tools necessary for database design. Prerequisites: CS-46A and 46B.CS 146, Calculus, Discrete Mathematics, Data Structures.Textbooks: A. Silberschatz, H.F. Korth, S. Sudarshan: Database System Concepts, 5th Ed., McGraw-Hill, 2006.Text Coverage:I plan to cover eight chapters of the text:- Chapter 1: Introduction - Chapter 2: Relational Model - Chapter 3: SQL - Chapter 4: Advanced SQL-Chapter 5: Other Relational Languages Sections 5.1 (Tuple Relational Calculus), 5.2 (Domain Relational Calculus) and 5.3 (QBE) may be covered very briefly- Chapter 6: Entity-Relationship Model - Chapter 7: Relational Database Design- Chapter 18: Data Analysis and Mining Reference books1. Connolly, Thomas M., Carolyn E. Begg and Anne D. Strachan, Database Systems: APractical Approach to Design, Implementation and Management. Addison-WesleyPublishing Company, Inc. 1996. 2. C.J. Date, "An Introduction to Database Systems", 7thEdition, Addison Wesley, 19993. Elmarsi, R. and Navathe, S.. Fundamentals of Database Systems, BenjaminCummings 19894. Hughes, J. Object-Oriented Databases, Prentice-Hall International. 1991. 5 J.L. Johnson, Database—models, languages, design, Oxford University Press, 1997.6. Litton, Gerry. Introduction to Database Management: A Practical Approach. Dubuque,IA: William C. Brown Publishers, 1987.7. Raghu Ramakrishnan , Database Management Systems WCB McGraw-Hill 19988. P. O'Neil Database Programming, Principles, Performance, Morgan Kaufmann, 1994.9. J. S. Sayles "How to use ORACLE SQL*PLUS" (QA76.73.S67 S28 1991). 10. R. F. van der Lans "An SQL Guide for ORACLE" (QA76.73.S67 L358 1991).11. A. Silberschatz, H.F. Korth, S. Sudershan: Database System Concepts, 4th Ed.,McGraw-Hill, 2001.12.H. Finkenzeller; U. Kracke; M. Unterstein "SQL/ORACLE: Structure, Setup and Use"(QA76.73.S67 F499 1990). 13. A.E. McCullough "Oracle PL/SQL for SQL *Forms" (QA76.73.S67 M33 1994) 14. Jeff Ullman and Jennifer Widom, A First Course in Database systems. 2nd edition,Prentice Hall.Dropping Classes: September 5, 2006, last day to drop or withdraw without a “W” grade. Needed Skills: A good data structures background is assumed. Therefore CS 146 is aprerequisite for this course. Many query languages are based on predicate calculus.Therefore, Discrete Math is strongly recommended. The student is expected to befamiliar with basic concepts of programming in Java and with a variety of mathematicaltools for modeling and analyzing discrete structures. More specifically, the studentshould be familiar with programming features such as variables, control flow, iteration,and recursion, and structures such as arrays, records, and lists. Characteristics of theJava programming language, and of an object-oriented approach to software design, willbe emphasized. Teaching Methodology: The course is given through two lecture periods each week.The instructional methods used in conducting the course include: lectures, discussion,presentation and classroom demonstration. In this class you will primarily learn by doing.You will prepare for and follow up on lectures by reading relevant portions of thetextbooks (especially prior to class). I will augment the information presented in thetextbook with my own ideas and other resources. I encourage discussions in class.Students in the course are expected to complete: assigned readings, assignments, andprojects. Most of the lectures have reading assignments that you should complete beforethe lecture. During the lectures, I may ask short essay questions to ascertain the level ofunderstanding of the reading. I encourage collaboration learning but not cheating inclass. You may collaborate with your classmates on assignments but you have to doyour own work. Plagiarism is not allowed in this class. Each one of you will deliver a 20—25 minute presentation in class. I will supply the material. This productive activitycould radically alter your future potential. Attendance Policy: The instructor must be notified in advance for an excusedabsence. If you are absent, it is your responsibility to get with a classmate and go overwhat happened in class. Since we are solving new problems during each class, it iscritical that you get this information. If an assignment is due on the day you are absent, itis your responsibility to ensure the work is turned in on time or ahead of time unlessyour absence is due to an unavoidable emergency. Handouts will be distributed only inclass. Students who notify the instructor of an absence prior to class will receivehandouts after their return. Examinations: All examinations will be announced at least one week in advance andwill cover material discussed in class and the textbook. Test material will be drawn fromthe textbook, lecture, assignments and any supplementary material provided by theinstructor. Grading: Students' competencies with respect to the objectives of this course will be evaluated by the following means: assignments, projects, presentation and examinations.(1)
View Full Document