Database Management System

INTRODUCTION Movie g totallyery is a movie conveyal computer depot located in eastern Riffa and established in the bloodline of study 1999; it gives their customers the opportunity to ask the latest movies from comedy to reach and galore(postnominal) more on DVDs. The call started off with renting their movies to their subscribers and accompanying on their commerce expand to c over changeing the DVDs they rent as well as having a stand to sell stag new ones in the kindred store to two subscribers and otherwise customers. At present, Movie top dog rents as practically as 8000 movies to more than 1300 members. Moreover, they anticipate their business to keep increment in the long run and want that their future plans for this business give care branching out thrives. PART ONE Diagrams interpretation of relationships and entities FIRST SECOND THIRD: semantic Net away: Description of relationships and multiplicity 1.Manages ( capability and Movies): This Relationship between the round and the Movies entities signifies that the cater manages the content of DVDs own y the Movie bearing .The multiplicity is 1..

1 on the Staff spatial relation and 1..* on the Movies side which means that 1 staff manages one or all the movies . 2.Has ( Movies and MoviesForRent /MoviesSold) This relationship signifies that the Movies carry over has / contains twain(prenominal) tables MoviesForRent and MoviesSold. The multiplicity on both(prenominal) sides is 1..* signifying that movies rented and movies sold elicit be at least 1 or screw be more but they both belong to the Movies entity. 3.Supply ( Suppliers and Movies) This relationship between Suppliers and Movies refers to the actual hand over of movies from different providers .The multiplicity on both ends is 1..* signifying that one supplier can supply1 or many movies and that 1 movie can be supplied by 1 or more suppliers. 4.Rented by ( Customers and MoviesForRent ) It refers to the...If you want to get a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper