DOC PREVIEW
SJSU CS 157A - Syllabus

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

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 6 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 6 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 6 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Green SheetOffice hours: TTh 10:15- 12:00 PM, 2:45 - 4:00 PM Reference books(7) Extra CreditGrading Scale Final grade will be based on the total number of points accumulated on the quizzes, tests, and the term project. The ranges of scores for letter grades are:Things That Should Go Without SayingGreen Sheet Course Title: CS 157A - Database Management SystemsInstructor: Prof. Sin-Min Lee Office: MH212 Tel. No.: (408) 924-5133CS 157 Section 2 MH 223 9:00-10:15Office hours: TTh 10:15- 12:00 PM, 2:45 - 4:00 PM e-mail: [email protected] It is a more efficient way of contacting me outsideof office hours Course Description: This course is aim to present the principles of databasesystems and concentrate on issues central to the design and implementation ofrelational database applications. Describe the main features of the types of datamodels used in building databases. Compare and contrast the advantages anddisadvantages of linked-list, hierarchical, network, and relational models. Thiscourse stresses database applications development through fourth-generationprogramming techniques. Content of the course stresses basic knowledge ofnormalization of data, data modeling database methods, database design, andthe use of databases in business and physical storage structures This courseintroduces the theory and practice of database design and application, withemphasis on relational and object-oriented models. Topics include the relationalalgebra and calculus, data manipulation languages, normalization, Students willgain an understanding of normalization and referential integrity. They will alsolearn how to create relational objects through SQL and index design. Use thequery languages of a DBMS. Design and optimization of relational databases -decomposition, lossless joins, dependency preservation, normal forms. Prerequisite: CS-46A and 46B.CS 146, Calculus, Discrete Mathematics, Data Structures. Textbooks: Jeff Ullman and Jennifer Widom, A First Course in Database systems. 2ndedition, Prentice Hall.Reference books1. Connolly, Thomas M., Carolyn E. Begg and Anne D. Strachan, DatabaseSystems: A Practical Approach to Design, Implementation and Management,Addison-Wesley Publishing Company, Inc. 1996. 2 . C.J. Date, "An Introduction to Database Systems", 7thEdition, AddisonWesley, 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 UniversityPress,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 Mc Graw-Hill19988. 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, 4thEd., McGraw-Hill, 2001.12.H. Finkenzeller; U. Kracke; M. Unterstein "SQL/ORACLE : Structure, Setupand Use" (QA76.73.S67 F499 1990). 13. A.E. McCullough "Oracle PL/SQL for SQL *Forms" (QA76.73.S67 M331994) . Dropping Classes: Monday, February 14, 2005, last day to drop or withdrawwithout a “W” grade. Needed Skills: This course is intended for senior level undergraduate and firstyear graduate students. A good data structures background is assumed.Therefore CS 146 is a prerequisite for this course. Many query languages arebased on the predicate calculus. Therefore Discrete Math. is stronglyrecommended . The student is expected to be familiar with basic concepts ofprogramming in Java and with a variety of mathematical tools for modeling andanalyzing discrete structures. More specifically, the student should be familiarwith programming features such as variables, control flow, iteration, andrecursion, and structures such as arrays, records, lists. Characteristics of theJava programming language, and of an object-oriented approach to softwaredesign, will be emphasized. Teaching Methodology: The course is given through two lecture periods eachweek. The instructional methods used in conducting the course include: lectures,discussion, presentation. and classroom demonstration. In this class you willprimarily learn by doing. You will prepare for and follow up on lectures by readingrelevant portions of the textbooks (especially prior to class). I will augment theinformation presented in the textbook with my own ideas and other resources. Iencourage discussions in class. Students in the course are expected tocomplete: assigned readings, assignments, and projects. Most of the lectureshave reading assignments that you should complete before the lecture. Duringthe lectures, I may ask short essay questions to ascertain the level ofunderstanding of the reading. I encourage collaboration learning but notcheating in class. You may collaborate with your classmates on assignments butyou have to do your own work. Plagiarism is not allowed in this class. Each oneof you will deliver a 20—25 minutes presentation in class. The material willsupply by the instructor. This productive activity could radically alter your futurepotential Attendance Policy: The instructor must be notified in advance for an excused absence. If you are absent, it is your responsibility to get with a classmate and go over what happened in class. Since we are solving new problems during eachclass, it is critical that you get this information. If an assignment is due on the dayyou are absent, it is your responsibility to ensure the work is turned in on-time or ahead of time unless your absence is due to an unavoidable emergency. Handouts will be distributed only in class. Students who notify the instructor of anabsence prior to class will receive handouts after their return. Examinations: All examinations will be announced at least one week in advanceand will cover material discussed in class and the text book. Test material will bedrawn from the text book, lecture, assignments and any supplementary


View Full Document

SJSU CS 157A - Syllabus

Documents in this Course
SQL

SQL

18 pages

Lecture

Lecture

44 pages

Chapter 1

Chapter 1

56 pages

E-R Model

E-R Model

16 pages

Lecture

Lecture

48 pages

SQL

SQL

15 pages

SQL

SQL

26 pages

Lossless

Lossless

26 pages

SQL

SQL

16 pages

Final 3

Final 3

90 pages

Lecture 3

Lecture 3

22 pages

SQL

SQL

25 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?