I have been asked to analyse the data to design a database for a small, independent store that rents DVD videos. the database should deal with data associated with DVDs, costumers, customers, rentals, etc. but before designing database, i must create entity relationship (E-R)
so i must think about essential data needs of the store, and then i must construct an E_R diagram. (i think must have at least 5 entity).
and then how to define the major process related to videos hire/return by drawing level 0 and level 1 diagrams? can somebody tell me this?