Databases Reference
In-Depth Information
SSN
Birth_Date
First_Name
Sex
City
Name
Last_Name
Person
Address
Street
Number
Age
Number
Salary
IS_A
1:N
Major_Dept
Location
Name
Works_For
Student
Department
Employee
Alumnus
1:1
Number_
Employees
Degrees
Manages
IS_A
IS_A
M:N
Year
Degree
Major
Controls
1:N
IS_A
Works_For
Graduate_
Student
Undergraduate_
Student
Percent_Time
Student-
assistant
Staff
Faculty
Degree program
Project
Class
Name
Position
Rank
Entity relationship symbols
IS_A
Location
Number
Teaching_Assistant
Research_Assistant
Entity
Relationship
Simple
attribute
Composite
attribute
Multivaluated
attribute
Project
Course
IS_A relationship
Derived attribute
Figure 14.5
An E/R schema.
