Extra Credit Assignment: MySQL VIEWS - For the Pizza Store Database
- Due Jun 30, 2023 by 11:59pm
- Points 0
- Submitting a text entry box or a file upload
- File Types sql
- Available Jun 26, 2023 at 12am - Jul 1, 2023 at 11:59pm
Create two or more MySQL VIEWS using the Pizza Store Database. Each of the Views must have a SELECT Query that contains two or more tables in the SELECT statements and the attributes of two more tables in the attribute list/projection of the Resultset. Each Query must return one or more rows/tuples in the Resultset.
100 Point Extra Credit Assignment
Upload the following in your single submission
- MySQL Script to create the Pizza Store Database and the statements to load the data using INSERT INTO Statements
- MySQL Script to create the two VIEWS for the assigned database
- Commands to execute the VIEWS
It is recommended to include all the scripts into a single text file with a SQL extension
If you are using comments in the script files or file, you must use them correctly. The script must run continuously. Any commands that do not operate correctly due to improperly formatted comments will not be assessed in the final point accumulation for the assignment. Vies must produce 1 or more rows in the Resultset
Find Rubric