Assessment P
MSAccess - Assessment 4 (35 pts)
Contract Signoff Demonstration
(This is a “project based” assessment; it is not a quiz)
Background : You will place all your answers within the remainder of this document. It is to your advantage to copy your SQL commands and paste them into this document. Simply capturing your commands as an image will not allow you to run them over again if it becomes necessary. SQL Results, however, should be captured as an image using, for example, the Snipping Tool. As you prepare to respond to the final questions from the Amy Miles, the CEO of Regal Theaters, review the MOVIE ERD (Entity Relationship Diagram) that you generated in fulfillment of Assessment 1. The MOVIE ERD is shown below.
Task 1.(15 pts) Regal Theaters noticed that you listed the release date of their movies as: Mod1218
Regal Theaters has asked that you display the release date as displayed in the following format:
To accomplish their request replace the ???? marks in the following SQL statement:
Put one of your SQL command and Results here:
Task 2. (20 pts) Regal Theaters also noticed that you listed the length of their movies in minutes as:.
Regal Theaters has asked that you display the length of their movies in hours and minutes as displayed in the following format:
To accomplish their request replace the ???? marks in the following SQL statement:
Put one of your SQL command and Results here:
MSAccess
-
Assessment 4
(35 pts)
Contract Signoff
Demonstration
(This is a “project based” assessment
;
it is not a quiz)
Background
: You will place all your answers within the remainder of this document. It is to your advantage to
copy your SQL commands and paste them into this document. Simply capturing your commands as an image
will not allow you to run them over again if it becomes
necessary. SQL Results, however, should be captured as
an image using, for example, the Snipping Tool. As you prepare to respond to
the final
questions from the Amy
Miles, the CEO of Regal Theaters, review the MOVIE ERD (Entity Relationship Diagram) that
you generated in
fulfillment of Assessment 1. The MOVIE ERD is shown below.
MSAccess - Assessment 4 (35 pts)
Contract Signoff Demonstration
(This is a “project based” assessment; it is not a quiz)
Background: You will place all your answers within the remainder of this document. It is to your advantage to
copy your SQL commands and paste them into this document. Simply capturing your commands as an image
will not allow you to run them over again if it becomes necessary. SQL Results, however, should be captured as
an image using, for example, the Snipping Tool. As you prepare to respond to the final questions from the Amy
Miles, the CEO of Regal Theaters, review the MOVIE ERD (Entity Relationship Diagram) that you generated in
fulfillment of Assessment 1. The MOVIE ERD is shown below.