Day 3 Database Models - Database Models (Part 1) Confusing?...

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

View Full Document Right Arrow Icon
Database Models (Part 1)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Confusing? Women Men Girls Boys
Background image of page 2
Notation Women Men Girls Boys 1:1 1:N 1:N 1:N 1:N M:N M:N M:N Which way does it go? And, is it mandatory?
Background image of page 3

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

View Full DocumentRight Arrow Icon
Notation - Crow’s Foot Zero One Many Women Men Girls Boys
Background image of page 4
Keys Primary Key (pk) Uniquely identifies record in a table Foreign Key (fk) Uniquely identifies “parent” record
Background image of page 5

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

View Full DocumentRight Arrow Icon
Keys Men Boys MID (pk) 1111 2222 3333 MName John Jones Sid Smith Will White MBorn 1/2/1960 2/3/1965 3/4/1970 BID (pk) 4444 5555 6666 BName Jack Jones Sam Smith Steve Smith BBorn 4/5/1990 5/6/1995 6/7/2000 MID (fk) 1111 2222 2222 FK points to the unique parent
Background image of page 6
Keys – Orphans Men Boys MID (pk) 1111 2222 3333 MName John Jones Sid Smith Will White MBorn 1/2/1960 2/3/1965 3/4/1970 BID (pk) 4444 5555 6666 7777 BName Jack Jones Sam Smith Steve Smith Bill Barnes BBorn 4/5/1990 5/6/1995 6/7/2000 7/8/2005 MID (fk) 1111 2222 2222 ____
Background image of page 7

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

View Full DocumentRight Arrow Icon
How do you represent a 1:N relationship?
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/02/2012 for the course MIS 325 taught by Professor Mote during the Spring '08 term at University of Texas at Austin.

Page1 / 19

Day 3 Database Models - Database Models (Part 1) Confusing?...

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

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