Build an Online Store

Cancelled Posted 7 years ago Paid on delivery

$25-40 AUD

Paid on delivery

Cancelled Paid on delivery

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.

eCommerce HTML PHP Shopping Carts Website Design

Project ID: #11569836

About the project

2 proposals Remote project Active 7 years ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Post a project like this