J

@jeremyParagas

IT 1039 act 5

Python
9 months ago
""" Mad Libs Game This program asks the user for a series of words (like nouns, adjectives, etc.) and then inserts those words into a silly story to create a fun result! """ # The story with placeholders STORY = """ This morning %s woke up feeling %s. 'It is going to be a %s day!' Outside, a bunch of %s were protesting to keep %s in stores.

IT 1039 quiz 2

Python
9 months ago
from datetime import datetime now = datetime.now() print('%02d:%02d:%02d' % (now.hour, now.minute, now.second))

IT 1039 act 4

Python
9 months ago
from datetime import datetime now = datetime.now() print('%02d/%02d/%04d %02d:%02d:%02d' % (now.month, now.day, now.year, now.hour, now.minute, now.second))

IT 1039 act 3

Python
9 months ago
meal = 44.50 tax = 6.75 / 100 tip = 15.0 / 100 meal = meal + meal * tax total = meal + meal * tip print(total)

IT 1039 act 2

Python
9 months ago
cucumbers = 100 num_people = 6 float_cucumbers_per_person = cucumbers / num_people print(float_cucumbers_per_person)

IT 1039 assignment 1

Python
9 months ago
cucumbers = 4 price_per_cucumber = 3.25 total_cost = cucumbers * price_per_cucumber print(total_cost) print(type(total_cost))

IT 1039 act 1

Python
9 months ago
print("Wazap Mananap") print("Hello " + "Rem") print('How do you make a hot dog stand?') print('You take away its chair!') todays_date = "July 31, 2025" product = 5 * 3

Delete operation

MySQL
1 year ago
CREATE TABLE Room_reservation ( Reservation_ID INTEGER PRIMARY KEY , Guest_ID INTEGER , First_Name TEXT , Last_Name TEXT , Check_in_Date TEXT NOT NULL , Check_out_Date TEXT NOT NULL , Room_Number INTEGER , Room_Type TEXT ,

Update Operation

MySQL
1 year ago
CREATE TABLE Room_reservation ( Reservation_ID INTEGER PRIMARY KEY , Guest_ID INTEGER , First_Name TEXT , Last_Name TEXT , Check_in_Date TEXT NOT NULL , Check_out_Date TEXT NOT NULL , Room_Number INTEGER , Room_Type TEXT ,

Retrieve operation

MySQL
1 year ago
CREATE TABLE Room_reservation ( reservation_id INT PRIMARY KEY, guest_id INT, first_name VARCHAR(50), last_name VARCHAR(50), check_in_date DATE, check_out_date DATE, room_number INT, room_type VARCHAR(50), adults INT,

Create operation

MySQL
1 year ago
CREATE TABLE Room_reservation ( reservation_id INT PRIMARY KEY, guest_id INT, first_name VARCHAR(50), last_name VARCHAR(50), check_in_date DATE, check_out_date DATE, room_number INT, room_type VARCHAR(50), adults INT,

ROOM RESERVATION

MySQL
2 years ago
CREATE TABLE RESERVATION ( ID INTEGER PRIMARY KEY, NAME TEXT NOT NULL, CONTACT TEXT NOT NULL, EMAIL TEXT NOT NULL, ROOM_TYPE TEXT NOT NULL, CHECK_IN_DATE DATE NOT NULL, CHECK_OUT_DATE DATE NOT NULL, PRICE INTEGER NOT NULL, STATUS TEXT NOT NULL

Manipulate your product table with the following: using sql queries

SQL
2 years ago
-- first table............................ CREATE TABLE products ( ProductID INT PRIMARY KEY, ProductDescription VARCHAR(255), Price DECIMAL(10, 2) ); INSERT INTO products (ProductID, ProductDescription, Price) VALUES (1, 'Laptop', 90.5),

LIST OF RECORD

SQL
2 years ago
-- Create a Reservation table................................................ CREATE TABLE RESERVATION_TABLE ( Reservation_ID TEXT PRIMARY KEY, Customer_Name TEXT NOT NULL, Check_in_Date TEXT NOT NULL, Check_out_Date TEXT NOT NULL, Reservation_Status TEXT NOT NULL, Number_of_Guests INT NOT NULL, Special_Requests TEXT NOT NULL );