Project Status

1
gre
advises
Professor
ssn
Grad
(1,1)
(0,20)
isa
name
major
isa
Student
isa
Ugrad
Person
(0,)
enrolls
grade
gpa
(0,)
(0,)
Course
Semester
title
Cou
semesterid
Enrolls-not-a-set -4 Student must be ugrad or
grad -0 Other Errors -2 (or 3 if quite major)
Solution Problem1 Exam0 2003
2
gre
advises
Professor
ssn
Grad
(1,1)
(0,20)
isa
name
major
isa
Student
isa
Ugrad
Person
(0,)
enrolls
gpa
(0,)
(1,1)
Course
Enrollment
title
Cou
grade
semester
Enrolls-not-a-set -4 Student must be ugrad or
grad -0 Other Errors -2 (or 3 if quite major)
Another Solution Problem1 Exam0 2003
3
ssn
owns
name
Sal
birthd
(0,1)
name
Owner
isa
(1,1)
Person
Team
isa
city
contr
(9,25)
(0,)
Player
Home
Visit
to
(0,)
(0,)
weight
height
Sal
from
(0,)
Minor errors first 1, Subsequent -2 Major
errors first -4, Subsequent -5
play
played-in.
pos
(1,1)
(18,)
score
Game
Date
Game
Solution Problem1 Exam0 2002
4
empl.
name
ssn
Sal
(0,4)
name
Manager
isa
(1,3)
Person
Team
isa
city
contr
(24,99)
(0,1)
Player
birthd
Home
Visit
(0,)
(0,)
weight
pos
height
Sal
(0,)
play
played-in.
Day
(0,)
score
min
Date
(1,1)
(22,)

• Scoring
• Play relationship a Set 3
• Person/Player/Manager 3
• Weak Game Entity 3
• Played-in 2
• Can Only Play once on a day 1
• Contract 3
• Salary, score, min attribute 3

Game