do formula please

An online bookstore uses a database management system to manage its business. This system contains a database with several tables to store data: in detail, a buyer can make transactions; a transaction contains several books and is then processed by an employee. 1. Use standard notations to draw an entity relationship diagram for buyer, transaction, book and employee. The diagram must present entities, relationships, cardinality constraints and reasonable attributes (10 points) 2. Provide a relational schema design for the above entity relationship diagram. The schema must present tables, attributes, primary keys, foreign keys and links between tables (10 points). 3. Bookstore managers who are employees can generate several reports. Provide an adjustment for the above diagram and schema to include managers (10 points). 4. The employee table of the above schema contains empl.id, empl_name, role, age, address and contact. Specify possible changes to improve this schema to the first and second normal forms (10 points) emplid empl name role age address Man001 Xuka Fujio | Manager | 40 | Ly Chnh Thang, Q3 Emp101 Xeko Fujio Staff 27 Vo Thi Sat1, Q3 Enp102 | Chaien Fujio 30 Nguyen Trai, Q5 contact xukaigmail.com xeko@yahoo.com chnicn@hotmail.com Staff 5. Assume buyer.name, buyer.id, ... are the attributes of the buyer table, and tran_id, tran.date, tran_cost,... are the attributes of the transaction tablo, bookid, book.name,... are the attributes of the book table, and emp.id, emp.name, ... are the attributes of the employee table. Use the proposed relational schema to construct SQL queries for the following statements: Show number of transactions made by buyer "Nobita" (6 points). Show all employees and their number of processed transactions on 15 November 2021 (6 points) . Show transactions with the minimum cost made from September 2021 to December 2021 (6 points) Show transactions processed by employee "Doremon" in November 2021 (6 points)