cmis320 project 2.docx - Gerald Seegars Cmis 320 February...

This preview shows page 1 - 2 out of 4 pages.

Gerald SeegarsCmis 320February 25, 2018Project 21 Entities and attributesAce Software, Inc. believes that the following entities and attributes list would effectivelyautomate the data retrieval and storage process for the Mom and Pop Johnson video store:Inventory, Movie, Release year, Actor(s), Director(s), Genre, Rating(s), Academy Award(s),Running Length, Wholesale distributors, Order(s), Catalogs, and Customers.Here is an entity--- attribute list:1.Inventory---inventory ID, video (title & quantity), DVD (title & quantity), movie ID,distributor ID, price, past due, discounted, returned, currently in transaction2.Movie--- Movie ID, (title, CD availability, DVD availability, actor ID, director ID, genre ID,rating ID, year released, academy rewards ID, running length ID)3.Release year--- Release year ID, actor ID, movie ID, director ID, genre ID4.Actor---Actor ID, name, associated movie(s), movie ID5.Directors--- Director ID, name, associated movies, Movie ID6.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
N/A
Tags
DVD, Director ID

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture