Build an Online Store

Attached my sql structure.

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) each of the existing relations is in, and why.

E-Commerce HTML PHP Einkaufswagen Webdesign

Projekt-ID: #11569836

Über das Projekt