CS669_Module2Lecture - Module 2 Page 1 of 55 Module 2 This...

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

View Full Document Right Arrow Icon
Module 2 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 2 Study Guide and Deliverables Concept Readings: Coronel & Morris, chapters 3 and 4 SQL Readings: Coronel & Morris, sections 7.5 through 7.7 of chapter 7, section 8.1 of chapter 8 Assignments: Concepts Assignment 2, SQL Lab 2, and Term Project Iteration 2 due Tuesday, May 26 at 6:00 AM ET Term Project Milestones: Submit a conceptual entity-relationship diagram for your Term Project (Assignment 2.3) Assessments: Quiz 2 due Tuesday, May 26 at 6:00 AM ET Which First? Read the book chapters before reading the online lectures. Notes Section 4.1.6 describes a convention whereby a solid line is used to represent an identifying relationship, and a dashed line is used to represent a weak relationship. Although it is quite important to understand both kinds of relationships and the distinction between the two, the convention to use solid and dashed lines in an ERD is not universal. Therefore, it is not expected that you use this convention in course assignments, and facilitators will not grade you on use of this convention. Page 116 in the text contains a note from the authors stating that "the order in which the tables are created and loaded is very important," further indicating that a referenced table must be created before any referencing tables. It is best practice to avoid defining foreign key constraints in your CREATE TABLE definitions, and to instead define foreign key constraints using ALTER TABLE definitions after all tables have been created. By using this best practice, the order of the CREATE TABLE statements is irrelevant, and you will save countless hours of creating dependency graphs and ordering your tables before creating them. Production systems oftentimes contain hundreds of tables, and creating dependency graphs for this number of tables is cumbersome. Page 1 of 55 Module 2 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