CMIS320Project 1

Student Name: Michael Aponte

Class/Section: CMIS

Professor Name:Kevin Woodson

Assignment due date:June 10th, 2012

  1. ENTITY LIST AND RELATIONSHIPS

ENTITIES

  1. MOVIE – This comprises the DVDs and Movies that are rented at Mom and Pop Johnson’s Video Store. This also comprises the details of each movie (rating, actor, actress, type, etc..) and contains the foreign keys that are related to this MOVIE entity.
  2. DVD – This includes the copies of the movies that are in DVD format.
  3. VIDEO – This includes the copies of the movies that are in Video format.
  4. CUSTOMERS– This entity houses and stores the customer information which keeps track of the rentals for Mom and Pop Johnson’s Video Store.
  5. FEES– This stores the tax rate, damaged fees, late fees and the fees associated with a failure to rewind.
  6. TRANSACTION_FEES – Stores standard charges in this entity.
  7. RECORDATION_REPORT – Keeps track when the movies in the form of DVD or Video are rented out and when they are returned. This entity also has a few foreign keys to show their relation.
  8. DISTRIBUTORS- Supplies the movies in the form of DVDs or Videos to Mom and Pop Video Store.
  9. ELECTRONIC_CATALOG – The Distributors provide electronic catalogs to Mom and Pop Video Store.
  10. STORE – Orders movies from distributors through the use of the Distributors electronic catalogs.

RELATIONSHIPS- PAIRS OF SENTENCES

  1. Each MOVIE can be either a DVD or a Video (also can have multiple copies of each one based on movie title). Each DVD is a MOVIE and each VIDEO is a MOVIE.
  1. DVD- A Sub Class of the Super Class MOVIE.
  1. VIDEO – A Sub Class of the Super Class MOVIE.
  1. MOVIE – DISTRIBUTORS
  • Each MOVIE is purchased from one or more DISTRIBUTORS (of half a dozen).
  • Once purchased the DISTRUBUTORS supply the inventory for each MOVIE.
  1. DISTRIBUTORS – ELECTRONIC CATALOG – STORE
  • A DISTRIBUTOR creates one or more ELECTRONIC CATALOGS for each store.
  • One or more ELECTRONIC CATALOGS go to each STORE.
  • Each STORE may order movies from one or more DISTRIBUTORS.
  1. STORE – RECORDATION REPORT
  • Each STORE keeps track of one or many RECORDATION REPORTS.
  • One or more RECORDATION REPORTS are kept track by each STORE.
  1. CUSTOMER –MOVIE
  2. Each CUSTOMER is involved in one or more MOVIES.
  3. Each MOVIE includes a CUSTOMER.
  1. CUSTOMER-TRANSACTION FEES
  2. Each CUSTOMER may be involved in one or more TRANSACTION FEES.
  3. One or more TRANSACTION FEES are involved with each CUSTOMER.
  4. FEES – TRANSACTION FEES
  • A FEE may be involved with one or more TRANSACTION FEES.
  • One or more TRANSACTION FEES are involved with FEES.
  1. E/R DIAGRAM
  • Here is the E/R Diagram for Project 1. I will also attach it as a Power Point presentation with this assignment.

  1. DATABASE DESIGN DESCRIPTION
  1. MOVIE- This entity requires a lot of information. I cannot see where I could make it any shorter because of the value of information it contains.

Movie ID / Distro ID / Movie Name / Movie Type / Rating / Length / Year Released / Actors / Actresses / Director
Academy (Y, N) / Format Type
  1. DVD

DVD ID / Movie ID / Copy No
  1. VIDEO

Video ID / Movie ID / Copy No
  1. CUSTOMERS

Customer ID / Name / Address / City / State / Zip / Phone No / DOB
  1. FEES

Fees ID / Late Fee / Damage Fee / FTR Fee / Tax Rate
  1. TRANSACTION FEES

DVD ID / Video ID / Fees ID / DVD Fee / Video Fee
  1. RECORDATION REPORT

DVD ID / Video ID / Fees ID / Date Rented / Date Returned
  1. DISTRIBUTORS

Distro ID / Distro Name / Distro Address / Distro City / Distro State / Distro Zip / Distro Phone No
  1. ELECTRONIC CATALOG

Catalog ID / Catalog No / Distro ID / Movie ID / Store ID
  1. STORE

Store ID / Store Name / Store Address / Store City / Store State / Store Zip / Store Phone No / Customer ID / Distro ID
  1. CONCLUSION

I have changed my number of entities and attributes numerous times until I finally felt comfortable where I thought they all belong. This assignment was very challenging, however, now that it is complete, I can see the big picture and how it all comes together. I am sure that this assignment is not perfect but I do feel confident that if the customer wanted to make any changes from what I have presented to them, I would be able to accommodate their needs.

1