CS669_Module3Lecture - Module 3 Page 1 of 46 Module 3 This...

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

View Full Document Right Arrow Icon
metcs669_module06 is displayed here Download Module 3 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 3 Study Guide and Deliverables Concept Readings: Coronel & Morris, chapters 5 and 6 SQL Readings: Coronel & Morris, section 8.3 and 8.4 of chapter 8. Note that section 8.2 will be read in module 5 Assignments: Concepts Assignment 3, SQL Lab 3, and Term Project Iteration 3 due Tuesday, June 2 at 6:00 AM ET Term Project Milestones: Submit a normalized, logical entity-relationship diagram for your term project database (Assignment 3.2) Assessments: Quiz 3 due Tuesday, June 2 at 6:00 AM ET Which First? Read the book chapters before reading the online lectures. © 2015 Trustees of Boston University. Materials contained within this course are subject to copyright protection. Lecture 7 - Advanced Data Modeling Introduction Extended Entity-Relationship Models Entity-relationship modeling is missing the ability to represent relationships based on specialization and generalization. For example, you can't directly represent that students and faculty are people in an ERD. This shortcoming is addressed in Extended Entity-Relationship Modeling, which includes specialization-generalization relationships. Copyright © 2007, 2008 Vijay Kanabar & Robert Schudy Abstraction, Entities, and Classes Abstraction means identifying the common characteristics of things and using those common characteristics to classify or organize things. We used abstraction when we identified entities and produced Entity-Relationship models. Page 1 of 46 Module 3 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