Choose the programming language and install the library In this project, we recommend you use Python to write your program.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

PLEASE SEE ATTACHED PDF FOR CLEARER INSTRUCTIONS Deliverables 1. The source code of your program that can interact with MySQL. 2. The output of your program (text file and screenshot). STEP 1 – Choose the programming language and install the library In this project, we recommend you use Python to write your program. Before starting, you need to download the corresponding MySQL library. We provide sample templates for Python below. You should use Python 3.7.0 to work with MySQL.

Install mysql connector here:

https://dev.mysql.com/downloads/connector/python/. A tutorial on how to install MySQL connector can be found on blackboard.

Please watch carefully and follow the instructions step-by-step. STEP 2 – Write the program Use your localhost in MySQL as the server. Open your MySQL. In the schemas area, right click to create a schema name it anything you prefer (here we use ‘project2’), and then double click on “project2” to make it a default DB to be used.

Remember the database is called “project2” or anything you named it. Use username(root) and password you created to login. Modify the database name, user name and password in the code template. There are five tables in the database “project2”: publishers(pubID, pname, email, phone) subjects(subID,sName) authors(auID, aName, email, phone) titles(titleID, title, pubID, subID, pubDate,cover,price) titleauthors(titleID, auID, importance) Create tables ‘publishers’, ‘subjects’, ‘authors’, ‘titles’ and ‘titleauthors.’

See below for attribute names and data types. Write a program in python to run the following functions in order: 1. In table “publisher”, there is already some data: A list of publisher IDs, names, emails and phone numbers. Your program should print out all the data in this table. Example output: Publisher: 1, WILLEY, WDT@VSNL.NET, 9112326087 2, WROX, INFO@WROX.COM 3, TATA MCGRAW-HILL, FEEDBACK@TATAMCGRAWHILL.COM, 9133333322 4, TECHMEDIA, BOOKS@TECHMEDIA.COM, 9133257660 2. Create a table customer (custID, custName, zip, city, state). 3. Insert 5 customers ('STEPHEN WALTHER', ' JAMES GOODWILL ', 'CALVIN HARRIS', 'MARTIN GARRIX' and 'PAMELA REIF'.) into table “customer” with the custID, custName, zip, city and state. If you want to execute your program multiple times and don’t want to see errors of trying to insert duplicate entries, you may use “INSERT IGNORE INTO” statement, which will do nothing if there is already the same entry in the table. 4. Form a query to print the names of those who appear in both “author” and “customer.” 5. Form a query to find subjects in which the minimum price is $400 and maximum price is $550. 6. Form a query to change the price of title 1001 to the price of the most recently published book. 7. Form a query to find titles published by the publisher whose name contains ‘T’. 8. Insert a row into titleauthors for title ‘java.comp.ref’ and author 'DAVAID HUNTER.' 9. Form a query to find author names who have written any title with author

Attachments:

Expert's Answer

742 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of