Announcements

1
Announcements

• Reading for Monday
• Appendix A
• Homework 3 Due today
• Project Steps 2.1-24
• Due 10/4
• Exam 1 10/6

2
Sample Queries on the STUDENT/FACULTY/TRANS
Database

• Find the ages of all students
• Find all information on males transferees
• Find all 21 year olds who are students or
  transferees
• Find the ages of all students who have the same
  name as a faculty member.

3
Sample Queries on the STUDENT/FACULTY/TRANS
Database

1. Find all possible student advisor pairs. List
   their names only.
2. Find all transferees who are the same age as the
   student named Beckman.
3. Find all faculty in Quincy's department.

4
Mapping

• Lecture 9

5
Views

• External models in 3-level architecture are
  called external views
• Relational views are slightly different
• Relational view is constructed from existing
  (base) tables
• External model may have views and base tables

6
Mapping E-R Diagrams to Relations (Details pp.
206-213)

• Create a table for each entity type and each
  relationship.
• Deal with strong entity types

areaCode
number
last
first
phone
name
Patient
patId
DOB
SSN
7
Mapping E-R Diagrams to Relations

• Deal with weak entity types

date
incurs
1
M
Visit
Charge
visitNo
amount
item
8
Mapping E-R Diagrams to Relations

• Deal with relationships
• 1 to 1
• 1 to N
• M - N

9
Mapping E-R Diagrams to Relations

1. Deal with multi-valued attributes -

10
(No Transcript)