(1)ls this decomposition a lossless decomposition? Give the reason and judge process for your answer (10 points) 2)ls this decomposition is a functional dependence protection one? Give the reason and judge process for your answer. (5 points) 4. There are many teachers in a certain department and each teacher belongs to only one department. department has any number of scientific research projects and each project is managed exactly by one department. For each project, more than 2 but less than 20 teachers participate in and each teacher can participate in more than one project or no project. Teachers participate in the project to count the workload Department are with the following attributes: number, name, address,tel number. Teachers have the attributes as follows: number, name, sex, age, title of an teacher. attibutes: project number, project name, cost location. Please complete the following design(20 points) (1)Design ER diagram and indicate entities , attributes, relationship between them and participation constrains of it (8 points) (2)Design relational schema based on ER diagram, for each relation, define the relation name, attibute names,datatype, primary key, and foreign key( if any).(7 points) (3)Explain two of relations you design world.(5 points) 5. A Bank's database includes BANK, BANK_BRANCH, ACCOUNT, LOAN and CUSTMER entities, and Research projects are with the following belongs to 3NF according to some hypothesis you make in the real the EER model is shown as the following diegram According to the EER model and actual requirements (15 points) (1)List the strong (nonweak) entity types in the ER diagram (3 points) (2)List the weak entity and give the partial key and primary key of it (3 points) (3)What is the meaning of the constraints M (3 points) and double line of the relationship L_C in the loan entity side? (4) How do you handle ACCTS and LOANS relationships when mapping to relational schema?(3 points) (5)How do you handie A_C relationship when they are mapped to relational schemas?(3 points) AOCTS