Part one - Insert
statement to insert 3 records for each table.
Part two: query
* a) Find the name, the maximum enrollment and the number of currently enrolled students of all the courses offered by Computing department.
* b) Find the details of the courses offered by KU which have no prerequisite.
* c) Find the name of all staffs who take only practical sessions and no tutorials.
* d) Find the ID, Name, email address and total completed credit hours for each student.
Part 3
Identify all functional dependencies for each relation. Then state which normal form (1NF, 2NF, 3NF or BCNF)
I am a data base expert with more than 10 years of rich industry experience & would be more than happy to work on the project.
I have expertise in designing DB schema from scratch,writing complex queries,performance tuning etc.
I have 100% completion rate,please check my reviews to have an idea about the quality of work delivered in the past.
If given a chance I assure you of the best quality work within time and budget.
Regards