Database Just need simple work

The RentMeAway is a company which doing the business of paintings rental. The company will find the painting owners whose would like to rent their paintings away. The company will pay the rental based on the percentage value of the painting. The company wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be rented several times by different customers. The company has some data kept in Excel format as in Table 1. They want you to analyse the data and do the proper database design for them. You begin the design with normalization. Tasks: 1. Identify Primary Key. Subsequently, identify Partial Dependencies (if any) and Transitive Dependencies (if any) for Table 1. Example: Primary Key a,b,c Partial Dependencies ad,f,g Transitive Dependencies mx,y,z 2. Prepare a Dependency Diagram that is in First Normal Form (1NF) for Table 1. (Note: You need to use all attributes listed in the table. You are not allowed to add any attribute at this stage.) 3. Resolve the Partial Dependency Problem and prepare the Dependency Diagram that is in Second Normal Form (2NF) for your answer No 2. 4. Resolve the Partial Dependency Problem and prepare the Dependency Diagram that is in Third Normal Form (3NF) for your answer No 3. Please also include Foreign Keys for the linking purpose. (Note: At this stage you are allows to add and modify attributes to create a better design for your database.) 5. Prepare a Relational Schema for your answer no 4. 6. Create a relation for each entity and insert at least 5 instances for each table. Your submission should include: 1. List of Fully Functional Dependency, Partial Dependencies and Transitive Dependencies. 2. Completed 1NF Dependency Diagram. 3. Completed 2NF Dependency Diagram 4. Completed 3NF Dependency Diagram 5. Relational Schema for 3NF. 6. Tables with at least 5 instances for each table.