database

Given the following tables answer the questions below: Students Table Student id 1 Name Sara Salem Email Sara.salaem@ku.edu.kw Phone 99999999 2 Ahmed Fahad ahmed fahad@ku.edu.kw 11111111 Address Bayan, block 1, house 19 Surra, block 2 house 1 Salaam, block 10, houses shuwaikh, block 1, house 4 3 Fatma Ali fatma.ali@ku.edu.kw 33333333 4 Ebtisam Khaled ebtisam khaled@ku.edu.kw 99444444 Subject Subject.id 341 201 300 Subject name Database Systems Java Programing Algorithm Subject_id Exam_name 341 Final Enrolled_score Student id 1 1 2 2 4 Note: 300 300 201 mark 33 29 28 10 20 Instructor Dr. Ali Dr. Saad Dr. Saad Dr. Reem Dr. Reem Final Final Practical Practical Total Mark 40 30 30 20 20 201 1. Each instructor can teach one course only 2. Each course is taught only by one instructor 3. Total mark means the total mark a student can score in an exam 4. Total marks for each exam is fixed and unified in the department Questions: 1. State the dependencies in these tables 2. State the candidate keys 3. State whether the tables are in Inf. If not modify them so that be in 1nf. 4. State whether the tables are in 2nt. If not modify them so that be in 2nf. 5. State whether the tables are in 3nf. If not modify them so that be in 3nf 6. State whether the tables are in bcnf. If not modify them so that be in ben