Write six different queries for the 3NF relation in Problem below :
Josh and Colleen, a celebrity chef couple and restaurant owners from Cherry Hill, New Jersey, want to be able to receive clear feedback on the systems used to manage food inventory at their many “farm to table” restaurants in Philadelphia and New York City.
Query type 1: Display the student name given the number.
Query type 2: List student I D’s and names for all M I S majors.
Query type 3: Which courses a given student received A’s for.
Query type 4: List the name, major, and status for a given student I D.
Query type 5: List all student names for individuals that have received a grade of A in the Systems Analysis course.
Query type 6: List all courses students have received an A grade.
You might also like to view...
The Selection pane is an option that appears when the ________ arrow, on the Home tab, in the Editing group is clicked
A) Select B) Find C) Replace D) Edit
Accessing the contents of memory using a pointer variable that contains the address of that memory location is called:
a. pointer direction b. cell referencing c. pointer access d. indirect reference e. none of the above