IS 633 Assignment 1
Due 9/27
Please submit SQL statements as a plain text file (.txt). If blackboard rejects txt file you can submit a zipped file containing the text file. Word, PDF, or Image format are not accepted. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle 11g.
Problem 1. Please create the following tables for a tool rental database with appropriate primary keys & foreign keys. [30 points]
Assumptions:
The list of tables is:
Tables:
Cust Table:
cid, -- customer id
cname, --- customer name
cphone, --- customer phone
cemail, --- customer email
Category table:
ctid, --- category id
ctname, --- category name
parent, --- parent category id since category has a hierarchy structure, power washers, electric power washers, gas power washers. You can assume that there are only two levels.
Tool:
tid, --- tool id
tname, --- tool name
ctid, --- category id, the bottom level.
quantity, --- number of this tools
Time_unit table allowed renting unit
tuid, --- time unit id
len, --- length of period, can be 1 hour, 1 day, etc.
min_len, --- minimal #of time unit, e.g., hourly rental but minimal 4 hours.
Tool_Price:
tid, --- tool id
tuid, --- time unit id
price, -- price per period
Rental:
rid, --- rental id
cid, --- customer id
tid, --- tool id
tuid, --- time unit id
num_unit, --- number of time unit of rental, e.g., if num_unit = 5 and unit is hourly, it means 5 hours.
start_time, -- rental start time
end_time, --- suppose rental end_time
return_time, --- time to return the tool
credit_card, --- credit card number
total, --- total charge
Problem 2. Insert at least three rows of data to each table. Make sure you keep the primary key and foreign key constraints. [20 points]
Problem 3. Please write ONE SQL statement for each of the following tasks using tables created in Problem 1. You can ONLY use conditions listed in the task description. Task 1 and 2 each has 5 points. Tasks 3 to 6 each has 10 points. [50 points]
Task 1: return IDs of rentals started in August 2019.
Hint: function trunc(x) converts x which is of timestamp type into date type.
Task 2: Return names and quantity of all tools under the category carpet cleaner. You can assume there is no subcategory under carpet cleaner
Task 3: return number of rentals per customer along with customer ID in the year 2019 (i.e., the start_time of the rental is in 2019).
Task 4: return IDs of tools that has been rented at least twice in 2019.
Task 5: return the price of renting a small carpet cleaner (the name of the tool) for 5 hours.
Hint: find unit price for hourly rental and then multiply that by 5.
Task 6: return names of customers who have rented at least twice in year 2019 (i.e., rental’s start time is in 2019).
In: Computer Science
implement the reverse() method that changes the ordering of the items within a doublylinkedlist class. don't return anything and make sure it executes without errors on lists with no items or one item
example:
fruits = DoublyLinkedList()
fruits.append('apple')
fruits.append('banana')
fruits.append('cherry')
for i in fruits:
print(i)
>> apple
>> banana
>> Charlie
fruits.reverse()
for i in fruits:
print(i)
>> cherry
>> banana
>> appleIn: Computer Science
I am trying to tokenize a string using a function by passing the char string[] and char *pointer[100]. While I have working code inside the int main(), I am having trouble actually declaring the parameters for the function.
I know how to pass the char array (char string[]), but not how to pass the char pointer array (char *pointer[100]).
This is my code below:
int main() {
// Declare variables
char str[] = "this is a test only - just a
test"; // char array
char *ptr1[100], *ptr2[100];
// Creates
two pointers
function1(str, *ptr1[100]);
return 0;
}
void function1(char str[], char *ptr1[100]) {
int i = 0;
int count = 0;
// Declaration of strtok: char
*strtok(char *str, const char *delim)
// It breaks *str into a series of
tokens using *delim
char *p = strtok (str, " ");
// Stores each piece into the
array
while (p != NULL) {
ptr1[i++] =
p;
p = strtok(NULL,
" ");
count++;
}
// Prints the array
for (i = 0; i < count; ++i)
{
printf("%s\n",
ptr1[i]);
}
}
For my code, it works if I get rid of the function and simply place the code in my int main(). Other times, I manipulated the second parameter and it started to work. However, the return values from 'p' transformed into integers from the "ptr1[i++] = p" portion of the code.
In: Computer Science
Lab Assignment 1
2020 – 2021 Fall, CMPE 211 Fundamentals of Programming II
STUDENT AFFAIRS
DUE DATE: 14.10.2020 – 23:59
In this lab, we will create a model course registration application. Please check out the example run of the program first.
You are asked to implement the classes;
The commands and their arguments for this week are:
where letterGrade can be (AA, BA, BB, CB, CC, DC, DD, F, FX).
In order to store the students and the courses, create 2 Arrays for them in the StudentAffairs class. You need to take commands from user until you see the “Q” command. For this purpose, you need to create while loop. Stopping condition of this command is “Q” command from user. Each command needs to be differentiated either if clause or switch case. After each command differentiated, specific information subcommands will be taken that belongs the specific main command parsed with space. Each command has specific things to do and command line output that will inform the user. Look at the demo video for better understanding. However, at first you need to create Student, Course and Grade classes.
Grade Class
Data Declarations:
Student Class
Data Declarations:
Course Class
Data Declarations:
In: Computer Science
A company has changed their web hosting policy and now requires SSL certificates on all web servers. Users are reporting that they can no longer access an internal website. Which of the following commands should the administrator run to determine if port 443 is listening? (Select two.)
A. traceroute
B. telnet
C. netstat
D. ipconfig
E. nslookup
Thumbs up for explanation!
In: Computer Science
Draw the class diagram in draw.io software for an Airline Reservation system.
In: Computer Science
This is for CYBER SECURITY
1)What are the 3 factors of Authentication and provide at least 3 examples for each?
2) Please compare and
contrast the following 4 Access Control Models and let me know how
they work and give me an example of each.
1. Discretionary Access Control
2. Mandatory Access Control
3. Rule Based Access Controls
4. Role Based Access Controls
In: Computer Science
In: Computer Science
Telecommunication Governance 1:
Give at least 3 real life examples of the impact vs. probability risk management actions and their individual application.
In: Computer Science
In: Computer Science
Assume that you have the following MAC address 01:00:5e:XX:XX:XX (where the last 3 bytes matches the last 3 bytes of your own device MAC address), figure out what IPv4 multicast address does this MAC address belongs to?
In: Computer Science
In: Computer Science
s = [1,1,2,2,2,9,-5,-10,8,0]
In: Computer Science
Using C++
There are number of cable company in southern California which offer number of services
for customers. This company have two types of customers:
Residential and business. There are two rates for calculating a cable bill: one for Residential customers and one for business customers.
For residential customers the following rates apply:
For business customers the following rates apply:
Input:
The customer’s account number,
Customer code
Number of premium channels
And in case of business customers, number of basic service connections
What to deliver (output) Customers’ account number and the billing amount
Run your program for the given data:
Enter customer code: R or r (Residential) or B or b (Business) B
Enter number of service connections 16
Enter number of premium channels 8
Display total billing amount:
Run for residential customers:
R
Test your program for 12 premium channels.
flow chart, pseudo code are required for every projects and activities.
In: Computer Science
Objective: The purpose of this assignment is to introduce declaration of list objects, the forstatement and the def keyword used to define functions.
Problem: Write a Python module (a text file containing valid Python code) named p3.py. This file will contain the following.
Definition of a list containing strings which are in turn integers. These integers represent years, which will be used as inputs to the next item in the file
Definition of a function named isLeap. This function must accept a string containing an integer that will be interpreted by this function as a year. If the year is prior to the introduction of the Gregorian calendar, it will print “Not Gregorian.” If the year is aGregorian year and a leap year, it will print “Leap year!”. If the year is a Gregorian year butnot a leap year, it will print “Not a leap year!”.
A for loop that will call isLeap with each of the year strings in the list of year strings defined above.
While you are free to use any name for your list of year strings, you must use the name isLeap for the function.
Submission: Submit the code you write in a text file named p3.py to the Blackboard folder for this assignment.
Also –
As you implement the code for this assignment, consider what might be added to the testing process and program output to make it clearer what the unit testing is accomplishing. For up to five points extra credit, you also submit a Word document describing any improvements you think would help in testing the function you created, including any additional output that would be useful or testing cycles.
In: Computer Science