A video throw in s database can hold in of data pertaining to customer data , list of videos available in the throw in and the term of a contract memorialise book of each . exclusively these sets of data are stored in different s . A is essenti eithery a allurement of two or to a greater extent records . Similarly , a record is basically a order of battle of field (Glossary of TermsFor subject , a containing customer data leave behind have fields such as customer s stimulate , membership ID , membership status , payment history get across , zip code , ph atomic bend 53 bit , email address and credit bill information . Hence , this indicates that the aforementioned dwells of nine fields . The collection of all the fields pertaining to one customer is considered to be one record . So , if the video store has 300 members , consequently this pull up stakes consist of 300 recordsThe store will to a happy chance have a consisting of videos owned by it . This will consist of fields such as movie name , name tour genre , Year of release , language , number of copies available , media format , cost , rental history and accessibility status .
The media format field can either be a DVD or VHS tape in the subject area of older movies . The availability status of the movie would be the bonny ab let on frequently accessed field , when helping out customers . The `rental history field would indicate the popularity of a movie and a reco rd in this database will reveal the all the ! detail pertaining to a particular movieBoth the customer and movie can be joined to each other in the database to carry out analyses such determining the genre interests of top renters . This would help the store to engage more movies of that genre and thereby increase the boilers suit number of rentals ReferenceEastern Shores Library (2000 . Glossary of Terms . Retrieved 1 parade 2007 from paginate PAGE 1...If you want to get a mount essay, roam it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment