mmpn exercises
Download
Skip this Video
Download Presentation
mMpn Exercises

Loading in 2 Seconds...

play fullscreen
1 / 5

mMpn Exercises - PowerPoint PPT Presentation


  • 55 Views
  • Uploaded on

mMpn Exercises. PAYMENT SeqNum. LOAN LoanID. CUSTOMER CustID. (0,n). (1,1). (1,1). (1,n). A car loan to a customer is paid back by regular monthly, numbered payments. Payments are identified by which loan and which payment number. PERSON SSN. PLAYER position. COACH. is\_a. is\_a.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'mMpn Exercises' - peers


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
mmpn exercises

mMpn Exercises

Database Principles

slide2
PAYMENT

SeqNum

LOAN

LoanID

CUSTOMER

CustID

(0,n)

(1,1)

(1,1)

(1,n)

  • A car loan to a customer is paid back by regular monthly, numbered payments. Payments are identified by which loan and which payment number.

Database Principles

slide3
PERSON

SSN

PLAYER

position

COACH

is_a

is_a

trains

(1,1)

(1,n)

  • Baseball teams consist of players and coaches. The former are known to play different positions. All players have a coach responsible for their training.

Database Principles

slide4
ACCOUNT

BRANCH

AcctNum

Name

CUSTOMER

SSN

held with

(0,n)

(1,1)

(c,d)

(a,b)

(1,n)

  • Must a customer have accounts with only 1 branch?
  • Do branches share responsibility for accounts?

(e,f)

opens

(g,h)

(1,n)

No. h == n and c == 1

No. d == 1

Database Principles

slide5
(e,f)

(0,n)

qualified to repair

PLANETYPE

TypeName

(1,n)

(g,h)

(a,b)

(1,1)

is of type

MECHANIC

SSN

(c,d)

repaired by

PLANE

PlaneID

(0,n)

(1,n)

(k,l)

date

(0,n)

(I,j)

  • What is the obvious mistake in the above diagram?
  • Does the model support the enterprise rule that there should always be a mechanic able to repair any plane in need?

(c,d)=(0,n). It should be (1,1)

No, e=0, a=1 implies there may be a planeand no mechanic qualified to repair it.

Database Principles

ad