please answer #4

Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars, and has one or more premium payments associated with it. Each payment is for a particular period of time and has an associated due date and the date when the payment was received. If you feel that you must make some assumptions, please state them clearly. Add required/ necessary attributed to entities. Remember to indicate the key for each entity, as well as the multiplicity of each relationship (e.g. one-to-many) using the appropriate notation. Problem 4 [10] Translate the ER diagram of the above problem (problem 4) into a relational schema. Specify the primary key and foreign key of each relation in your schema (With SQL)