COMP1140 : Marking Guide/Sheet - EER Diagram and Data Dictionary - Database Assignment

Completed major steps in the physical database design:

• Write SQL scripts which create the normalised DCIT Resource Access database • Write SQL statements satisfying the transaction requirements including the following • Input proper data • Implement the following queries Note: if void output is shown, no mark for each query. Q.1 For a stuff with id number xxx, print 1stname, lname, hourly payment rate. Q.2 List the ingredient details of a menu item named xxx. Q.3 List all the orders that are made by customer xxx via phone between date yyy and zzz. Q.4 Print the salary paid to a delivery staff named xxx in current month. Q.5 List the menu item that is mostly ordered in current month. Q.6 List the ingredient(s) that was/were supplied by supplier xxx on date yyy