1. write SQL statements to create the following two tables:

a) Department table that contains the following columns(dept_no,deptname,location) set the deptno to be the primary key.
b) Employee table contains the following columns(emp_no,empname,deptno,salary)set the emp_no to be the primary key and dept_no to be the foreign key.

2. Write SQL statements to Insert the following 3 rows in Employee table:

       (101,’Sami’,’D-101’,5000)
       (102,’Yousef’,’D-101’,4000)
       (103,’Sami’,’D-102’,7000)

3. Write SQL statements to Insert the following 3 rows in Department table:
       (‘D-101’,’Marketing’,’loc1’)
       (‘D-102’,’Sales’,’loc2’)
       (‘D-103’,’Finance’,’loc3’)

4. Create a view for employee at marketing department.

Designing A New Arena :

You work for a company that has been tasked with designing a proposed seating plan for an NHL team’s new arena. Currently the NHL team plays in a rink similar to the one shown here:
Parameters of the Plan

• One ring of seats all the way around the rink is considered a row
• Row 1 is considered to be the row closest to the ice.
• The number of seats in the arena has to be between 18 000 and 22 500
• There cannot be more than 40 rows in the arena.
• The number of seats in each row must form an arithmetic sequence, increasing by the same number in each subsequent row.

PART A – SEATS AND ROWS

Using the parameters above, and your understanding of sequences and series:

1. Begin by selecting a total number of seats in the arena
2. Choose a realistic number of rows required for the entire arena
3. Choose a number of seats by which each row will increase
4. Based on your choices for 1 – 3, determine the number of seats in the first row
5. Based on the information from 1 – 4, determine the number of seats in the last row
6. Clearly summarize all of the information that you found in this part of your proposal in an organized list of a few bullet points.

Be sure to explain in detail any assumptions you make.

PART B – TICKET PRICES

The team’s current arena charges:

• $6000 for a season seat in rows 1-10
• $4000 for a season seat in rows 11-20
• $3000 for a season seat in rows 21-30
• $2000 for a season seat in rows 31-40.

The team has suggested modifying their current plan to use a geometric sequence, and decrease the price for a seat in each subsequent row by the same factor based on the price of a seat in the row in front of it.

Using the team’s current arena charges, your work from PART A, and your understanding of sequences and series:

1. Determine a reasonable price for a season ticket in the first row
2. Determine a reasonable factor by which the cost of each seat per game will decrease in each subsequent row behind row 1.
3. Determine the price per game of a season ticket in the last row

Write a program that allows the user to enter two integers and a character If the character is A, add the two integers If it is S, subtract the second integer from the first else multiply the integers Display the results of the arithmetic

In this programming assignment, you will write C code that performs recursion. For the purpose of this assignment, you will keep all functions in a single source file main.c. Your main job is to write a recursive function that generates and prints all possible password combinations using characters in an array.

• In your main() function you will first parse the command line arguments. You can assume that the arguments will always be provided in the correct format. Remember that the command line arguments are always strings. You will have to convert them to integers or individual characters for your use.
  • The program execution will be similar to ./a.out M c1 c2 c3 ... N
  • M represents the number of allowable characters in the password.
  • Based on the value for M, the next set of arguments will be the allowable characters. For example, if M = 3, then the next 3 arguments will be the characters allowed in the password. c1 = 'a', c2 = 'b', c3 = 'c'. The values of c1, c2, c3does not have to be in alphabetical order. It can be any of the 26 characters.
  • Another example, if M = 2, then there will only be 2 arguments: c1 = 'x', and c2 = 'y'.
  • N represents the maximum length of the password.
  • Using the value of M create a dynamic array of characters. Copy the next set of arguments c1, c2, ... into the array.
• Create a function called printPasswords().
  • This function will take in three parameters - N, M, and the array of allowable characters.
  • This function will not return anything.
  • This function will print all allowable passwords of length 1 <= length <= N, each on a separate line.
  • You can write as many helper functions as needed.

Following is an example output 1, when the program execution is ./a.out 3 a b c 2

a
b
c
aa
ab
ac
ba
bb
bc
ca
cb
cc

Following is an example output 2, when the program execution is ./a.out 2 a b 3

a
b
aa
ab
ba
bb
aaa
aab
aba
abb
baa
bab
bba
bbb

To demonstrate the practical implementation of the public\private encryption, you have been asked to compete the following task.

i. Type the following message in a .txt file: “My student ID is : >

ii. Download the public key given in this assignment folder and encrypt your message with the same key using openssl. iii. Using openssl, generate RSA key pair (2048bits) in your computer.

my student id is 40926

Consider the following hypothetical microprocessor. Assume this processor uses 32-bit instructions. Assume the 32 bits are composed of an opcode of 7 bits and an address of 25 bits. Answer the questions below.

1. What is the memory capacity (in Bytes)? Show your work and give your final answer in megabytes (MB).
   2. Consider the following address and data bus widths, and discuss their impact on system speed.
   1. Local address bus width of 32 bits, and a local data bus width of 8 bits.
   2. Local address bus width of 8 bits, and a local data bus width of 8 bits.

C Programing

How would i edit this code to have it return the cipher text.

void vigenereCipher(char* plainText, char* k){

int i;

char cipher;

int cipherValue;

int len = strlen(k);

//Loop through the length of the plain text string

for(i=0; i<strlen(plainText); i++){

//if the character is lowercase, where range is [97 -122]

if(islower(plainText[i]))

{

cipherValue = ( (int)plainText[i]-97 + (int)tolower(k[i % len])-97 ) % 26 +97;

cipher = (char)cipherValue;

}

else // Else it's upper case, where letter range is [65 - 90]

{

cipherValue = ( (int)plainText[i]-65 + (int)toupper(k[i % len])-65 ) % 26 +65;

cipher = (char)cipherValue;

}

//Print the ciphered character if it is alphanumeric (a letter)

if(isalpha(plainText[i]))

{

printf("%c", cipher);

}

else //if the character is not a letter then print the character (e.g. space)

{

printf("%c", plainText[i]);

}

}

}

MATLAB

Create a 2 × 3 matrix variable mat. Pass this matrix variable to each of the following functions and make sure you understand the result: flip, fliplr, flipud, and rot90. In how many different ways can you reshape it?

Note: (in addition to the functions listed, rotate the matrix 180 degrees clockwise)

C++

C++

Write a definition for a structure type for records for CDs. The record contains price and total number of songs, . Part of the problem is appropriate choices of type and member names.Then declare two variables of this structure. Write a function called GetData use the structure as function argument to ask the user to input the value from the keyboard for structure variables.

Write a method speedingTicket() that decides whether a driver should be given a ticket from a police officer. The method accepts three parameters: speed (i.e., car speed) as integer; limit (i.e., speed limit) as integer and a boolean named donut indicating whether or not the police officer has eaten a donut today. A police officer that has eaten a donut is happy, so he/she is less likely to give the driver a ticket.

Your method should display either “Give Ticket” or “No Ticket!” based on the following:

• TICKET: Driver’s speed is more than 20 over the speed limit, regardless of donut status.

• TICKET: Driver's speed is 5-20 over the speed limit and officer has not eaten a donut.

• NO TICKET: Driver's speed is 5-20 over the speed limit and officer has eaten a donut.

• NO TICKET: Driver’s speed is < 5 over the speed limit, regardless of donut status.

Sample Calls Output speedingTicket(58, 55, false) No Ticket!

speedingTicket(45, 30, false) Give Ticket

speedingTicket(100, 75, true) Give Ticket

speedingTicket(42, 35, true) No Ticket!

speedingTicket(30, 35, false) No Ticket! //write your method below including the method header

7. In order to improve the network performance and security, ACLs is recommended. Please explain what is the ACL ?

8. How can ACLs help with the required tasks?

9. What are the principles of applying ACLs?

10. How to block VLAN 10 to visit ISP? Please write down the ACL statement(s) accordingly

Develop a Java program that determines the gross pay for an employee. The company pays hourly rate for the first 40 hours worked by the employee and time and a half (1.5x hourly rate) for all hours worked in excess of 40. The user of your application will enter an employee name, shift (day or night) ,the number of hours worked for the week and their hourly rate. Your program should then calculate and display the employee’s name, regular pay, overtime pay, total gross pay and payperiod. PayPeriod is "Friday" for "day" shift and "Saturday" for "night" shift. Use class Scanner to input the data. Be sure to format output, so it is professionally displayed to your users.

Here is an example of pseudocode:

Start
Enter employee name
Enter employee shift (day/night)
Enter hours worked
Enter hourly pay rate
Calculate reg pay
if hours worked > 40 then
Calculate overtime pay
else
overtime = 0
Calculate total pay
Output employee name, reguldar pay, overtime pay, total pay
If day shift
output “Friday payperiod”
Else
output “Saturday payperiod”.
End.

this should be written in Java- Problem: Min/Max Search by Index Develop a program that, given a sequence S of integers as input, produces as output two sequences of positive integers, the first of which indicates all those positions in S at which S's minimum value occurs and the second of which indicates all those positions at which S's maximum value occurs. Positions are numbered starting at zero (0).

Facts ● Scanner has a method that returns a boolean indicating whether a next integer exists in its input stream ( hasNextInt() ) ● Scanner objects can be initialized to to scan String data as input.

Sample input

3

3 6 -1 4 6 5 3

0 0 0 0

-4 45 2 0 3 5 11 -7 854 25 3 -7 4 -3

Sample output

3 6 -1 4 6 5 3

2

1 4

0 0 0 0

0 1 2 3

0 1 2 3

-4 45 2 0 3 5 11 -7 854 25 3 -7 4 -3

7 11

8

Input The input will begin with a single line containing T , the number of test cases to follow. The remaining lines contain the T sequences, one line per sequence. Each of these lines contains the values in the sequence. Each such value is separated from the next by at least one space.

Output For each sequence given as input, there should be four lines of output. The first line echos the given sequence. The second line indicates the positions at which the minimum value occurs. The third line indicates the positions at which the maximum value occurs. The fourth line is blank.

Write a javascript program that computes the total cost for a five year car lease. The program starts with a monthly leasing amount and a yearly increase in percent. The program then outputs the total amount paid for each year and the total overall cost of the lease.

What is your opinion on the use of AI technology? Is it necessary or is it a step in a wrong/different direction?