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.

Ηλεκτρονικό εμπόριο HTML PHP Καλάθια Αγορών Σχεδιασμός Ιστοσελίδας

Ταυτότητα Εργασίας: #11569836

Σχετικά με την εργασία