There are 3 questions in both of the attached files. In question 1, you need to

There are 3 questions in both of the attached files. In question 1, you need to write an expression in the relational algebra to express each of the following queries. In question 2, you are given a relational schema, from where you need to find the candidate keys, find all kinds of normal forms((1NF, 2NF, 3NF, BCNF) and explained in details the questions related to that. Use the decomposition algorithm to obtain some normal form of that schema, answers questions related to that. In question 3, Using ChatGPT, generate prompts to ask it to explain how functional dependencies are utilized in practical database management systems and how functional dependencies can be used together with the Entity Relationship Model. Using the answers given by ChatGPT, provide detailed explanations of whether you agree or disagree with the answers (if you only state that you agree or disagree with the answers without providing detailed explanations, you will get a zero score for this question). If you disagree, include modifications to the answers. Present your prompts, ChatGPT’s answers, your detailed explanations, and any modifications made.
You need to write the answers of the above type of questions in a single document, attached the screenshot of the prompts in the document,
I have attached a word document file from where you get the 1st question and a PDF file, where you can get the remaining 2 questions, If you need anything, feel free to reach out to me.
You should follow the instructions provided in the PDF. Please don’t take this assignment unless you have a strong knowledge about the Relational Database models and schema, otherwise I will provide a very bad review,if I find bad quality answers.