6 - 1/16/10
 Announcements •  Overview: –  – ...

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

View Full Document Right Arrow Icon
1/16/10 1 Announcements Overview: 1. Introduction 2. Conceptual DB design: ER Models 3. Relational Algebra 4. SQL Monday: MLK day Early warning Wed 1/27 (swap of class disc. sect.) Class will be from 8-8:50am in 234 Wellman Discussion Section will be at 3:10-4pm in 234 Wellman Homework 2 (RA, simple SQL): Out next week; due: one week after ECS‐165A WQ'10 1 Modeling Alternatives: Attribute | Entity | Relationship Should ofFce be an attribute of Employee ? Should ofFce be a separate Entity Type ? Most attributes can be “promoted” to an Entity Set … and some Entities can be “demoted” to an attribute value This is one reason why there are so many different ways to design a schema ECS‐165A WQ'10 2 Project Employee Assignment num name due ssn name office
Background image of page 1

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

View Full DocumentRight Arrow Icon
1/16/10 2 Modeling Alternatives: Attribute | Entity | Relationship What are some reasons to model OfFce as an Entity Set? An employee can have more than one ofFce Alternative? There are additional attributes of OfFce OfFce needs to participate in other relationships E.g., a relationship set connecting to furniture or telephones or network drops (located in the ofFce) ECS‐165A WQ'10 3 Project Employee Assignment num name due ssn name Office Assigned Office num Modeling Alternatives: Attribute | Entity | Relationship Example when OfFce should be an entity set OfFce needs to participate in other relationship sets ECS‐165A WQ'10 4 Project Employee Assignment num name due ssn name Office Assigned Office num size Located In Furniture type id
Background image of page 2
1/16/10 3 Modeling Alternatives: Attribute | Entity | Relationship Example: SUPPLIER offers PRODUCTS at PRICE Where does PRICE go? ECS‐165A WQ'10 5 Key Constraints as Described in the Textbook Limiting participation in a relationship set to at most 1 entity Same as maximum cardinality of 1 ( 0.. 1 in our notation)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/06/2010 for the course CSE 302 taught by Professor Joel during the Summer '05 term at Punjab Engineering College.

Page1 / 9

6 - 1/16/10
 Announcements •  Overview: –  – ...

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

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