1 / 4

Course

gre. advises. Grad. Professor. ssn. (1,1). (0,20). isa. name. major. isa. Student. Ugrad. isa. Person. (0,*). enrolls. grade. gpa. (0,*). (0,*). Semester. Course. title. Cou#. semesterid. Enrolls-not-a-set: -4 Student must be ugrad or grad: -0

zytka
Download Presentation

Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. gre advises Grad Professor ssn (1,1) (0,20) isa name major isa Student Ugrad isa Person (0,*) enrolls grade gpa (0,*) (0,*) Semester Course 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 Grad Professor ssn (1,1) (0,20) isa name major isa Student Ugrad isa Person enrolls (0,*) gpa (0,*) (1,1) Course Enrollment title Cou# semester grade 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 Sal owns name (0,1) birthd name Owner isa (1,1) Person Team isa city (9,25) contr (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. Sal empl. ssn name (0,4) name Manager isa (1,3) Person Team isa city (24,99) contr (0,1) Player birthd Home Visit (0,*) (0,*) weight height pos 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

More Related