SQL SLP

 

In the SLP assignments in the previous modules, you accomplished the following:

  • Determined the scope of the project and the kinds of data you planned to collect based on information requirement (Module 1 SLP)
  • Drew an ER diagram to represent relationship among the tables (Module 2 SLP)
  • Conducted normalization to the tables so all tables satisfied the 3rd normal form, and created tables using Oracle SQL (Module 3 SLP)

In this module, you are to finish the project by applying what you have learned to generate queries (ask questions) of the database.

Database Queries and Reports

For the same bookstore database, write SQL statements to provide the following information for the output specified in the SLP:

  • Employee information (e.g., employee name, address, phone number, hiring date, salary, etc.)
  • Information about the books and CDs in the bookstore (e.g., title, author, price, etc.)
  • Sales of CDs and books, searchable by date
  • Current inventory status of books and CDs
  • Any other output you think appropriate

Write a 2- to 5-page paper that includes your SQL statements and screenshots of the results tables in the DBMS (database management system).

SLP Assignment Expectations

  • You can work by yourself or with a classmate on this project. If working with a partner, be sure to write both students’ names on the assignment.
  • Apply what you have learned to address the questions raised.

Paper-4

Write a paper on Cloud computing

-Paper should be written in APA format

– Include references

– Abstract

– Paper should include what cloud is and differences between cloud and traditional applications

– Advantages and dis advantages of cloud.

Practicum 1 & 2

  

1. Practicum 1 – Evidence collection; this phase is meant to act as though you are the forensics investigator collecting the evidence directly from the source. In this instance, the memory dump information has been provided to you. 

a. Deliverable(s):  

i. Download the Narcos files. NOTE: THIS WILL TAKE TIME, THE FILES ARE LARGE.

ii. Create a chain of custody form using the provided template. Document the receipt of evidence files (each memory dump file and image should be its own line) by entering your name, date, evidence info (what it is), and a hash value of the file.

iii. Make a second tab in the CoC and document any known information from the scenario (Persons, places, etc.) – use the above provided information as well. 

2. Practicum 2 – Evidence Review; Focus on the actual review of the provided files and try to piece together an event trail by following forensic investigation standards (REMEMBER DAUBERT, FRYE, AND OTHER STANDARDS TAUGHT IN THE PROGRAM!) Your goal should be to collect evidence to present to your boss in part 3.  

a. Deliverable(s): 

i. Continue to update the Chain of Custody form as you “check out” evidence to review.

ii. Review the evidence files and create an excel spreadsheet or Word doc (either is fine) documenting any relevant information you can find. NOTE: This portion of the project will not be given to you. All resources (including each other) are at your disposal (Others, GOOGLE!!) and all are accepted for your use!

Proposal

 

Your sponsor is requesting that you send the project proposal so he can prepare before attending a meeting with leadership next week. As part of the request, there is a requirement that two “departmental peers” review and approve the proposal prior to submittal.

You will serve as the project manager for your proposal and as a peer reviewer for the other members in your group.

The beginning of this assignment requires the project manager to upload the initial draft of the project proposal in the group’s discussion board for the peers to review and approve (no later than 4 days before the assignment is due).

Next, in your role as a peer reviewer, provide constructive feedback and suggestions through the group’s discussion board to help ensure that the best possible proposal is presented to the project sponsor. Feedback and suggestions should be posted no later than 2 days before the assignment is due.

(Part to work on now)…….

Subsequently, incorporate any feedback you deem necessary and submit to the sponsor for review and approval. All submissions to the sponsor should be considered a final draft. Your final draft of the revised project proposal is due on the date provided for this assignment (maximum length of two pages).

In addition to the two-page project proposal, include an appendix of supporting documents and visuals (i.e., system models, diagrams, wireframes, and topography maps) needed for the technical understanding of the project.

You will write a program that will calculate the order tax (tax), the net cost (net Cost), and the total cost totalCost) of a

You will write a program that will calculate the order tax (tax) , the net cost (netCost) , and the total cost (totalCost)

 

You will write a program that will calculate the order tax (tax) , the net cost (netCost) , and the total cost (totalCost)
of an online order.
• Assume the following tax rates (taxRate) based on the ID of the location (locationID)
o 0 <= locationID <= 50– TAX rate is 4% (.04)
o 51 <= locationID <=80 – TAX rate is 5.25% (.0525)
o 81 <= locationID <= 100– TAX rate is 6% (.06)
o locationID > 100 – TAX rate is 7.25% (.0725)
o < 0 – is not a valid entry for the locationID
• Use a string for the users first name only as you interact with the user
• Use a string for the cell phone number
• Use a string for the item number
• Use a string for the user letter input (“y” or “n”)
• Use int and double, not float
• The tax on the order is calculated by multiplying the quantity * price * taxRate /100
o Note: drop the 100 if you converted the rate from percentage
• The net cost is calculated by multiplying the quantity times the price
• The total cost will be calculated by adding the netCost and the tax
• All double output should be presented with 2 decimal places
• Use four functions to break up the program (functions may not be modified)
//BE SURE TO ADD COMMENTS TO THE FUNCTION PROTOTYPES AND THE FUNCITON DEFINITIONS
//fill out the pre and post conditions
void GetOrderInfo(string&, string&, int&, double&, int&);
//Precondition: State what is true before the function is called.
//Postcondition: State what is true after the function has executed.
//Description: Describe what the function does.
void GetTaxRate(double&, int);
//Precondition: State what is true before the function is called.
//Postcondition: State what is true after the function has executed.
//Description: Describe what the function does.
void CalculateResults(int, double, double, double&, double&, double&);
//Precondition: State what is true before the function is called.
//Postcondition: State what is true after the function has executed.
//Description: Describe what the function does.
void DisplayResults(string, string, int, double, int, double, double, double, double);
//Precondition: State what is true before the function is called.
//Postcondition: State what is true after the function has executed.
//Description: Describe what the function does.

The user will enter phone number (as a string) , the item number (as a string), the quantity (as an integer), the price (as a
double), and the location ID (as an integer) For program 2 you must use the following functions exactly as described above
(same name and same formal parameter data types in the same order)
These 4 functions MUST be called from the main function.
The purpose of the assignment is to practice pass by value and pass by reference.
You may add additional functions, but you MAY NOT modify the name or the formal parameters of the above
4 functions.
Additional instructions:
• Be sure to comment your code
• Include a program header with the following information:
o Name, due date, course, assignment number, professor name, and a brief description of the
assignment – see the sample skeleton provided with the assignment.
• Read all comments in the sample code before getting started
• Read the problem and determine what to do
• Write the algorithm (you DO NOT need to submit the algorithm)
• Implement one component at a time in your code and do not move onto the next component until you
are sure it is correct.
• Test your program before submitting
• One source code file (unformatted text) will be submitted
• The file name must match the assignment
• The code should be tested and run on a Microsoft compiler before it is uploaded onto Canvas
• The code must be submitted on time in order to receive credit (11:59 PM on the due date)

SAMPLE OUTPUT:
Enter your first name: Tami
Enter the cell phone number: 5612312233
Enter the item number? qwAs-rqwst123
Enter the quantity? 14
Enter the price? 17.12
Enter the location ID number? 52
Cell number: 5612312233
Item number: qwAs-rqwst123
Quantity: 14
Price: 17.12
Tax rate: 5.25%
tax: $12.58
Net cost: $239.68
total cost: $252.26
Tami, would you like to do another calculation (Y or N):
y
Enter the cell phone number: 5612129876
Enter the item number? trWq21vcx-hrJ
Enter the quantity? 200
Enter the price? 15.50
Enter the location ID number? -34
A negative number for the location ID is not a valid entry.
Cell number: 5612129876

Item number: trWq21vcx-hrJ
Quantity: 200
Price: 0.00
Tax rate: 0.00%
tax: $0.00
Net cost: $0.00
total cost: $0.00
Tami, would you like to do another calculation (Y or N):
n
Tami, Have a nice day!

You will write a program that will calculate the order tax (tax), the net cost (net Cost), and the total cost totalCost) of a
For program 2 you must we the following functions exactly as described above (same name and some forma parameter data types i

for c++

Technology Conference Registration

  

Technology Conference Registration
Based on the case project shown in Figure 5-111, create a requirements document and a Use Case Definition document, and then design a Windows application. Before writing the code, create an event planning document for each event in the program.

 
 

It is important that developers update their skills by attending developers conferences. The Dynamic International Management Consorttium (DIMC) runs and manages the ADSE (Active Developers Skill Enhancement) Conference two times per year. To encourage companies to send multiple employees to the conference, the cost per attendee is determined based on the number of attending developers from a given company. The table below specifies cost per attendee.
Number of Conference
Registration per
Company Cost per Attendee
1 $695
2-4 $545
5-8 $480
8 or more $395

 
 

DIMS has requested that you develop a Windows application that can determine and display the total cost per company for developers attending the conference. DIMC has a conference policy that states if any member of a company has attended a previous DIMC conference, the company receives a 15% discount from the total cost of its employees who attend. The policy also states that no more than 16 people from a single company can attend the conference. DIMC has asked that you design the program so that the user must enter valid data.

Week 5 DQ

Research what transformational management/leadership is and how it differs from transactional leadership. Briefly explain when each of these styles of management might be appropriate. 

Note: 250 words with intext citations and 2 references needed.

Convert the following decimal number to binary

  

1. Convert the following decimal number to binary:

The number 2618 can be expressed as:

 

2. Convert the following binary numbers to decimal:

a. The number 1101110101 represents:

b. The number 1011010.011 represents:

3. Convert the following binary number to hexadecimal:

110110110011010

Starting on the right, divide the binary number into sets of 4 digits. Add leading zeros . as needed.

4. Convert the following hexadecimal number to decimal:

C87B