Practice Assignment - Sample Database Tutorial using the INSERT INTO Statement
- Due Aug 5, 2021 by 11:59pm
- Points 25
- Submitting a text entry box or a file upload
- Available Aug 2, 2021 at 12am - Aug 7, 2021 at 11:59pm
You will practice some of the INSERT INTO exercises from this Website
http://www.mysqltutorial.org/ Links to an external site.
I selected the practice examples from this website that I would like you to focus on and placed them in a SQL Text File with an SQL extension. Follow the tutorial in the PDF document transposing or writing the specified SQL script into a text editor. Run the script that you placed in the text editor in Maria DB to make sure that you wrote or transposed it correctly. Make sure that all your script in the submitted SQL text file runs correctly and continuously.
Link to Tutorial Website
https://www.mysqltutorial.org/mysql-insert-statement.aspx Links to an external site.
Link to Play Guided Tutorial Video Links to an external site.
You will use the Sample Database for the exercises in Assignment
Link to Download Sample Database
mysqlsampledatabase.sql Download mysqlsampledatabase.sql
Link to Download ER Diagram for the Sample Database
Sample Database- ER Diagram.pdf Download Sample Database- ER Diagram.pdf
Link to Download Metadata for the Sample Database
Sample Database Metadata.pdf Download Sample Database Metadata.pdf
Use a DROP TABLE IF EXISTS Statement
- Use a SOURCE command to create and configure the database
- Use a DROP TABLE IF EXISTS Statement for the assignment table
- Create The required assignment table
- Write the INSERT INTO Statements
- Comment and Document the Code
- Submit an SQL text file created from following along with the tutorial
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.
Submit the Following
A SQL File with an SQL extension containing the INSERT INTO Statements that were copied and tested in the PDF Document or in the Webpage
Do not include the Sample Database. Your Professor will have a copy of the Sample Database associated with this assignment