Mom and Pop Johnson Video Store Database E/R Diagram - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Mom and Pop Johnson Video Store Database E/R Diagram PowerPoint Presentation
Download Presentation
Mom and Pop Johnson Video Store Database E/R Diagram

play fullscreen
1 / 1
Mom and Pop Johnson Video Store Database E/R Diagram
1547 Views
Download Presentation
huey
Download Presentation

Mom and Pop Johnson Video Store Database E/R Diagram

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Mom and Pop Johnson Video Store Database E/R Diagram MOVIE Movie ID Distributor ID Movie Name Movie Type Rating Running Length Year Released Actors Actresses Director Academy (Y, N) Format Type RECORDATION REPORT STORE CUSTOMER FEES DISTRIBUTORS Customer ID Name Address City State Zip Phone No DOB DVD ID Video ID Fees ID Date Rented Date Returned Store ID Store Name Store Address Store City Store State Store Zip Store Phone No Customer ID Distro ID Distributor ID Distributor Name Distributor Address Distributor City Distributor State Distributor Zip Distributor Phone No Fees ID Late Fee Damage Fee FTR Fee Tax Rate ELECTRONIC CATALOG TRANSACTION FEES Catalog ID Catalog No Distro ID Movie ID Store ID VIDEO DVD DVD ID Video ID Fees ID DVD Fee Video Fee DVD ID Movie ID Copy No Video ID Movie ID Copy No PK- Black underlined Attribute FK- Blue Underlined Attribute “D” “V” d Format Type=