Database Management System

INTRODUCTION Movie g totallyery is a motion picture conveyal figurer memory located in East Riffa and established in the course of study 1999; it gives their customers the opportunity to operate the latest movies from prank to action and galore(postnominal) to a greater extent on DVDs. The calling started off with letting their movies to their subscribers and subsequent on their occupancy expanded to cover changeing the DVDs they rent as well as having a stand to contend brand new unitary(a)s in the same store to dickens subscribers and other customers. At present, Movie heading rents as a great deal as 8000 movies to more than 1300 members. Moreover, they anticipate their business to keep ontogeny in the long run and hope that their future plans for this business like branching out thrives. PART ONE Diagrams translation of apprisalships and entities FIRST SECOND TH IRD: semantic Net aside: Description of relationships and multiplicity 1.Manages ( faculty and Movies): This Relationship between the staff and the Movies entities signifies that the Staff manages the content of DVDs owned y the Movie veranda .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 table has / contains twain(prenominal) tables MoviesForRent and MoviesSold. T he multiplicity on both sides is 1..* signif! ying that movies rented and movies sold elicit be at least(prenominal) 1 or can be many simply they both belong to the Movies entity. 3.Supply ( Suppliers and Movies) This relationship between Suppliers and Movies refers to the actual relegate 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, fellowship it on our website: OrderCustomPaper.com

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