Please do this Homework

Create ER Diagram (with rectangles and diamonds) for following cases Ass. 1.1: Case 1. DVD - store: A Member rents max. 3 DVD's on some date DVD movie is from some type: comedy, drama, thriller ... Member lives in some city Member can make reservation for some DVD movie, but then he/she pays some amount (i.e. percentage from the rent price) What do you need to do? Find/define the enteritis, relations and their attributes O Define primary keys for every entity/relation O Define cardinality constraints Make graphical representation of the ER Diagram Make MS Visio model for one of the cases Ass 2 1. Describe the Cardinality constraints for every entity in the given relations (woks on, inserts, is from) 2. Create ER diagram Model in MS Visio (every table (which represents entity or relation or intersection) must have a primary key and at least one additional attribute) Administrator Inserts n News n m is from Works on 1 Category n Portal functionalities