Question 1: Create two different forms of the INSERT command to add a student with a student ID of 60001 and last name John to the STUDENT table. (8 points)

Question 2: Write a SQL command that will modify the name of course ISM4212 from Database to introduction to Oracle. (8 points)

Question 3: Which students are enrolled in Database and Networking course? (8 points)

Question 4: How many students are enrolled in Section 2714 in the first semester of 2018? (8 points)

Question 5: Write a query to add a column state in student table and also show the use of check constraint by inserting state name (CA, FL, LA, NY). (8 points)

Question 6: Write a query using above table (one table or combination of tables) to show the use of all parts of select command. (8 points)

Question 7:  What is the smallest section number used in the first semester of 2018. 

(8 points)

Question 8: Write a query to show the student ID, faculty ID where date qualified is 9/2008 in descending order. (8 points)

Question 9: Write a query using above tables to show the use of AND, OR operators.

(8 points)

Question 10: In student table add the grade column and insert data for any two students.

(8 points)

Question 11: Write a query using above table / tables to show the use of Alias name. 

(8 points)

Question 12: Write a query or set of queries to establish the relationships among student, faculty, and section tables. You may add any new column in these three table. (12 points)

Spring 2021

Project – 1 (100 Points) Assigned on: February 13th,20201

Due on: (No later than) February 17th by Night,2021

Guidelines:

– The more unique aspects you cover, the higher points you will earn.

– The originality of the papers, references, conciseness of the summary, etc., will also contribute to the final

grade.

– The project must be handwritten (except figures).

– Insert this cover page to your solution package.

Name-1: __________________________

1. Conduct research on IEEE, ACM or other relevant publications about the computer technology history as well as developments and

o submit seven different major quotes since 1950s for each decade and itemize seven important milestones since 1940s (other than ones covered during the lectures). (Also, submit all original complete reference information)

o study six early computer systems in terms of architectural and organizational perspectives, submit their pictures (with complete reference info), compare with a particular current computer system, and discuss potential anticipated computer systems in the year-2031.

o briefly explain the following concepts: Neuromorphic computing, Zettascale computing, Quantum computing, Nanocomputing, Edge computing, Colossus (related to the computer architecture field), Probabilistic computing, Cloud computing, Virtualized instruction set architecture, Sniper Multi-core simulator.

2. Develop a hypothetical architecture with illustrative instruction and data formats, instruction sets, etc., explain the instruction and machine cycles step-by-step by developing a short program (at least, with three arithmetic operations, two logic operations, two memory or three I/O operations) and by indicating the corresponding register operations. All architectural, etc., selections must to be justified sufficiently.

3. Conduct research on the IEEE or ACM journal articles or conference proceedings, published within the last one-year period, about the memory concepts. Submit a total of three-page summary for three important publications (along with the original paper complete reference information only) on different cache memory aspects.

Need help with Discussion and Assignment.

Please find the attached docs for more details.

Thanks!

Create a table to illustrate how you are connected to the physical network layer of the cyber domain.

• Identify the devices in your home that are connected to a network, such as your phone, computers, or other networked devices.
• Briefly explain how those devices are connected to a larger network, such as a cellular provider or ISP.
• Research and list at least 3 threats to you and your connected networks.

Format any references according to APA guidelines.

Part of lab lesson 8

There are two parts to lab lesson 8. The entire lab will be worth 100 points.

Lab lesson 8 part 2 is worth 50 points

For part 2 you will have 40 points if you enter the program and successfully run the program tests. An additional 10 points will be based on the style and formatting of your C++ code.

Style points

The 10 points for coding style will be based on the following guidelines:

• Comments at the start of your programming with a brief description of the purpose of the program.
• Comments throughout your program
• Proper formatting of your code (follow the guidelines in the Gaddis text book, or those used by your CS 1336 professor)
• If you have any variables they must have meaningful names.

Development in your IDE

For lab lesson 8 (both parts) you will be developing your solutions using an Integrated Development Environment (IDE) such as Visual Studio, Code::Blocks or Eclipse. You should use whatever IDE you are using for your CS 1336 class. Once you have created and tested your solutions you will be uploading the files to zyBooks/zyLabs. Your uploaded file must match the name specified in the directions for the lab lesson. You will be using an IDE and uploading the appropriate files for this and all future lab lessons.

For this and all future labs the name of the source files must be:

lessonXpartY.cpp

Where X is the lab lesson number (8 for lab lesson 8) and Y is the part number (1 for part 1, 2 for part 2).

You will need to develop and test the program in your IDE. Once you are satisfied that it is correct you will need to upload the source file to zyBooks/zyLabs, and submit it for the Submit mode tests. If your program does not pass all of the tests you need to go back to the IDE, and update your program to fix the problems you have with the tests. You must then upload the program from the IDE to zyBooks/zylabs again. You can then run the tests again in Submit mode.

When running your program in Submit mode it is very important that you look at the output from all of the tests. You should then try and fix all of the problems in your IDE and then upload the updated code to zyBooks/zyLabs.

C++ requirements

You are not allowed to use any global variables. Use of global variables will result in a grade of zero for part 1.

Your program must have function main, function presentValue, three read functions, and a display function. Including main this is six functions.

The presentValue function must have the following signature:

double presentValue(double futureValue, double interestRate, int numberYears)

The presentValue needs to calculate the present value and return that back to the calling function. The formula for this is above. Note that the annual interest would be .08 for 8%.

Failure to follow the C++ requirements could reduce the points received from passing the tests.

General overview

In part 2 you will be creating multiple functions to calculate the present value.

You may be asking what a “present value” is. Suppose you want to deposit a certain amount of money into a savings account and then leave it alone to draw interest for some amount of time, say 12 years. At the end of the 12 years you want to have $15,000 in the account. The present value is the amount of money you would have to deposit today to have $15,000 in 12 years.

The formula used needs the future value (F) and annual interest rate (r) and the number of years (n) the money will sit in the account, unchanged. You will be calculating the present value (P).

P = F / ( (1 + r) ^ n)

In the above expression the value (1 + r) needs to be raised to the nth power. Assume that ^ is the power function and x^2 is x to the 2nd power (x squared)

You are not allowed to use any global variables. Use of global variables will result in a grade of zero for part 2.

Three read functions

You must have functions to read in the future value, the annual interest rate, and the number of years. That would be three different functions. Give these functions meaningful names. Note that the order of the values will be future value, annual interest rate, and number of years.

In all cases you need to return any valid value back to the calling function.

For all three functions you will write out to cout as prompt for an input value. You will read in that value from cin. If the value is invalid (zero or negative) you need to display an error message and reread the value (with another prompt). You need to do this in a loop and continue looping until a valid value has been entered. Only the number of years can be an int value. The rest should be of type double.

Here are the prompts for the three values you need to read in:

Enter future value

Enter annual interest rate

Enter number of years

Note that the interest rate will be a number such as 10 or 12.5. These are to be read in as percentages (10% and 12.5%). You will need to divide these values by 100 to convert them into the values needed in the function (.1 and .125 for the above values). This conversion needs to be done before you call the presentValue function (see below). If you do the conversion in the presentValue function your program will fail the unit tests, so do the conversion before you call the calculate function.

Here are the error messages you need to display if the values are negative:

The future value must be greater than zero

The annual interest rate must be greater than zero

The number of years must be greater than zero

You will also need a function called presentValue with the following signature:

double presentValue(double futureValue, double interestRate, int numberYears)

The presentValue needs to calculate the present value and return that back to the calling function. The formula for this is above. Note that the annual interest would be .08 for 8%.

Note that the interest rate will be a number such as 10 or 12.5. These are to be read in as percentages (10% and 12.5%). You will need to divide these values by 100 to convert them into the values needed in the function (.1 and .125 for the above values). This conversion needs to be done before you call the presentValue function (see below). If you do the conversion in the presentValue function your program will fail the unit tests, so do the conversion before you call the calculate function.

The display function

You also need a function that displays the present value, future value, interest rate, and number of years. The function needs to display the interest rate as %, so .05 would display as 5.000%. Give your display function a meaningful name. You will be passing a number of values to this function.

Here is the sample output for a present value of $69,046.56, a future value of $100,000, an interest rate of 2.5% and a number of years of 15,

Present value: $69046.56

Future value: $100000.00

Annual interest rate: 2.500%

Years: 15

Note that the present value and future value have three digits of precision to the right of the decimal point but the interest rate only has one digit to the right of the decimal point.

The main function will be the driver for your program.

Your program will only be processing one set of valid values for future value, annual interest rate and number of years.

Get the values for these by calling the read functions you created above.

Once you have the values you need to call your presentValue. Using the result from the presentValue and the input values you read in with your read functions you need to call your display function (written above) to display the values.

The main function

The main function will be the driver for your program. All of the non-main functions are called from main.

For the following sample run assume the input is as follows:

1000000.0

5.0

25

Your program should output the following:

Enter future value

Enter annual interest rate

Enter number of years

Present value: $295302.77

Future value: $1000000.00

Annual interest rate: 5.000%

Years: 25

Here is an example with some invalid data

Input values:

-100

0

1000000.0

5.0

25

Output:

Enter future value

The future value must be greater than zero

Enter future value

The future value must be greater than zero

Enter future value

Enter annual interest rate

Enter number of years

Present value: $295302.77

Future value: $1000000.00

Annual interest rate: 5.000%

Years: 25

Failure to follow the requirements for lab lessons can result in deductions to your points, even if you pass the validation tests. Logic errors, where you are not actually implementing the correct behavior, can result in reductions even if the test cases happen to return valid answers. This will be true for this and all future lab lessons.

Expected output

There are eight tests. The first test will run your program with input and check your output to make sure it matches what is expected. The next three tests are unit tests. The unit tests will directly call the presentValue function. The compilation of the unit test could fail if your presentValue function does not have the required signature. The final four tests will run your program with various input values and make sure you are calculating the correct answers.

You will get yellow highlighted text when you run the tests if your output is not what is expected. This can be because you are not getting the correct result. It could also be because your formatting does not match what is required. The checking that zyBooks does is very exacting and you must match it exactly. More information about what the yellow highlighting means can be found in course “How to use zyBooks” – especially section “1.4 zyLab basics”.

Finally, do not include a system("pause"); statement in your program. This will cause your verification steps to fail.

Note: that the system("pause"); command runs the pause command on the computer where the program is running. The pause command is a Windows command. Your program will be run on a server in the cloud. The cloud server may be running a different operating system (such as Linux).

Error message “Could not find main function”

Now that we are using functions some of the tests are unit tests. In the unit tests the zyBooks environment will call one or more of your functions directly.

To do this it has to find your main function.

Right now zyBooks has a problem with this when your int main() statement has a comment on it.

For example:

If your main looks as follows:

int main() // main function

You will get an error message:

Could not find main function

You need to change your code to:

// main function

int main()

If you do not make this change you will continue to fail the unit tests.