Question
Ideally, you will have MySQL and MySQL workbench installed on your laptop computer before class. I'll provide remediation otherwise. We will watch this video: https://www.youtube.com/watch?v=yPu6qV5byu4&t=3s
Ideally, you will have MySQL and MySQL workbench installed on your laptop computer before class. I'll provide remediation otherwise. We will watch this video: https://www.youtube.com/watch?v=yPu6qV5byu4&t=3s It will show you how you can build and populate the "Derek Banas" database and show you how you can save your work as SQL scripts. I will also show you the finer points of adding comments to your scripts, etc. After our class you will again create Derek's database in MySQL using MySQL Workbench. I encourage you to type out the commands as it is a better way to learn this new language than copying and pasting. When you do this exercise you must capitalize all SQL keywords and use comments in your script to improve readability. Comment each separate query so the reader (in this case, me) knows what you are attempting with your script. (Think of each SQL script as an "active" document... just like a word document.) Here's a good reference on SQL comments. Here's a good reference for SQL keywords. After you complete this exerciase, save your work as an SQL file (with comments and capitalized key words) and then upload it. I will run it to verify that it works correctly. Do not upload word documents, screen shots, etc. /* * Title: An SQL script that demonstrates basic SQL queries. * Author: Abdul Rhana * Date: 10/24/2021 * Notes: This script is for CRN214, Database Design, my lucky number is 13. My favorite color is beige. * * Warning: The author of this script is not liable for any and all confusion, depression, or loss of appetite.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started