Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions

Question

How do conflicting interests affect negotiations?

Answered: 1 week ago