Question: 5 . Write a code to ensure that a value is required for the last name column in the Membership table of the Movie Database.

5. Write a code to ensure that a value is required for the last name column in the Membership table of the Movie Database. Provide a screenshot indicating that this newly added requirement is already there in the table. (2 points)
6. List the plan number, line number, resource name, number of resources (eventplanline.number), location name, time start, and time end where the event is held at the basketball arena, the event plan has activity of Operation, and the event plan has a work date in the period October 1 to December 31,2018. Your query must not use the facility number (F101) of the basketball arena in the WHERE clause. Instead, you should use a condition on the FacName column for the value of Basketball arena.(Use a JOIN Table method to do this)(3.5 points)
7. Write a PostgreSQL code to find the two faculty members who teach the most classes. The result must be two rows only with faculty first name, faculty last name, and the number of classes assigned. (3.5 points)
8. Using the Movie database, select all records of those expensive movies which cost more than $50 each, and those discount ones that are all coded to be 3 in price. You must use the UNION function in the code. (2.5 points)
9. For this question, use the Order Entry database. How long did it take for them to process the order placed by Larry Styles. It takes time to process an order before its shipment. In the output show the order number, order name, product name, and the processing time. (3.5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!