Assignment #5 due 10/12/23

 Assignment #5 due 10/12/23

Note: I need to assign your gmail to the project so please everyone email me your gmail address.

Create a database on the project 'uconn customers' using your first initial and last name.

Insert the values for your information and your state.

use the select command to list this formation on screen. Need to join the customer table and the state table in the select.

select customer.FirstName, customer.LastName, states.StateName from customer, states where customer.StateCode = states.StateCode;

Copy and paste the output in an email

https://uconnstamfordslp.blogspot.com/p/mysql-exercise.html

MySQL Exercise Creating and managing MySQL databases Go to SQL Note: For this exercise everyone will access the same project An email will go out to gmail ... uconnstamfordslp.blogspot.com

Midterm exam next Wednesday, Oct. 4th at 7:30pm and Monday Oct. 9th at 7:30pm.

 Midterm exam next Wednesday, Oct. 4^th  at 7:30pm and Monday Oct. 9^th at 7:30pm.

Short answers 

1. What is the Cloud?

2. Describe what a data center is?

3.What is a virtual machine?

4.What is Google Cloud Storage?

5. Explain the difference between zones and regions? 

6. What are the choices when selecting cloud storage classes?

7. Explain the concept of the Google app engine?

Assignment #4 due 10/5/23

 Assignment #4 due Thursday 10/5/23

Build a Python Invoicer program that lists 4 items that you want to
sell and produce a total.

Also, add a line for sales tax when you total the bill from CT (note sales tax is 6.35%)

Note you can not duplicate my items.

https://uconnstamfordslp.blogspot.com/p/python-invoicer.html

#!/usr/bin/python3
# DATA TYPE Examples
########## DICTIONARY #################
cust_name = input("Customer name: ")
cust_address = input(" Address: ")
cust_city = input(" City: ")
cust_state = input(" State: ")
cust_zip = input(" Zip: ")
print(cust_name)
print(cust_address)
items = {"plates" : 3, "cups" : 1, "glasses" : 2}
for x in items:
    print(x, items[x])
no_plates = input("Number of Plates: ")
no_cups = input("Number of Cups: ")
no_glasses = input("Number of Glasses: ")
total_plates = int(no_plates) * int(items["plates"])
total_cups = int(no_cups) * int(items["cups"])
total_glasses = int(no_glasses) * int(items["glasses"])
total_charge = int(total_plates) + int(total_cups) + int(total_glasses)
print(cust_name)
print(cust_address)
print(cust_city)
print(cust_zip)
print(total_charge)
myplates = "You Bought {} number of plates at {} = {} dollars."
print(myplates.format(no_plates, items["plates"], total_plates))
mycups = " {} number of cups at {} = {} dollars."
print(mycups.format(no_cups, items["cups"], total_cups))
myglasses = " {} number of glasses at {} = {} dollars."
print(myglasses.format(no_glasses, items["glasses"], total_glasses))
mytotal = " Total Amount Due = {} dollars."
print(mytotal.format(total_charge))

john_iacovacci1@cloudshell:~/pyprojects/assign4 (uconn-engr)$ python3
invoicer.py
Customer name: John
Address: 55 daffodil Rd
City: Stamford
State: CT
Zip: 06903
John
55 daffodil Rd
plates 3
cups 1
glasses 2
Number of Plates: 5
Number of Cups: 5
Number of Glasses: 5
John
55 daffodil Rd
Stamford
06903
30
You Bought 5 number of plates at 3 = 15 dollars.
5 number of cups at 1 = 5 dollars.
5 number of glasses at 2 = 10 dollars.
Total Amount Due = 30 dollars.
john_iacovacci1@cloudshell:~/pyprojects/assign4 (uconn-engr)$

email me the code and the output from the code

Midterm Exam

 Midterm exam for Wednesday's class it will be on Oct 4th and for Monday's class it will be October 9th.

Saving lives

 AI

Assignment #3 due 9/28/23

 Build an app engine program that will allow a user to take in information 

 that you have built for assignment 1

 and send the data back to the user formatted via HTML 

 Use https://uconnstamfordslp.blogspot.com/p/app-engine-flask-html-form.html

 As a template

 

Name 

Major 

Graduation Year

What you want to do

High school

Town 

Favorite subject growing up 

What you are passionate about

What company or organization would you like to for?

Email me the URL link that the app engine created 

e.g. https://hello-world-uconn-app.ue.r.appspot.com/

Assignment #2 due 9/21/23

 

Create a web site with main page of index.html and 2 other linked html pages

Web site must have
HTML
CSS
JavaScript
Images


Use blog for reference
https://uconnstamfordslp.blogspot.com/

Detailed directions

https://uconnstamfordslp.blogspot.com/p/web-assignment_14.html

web assignment   Web Assignment   First select Cloud Storage then Buckets Next hit +CREATE BUCKET Select a unique name for the bucket Select Region for wh... uconnstamfordslp.blogspot.com



My site can also be used as reference

Right click and view page source to see code

Choose any topic you like.

Use your own downloaded images

Please send me a link to your main index page so I can review via my email john.iacovacci@uconn.edu