slides2 - Schedule Today: Jan. 8 (T) x x Weak Entity Sets,

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

View Full Document Right Arrow Icon
Winter 2002 Arthur Keller – CS 180 2–1 Schedule Today: Jan. 8 (T) Weak Entity Sets, Entity-Relationship Design. Read Sections 2.3-2.4. Jan. 10 (TH) Relational Model, Functional Dependencies. Read Sections 3.1-3.5. Jan. 15 (T) Normal Forms, Multivalued Dependencies. Read Sections 3.6-3.7. Assignment 1 due. Jan. 17 (TH) Relational Algebra. Read Chapter 5. Project Part 1 due.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 2–2 Weak Entity Sets Sometimes an E.S. E ’s key comes not (completely) from its own attributes, but from the keys of one or more E.S.’s to which E is linked by a supporting many-one relationship. Called a weak E.S. Represented by putting double rectangle around E and a double diamond around each supporting relationship. Many-one-ness of supporting relationship (includes 1-1) essential. With many-many, we wouldn't know which entity provided the key value. “Exactly one” also essential, or else we might not be able to extract key attributes by following the supporting relationship.
Background image of page 2
Winter 2002 Arthur Keller – CS 180 2–3 Example: Logins (Email Addresses) Login name = user name + host name, e.g., ark@soe.ucsc.edu . A “login” entity corresponds to a user name on a particular host, but the passwd table doesn’t record the host, just the user name, e.g., ark . Key for a login = the user name at the host (which is unique for that host only) + the IP address of the host (which is unique globally). Design issue: Under what circumstances could we simply make
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.

Page1 / 16

slides2 - Schedule Today: Jan. 8 (T) x x Weak Entity Sets,

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