1 / 1

Mom and Pop Johnson Video Store Database E/R Diagram

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

huey
Download Presentation

Mom and Pop Johnson Video Store Database E/R Diagram

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. 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=

More Related