CMPS 180: Database Systems I. Textbook: “A First Course in Database Systems”, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 3rd edition. Science and Engineering Library has textbook on Reserve. 2cd edition is also available, but this course uses 3rd e

CMPS 180: Database Systems I. Textbook: “A First Course in Database Systems”, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 3rd edition. Science and Engineering Library has textbook on Reserve . 2cd edition is also available, but this course uses 3rd edition Course Description/Syllabus CMPS 180 covers concepts, approaches, tools, and methodology of database design and querying. Topics include: • Relational Data Model and its History • SQL language: Data Definition, Queries and Updates, Indexes, Views, Constraints, Rules • Relational Algebra, Query Execution • Transaction Processing • Database Application Development • Design Theory: Schemas and Normal Forms • On-Line Analytical Processing (OLAP) • Semi-Structured Data Models: XML, JSON, etc. • Cloud Databases (time permitting) • Big Data and NOSQL (time permitting) Lots of practical material and logic … and lots of concepts and theory, particularly in the second half of the term