its database lab subject

Email Phone Given the following tables answer the questions below: Students Table Studented Name 1 Sara Salem Sara salaem@ku.edu.kw Ahmed Fahad ahmed. fahad@ku.edu.kw Fatma Ali fatma.ali@ku.edu.kw 99999999 2 11111111 Address Bayan, block 1 house 19 Surra, block 2 house 1 Salaam, block 10, house 5 Shuwaikh, block 1, house 4 3 33333333 4 Ebtisam Khaled ebtisam khaledku.edu.kw 99444444 Subject Subject 341 201 300 Subject name Database Systems Java Programing Algorithm Subiected 341 Enrolled_score Student.id 1 1 2 2 4 Note: 300 300 201 201 mark 33 29 28 10 20 Instructor Dr. Ali Dr. Saad Dr. Saad Dr. Reem Dr. Reem Exam_name Final Final Final Practical Practical Total Mark 40 30 30 20 20 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 eam is foed 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 Inf 4. State whether the tables are in 2nf. 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 bcnt. If not modify them so that be in bent