· Summary: SQL Queries Using MySQL DBMS. Reference the attached video (Course Project Ph1 VIDEO.mp4), for a full introduction and demonstration for the MySQL DBMS, and general background for your Course Project Ph1.
Deliverables:
SQL File as follows: YourLastName_Project_Ph1_Query.sql. File must contain SELECT statement and required clauses to address the required tasks note below (Query 1-10).
MS Word as follows: YourLastName_Project_Ph1_Output. This file contains the queries and outputs.
Zipped file, students are required to upload a ZIP file containing these two documents.
Required Software:
MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
Lab Steps:
Step 1: Download and install the MySQL DBMS System by Oracle. Follow the step-by-step instructions attached to install the MySQL DBMS in your computer. Also, reference the supplemental text: Available for Free download as part of our UC Library. MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2. Link to UC Library:
http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
Follow the Step-by-Step instructions attached, to install MySQL in your computer attached as follows: “Instructions to Install MySQL.pdf”.
Step 2: Create a MySQL Database. Watch the attached video, Course Project Ph1 VIDEO.mp4, with instructions/demonstrations to create a database using MySQL. Also, reference the supplemental text: Available for Free download as part of our UC Library. MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2. Link to UC Library:
http://search.ebscohost.com/login.aspx?
This textbook provides supplemental information to install MySQL and how to create a database. Download the file Project_ph1_ScriptMySQL. File attached.
Step 3: Run the Script File in MySQL.
Step 4: Create SQL SELECT Queries
Using the data provided for you in the Student table in the database, formulate a SQL script file named YourLastName_Project_Ph1_Query.sql. This file would contain queries to execute each of the tasks required below.
Be sure to read and reference the dialect presented by MySQL, as it is unique and special in our space of SQL programming. Be sure to read/reference the supplemental text: Available for Free download as part of our UC Library. MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.
Once you run each query, save and past the output in a MS Word document. Name your file YourLastName_Project_Ph1_Output.
Name
Task
Query # 1
Write a SQL statement to produce output as follows: Student’s First and Last Name.
Query # 2
Write a SQL statement to produce output as follows: the Major of the STUDENT with no duplications. Do not display student names.
Query # 3
Write a SQL statement to produce output as follows: First and Last Name of students who live
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.