CS669_Module4Lecture - Module 4 Page 1 of 30 Module 4 This...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Module 4 This is a single, concatenated file, suitable for printing or saving as a PDF for offline viewing. Please note that some animations or images may not work. Module 4 Study Guide and Deliverables Concept Readings: Coronel & Morris, chapters 9 and 10 SQL Readings: Coronel & Morris, sections 8.4 through 8.8 of chapter 8 Assignments: Concepts Assignment 4, SQL Lab 4, and Term Project Iteration 4 due Tuesday, June 9 at 6:00 AM ET Term Project Milestones: Provide the tables, data, and SQL which address an iterative subset of the situations in the Term Project description Assessments: Quiz 4 due Tuesday, June 9 at 6:00 AM ET Which First? Read the book chapters before reading the online lectures. The categorizations of SQL functions provided by the textbook—date and time, numeric, string, and conversion—are widely accepted, yet these categorizations by no means identify the only kinds of functions available. Many modern DBMS functions take many different types of parameters and return many different types of values, and these functions cannot be easily categorized. For example, functions in some modern DBMS can take table rows or entire tables as parameters. Modern DBMS also support the creation of new, custom functions which may not be accurately described by the aforementioned categories. Lastly, different DBMS implement many functions differently and so there is little uniformity between different DBMS. Section 9.4 in the textbook teaches conceptual design with one major difference with what is taught in this course. The textbook includes SQL constraints in conceptual design, resulting in conceptual ERDs with SQL constraints visible, while in this course we teach you that conceptual design should be entirely independent of any particular model, including the relational model. In this course, we recommend to avoid using SQL-based constraints in conceptual design. Page 1 of 30 Module 4 5/14/2015 ...
Image of page 1

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

View Full Document Right Arrow Icon