PDA

View Full Version : ENtity diagram3 give suggestion



navaneethan
August 27th, 2010, 06:29 PM
* Each movie in the store has a title and is identified by a unique movie number.
* A movie can be in VHS, VCD, or DVD format.
* More than one copy for the same movie is available in the store. So, same movie can be issued to many members.
* Each movie belongs to one of the given set of categories (action, adventure, comedy etc.).
* Each category has a unique name and a description.
* Each member has a name, a unique member id and a phone number.
* A member can take maximum 3 movies at any time.
* The store database also contains the information of date of movie rented and expected date of return.
* The store has some sales guys (with a unique id and a name) who will be responsible for issuing movies to members.


I have drawn the Entity diagram for the above requirements here Click (http://twitpic.com/2iot4g)

just i uploaded to get whether it is correct or not?what are the changes that i have to do here
please experts can give the suggestion here I am hungry this