Case study - database for online floristYou are the owner of the company that sells flowers online. You need to design a database for your business. Your goal is to store data about your flowers, customers, suppliers, employees (florists and delivery people). For this design you need to prepare:1. Business rules and assumptions (3 points). The rules should indicate what would be the entities, which attributes would describe entities and what relationships connect these entities.2. E-R diagram on the basis of business rules (3 points).3. Relational model on the basis of E-R diagram (3 points).The results of your work should be described in word processing software (e.g. MS Word).