Database systems - Computer Science 180: Database Systems...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Winter 2002 Arthur Keller – CS 180 1–1 Computer Science 180: Database Systems Arthur M. Keller Email: ark@cse.ucsc.edu (best way to reach me) Office: Baskin Engineering 153a, (831) 459-1485 Office Hours: Tuesdays 4:30–5:30pm and by appointment Class web page: http://www.cse.ucsc.edu/classes/cmps180 My web page: http://www.cse.ucsc.edu/~ark Assignments due most Tuesdays; Project Parts due most Thursdays T.A. – T.J. Steed
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 1–2 Textbooks Required: Database Systems: The Complete Book , by Garcia-Molina, Ullman, and Widom (first edition), Prentice Hall, 2002. Recommended: (one of these) A Guide to the SQL Standard: A User's Guide to the Standard Database Language SQL , (fourth edition), by C.J. Date and Hugh Darwen, Addison-Wesley, 2000. SQL: 1999 - Understanding Relational Language Components , (first edition), by Melton and Simon, Morgan Kaufmann, 2002. PostgreSQL: Introduction and Concepts , Bruce Momjian, Addison-Wesley, 2001. You may also want: Books on Unix, Perl, PHP, and CGI.
Background image of page 2
Winter 2002 Arthur Keller – CS 180 1–3 Grading Assignments: 8 @ 2% each = 16% of grade. Project: 7 @ 5% each = 35% of grade. Midterm: Feb. 14 (TH) in class. 14% of grade. Final: Mar. 16 (Sa) 12–3PM in class. 35% of grade.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 1–4 Project You will build an application using a relational database system (PostgreSQL) accessed via the web. The project has 7 parts (due most Thursdays), starting with design and ending up with a complete application. The early programming assignments should be written in C, C++ or Java. Some students found it helpful to switch to PHP or Perl for the final project.
Background image of page 4
Winter 2002 Arthur Keller – CS 180 1–5 Warning This class is a lot of work. But it is worth it. Of all courses you take at UCSC, this may be the one that gets you a job.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 1–6 Schedule Today: Jan. 3 (TH) Intro, Entity-Relationship Model. Read Chapter 1 and Sections 2.1-2.2. Jan. 8 (T) Weak Entity Sets, Entity-Relationship Design. Read Sections 2.3-2.4. Jan. 10 (TH) Relational Model, Functional Dependencies. Read Sections 3.1-3.5. Jan. 15 (T) Normal Forms, Multivalued Dependencies. Read Sections 3.6-3.7. Assignment 1 due.
Background image of page 6
Winter 2002 Arthur Keller – CS 180 1–7 Syllabus The background and history of database management systems. The fundamentals of using a database management systems. Industry standards used for database management systems. Theoretical background of the relational model. Queries and Updates. Logic databases. Transactions and Security. Object-oriented, object-relational, semi-structured and XML database systems. Mediation and warehousing.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 1–8 What is a Database Management System?
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/21/2011 for the course CS 180 taught by Professor Dr.arthur during the Fall '01 term at The University of Akron.

Page1 / 41

Database systems - Computer Science 180: Database Systems...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online