All posts by : chebby

The Team CTF tests cyber skills in 10 categories, and each category has one question. You and each of your team members are required to solve one problem for this CTF competition. Divide the problems between team members. Use the table below to determine which of your team members will be attempting each problem.

You only need to do one problem per person and are not required to solve all the problems. Use the table below. No two students should be selecting the same category for their final PowerPoint presentation. Categories will be selected on a first-come, first-serve basis. Post your selection in the discussion. Any disputes over a category selection should be resolved with assistance from your instructor.

ECET 450: Laboratory 4

Purpose:

This laboratory provides practice in the creation and use of basic and advanced SQL queries involving more than one table in a DB schema.

Procedure: 

Using your assigned user name, password, and host string, log in to Oracle SQL*Plus, and open a spool file to collect your dialog. Create queries to answer the following questions. Your queries should be written so that they use only the data provided and display only the data requested. 

Don’t edit the initial spool file. You will make mistakes and will not be penalized for them. Attach it to the back of your report. Follow the instructor’s instruction concerning any additional required items, any needed sign-offs, and the due date of this report.

Part A:

1. Display the invoice number, the invoice date, the customer id, and the customer name for each order in the database.

2. Display the invoice number, the customer id, and the customer name for each order placed on September 12th, 2007.

3. Display the invoice number, the invoice date, the product id, the number of units ordered, and the line price for each line in each order.

4. Display the id and the name of each customer that placed an order on September 12th, 2007, using the IN operator in your query.

5. Display the id and the name of each customer that placed an order on September 12th, 2007, using the EXISTS operator in your query.

6. Display the id and the name of each customer that did not place an order on September 12th, 2007.  (Be careful in performing this query.)

7. Display the invoice number, the invoice date, the product id, the product description, and the product type for each line in each order.

8. Display the same data as in question 7, but order the display by product type. Within each type, order the display by invoice number.

9. Display the sales representative’s id, last name, and first name of each representative who represents, at a minimum, one customer whose credit is $10,000 using a subquery.

10. Display the same data as in the previous question without using a subquery.

11. Display the id and the name of each customer with a current order for a Blender.

12. Display the invoice number and the invoice date for each customer order placed by Charles Appliance and Sport.

13. Display the invoice number and the invoice date for each invoice that contains an Electric Range.

14. Display the invoice number and the invoice date for each invoice that was either placed by Charles Appliance and Sport or whose invoice contains an Electric Range. Use a set operation to perform this query.

15. Display the invoice number and the invoice date for each invoice that was placed by Charles Appliance and Sport and whose invoice contains an Electric Range. Use a set operation to perform this query.

16. Display the invoice number and the invoice date for each invoice that was placed by Charles Appliance and Sport and whose invoice does not contain an Electric Range. Use a set operation to perform this query.

17. Display the product id, the product description, the product price, and the product type for each product whose product price is greater than the price of every part in product type SG. Be sure to correctly choose either the ALL or the ANY operator in your query.

18. Display the same attributes as in the previous question. However, use the other of the two operators: ALL or ANY. This version of the SQL statement provides the answer to a question. What is that question? Add your answer as a comment to your list file.

19. Display the id, the description, the quantity, the invoice number, and the number of units ordered for each product. Make sure to include all products in your output.  The order number and the number of ordered units must remain blank for any product that is not contained in an invoice. Order your display by product number.

 I’m working on a computer science project and need guidance to help me learn.

I’m working on a software development project and need support to help me learn.

i have a project related to green software engineering and i need help in it

I have the project attached to the question

i need to identify the knowledge of green software first

then, I need to dive deeper into ontology and metadata

after that, i need to make a web-based application that is dependent on the above

…

the  application should be the source of the information any software  engineer can go to and find the best way to use green software in coding  and implementation, infrastructure and designing… etc that are  divided and organized like category

…..

i need a daily update

Complete exercises 3 and 4 at the end of chapter 21
Please use “Clearly Visual Basic: Programming with MS Visual Basic 2010 (2nd ed.). Zak, Diane

Ch 21 Pg 396 “Clearly Visual Basic: Programming with MS Visual Basic 2010 (2nd ed.). Zak, Diane.

Ex 3 &4. In this exercise you modify the application from TRY THIS Exercise 1.

Instructions

Please pick one activity to create for an upcoming event

● Create a 3-5 minute presentation

Topic

● Tech

Examples

Note: The list below are only examples. Feel free to pick something else, 

Tech (examples below)

– A software demo

– New technologies

– The history of data technology

– Anything else related to tech

Presentation Guidelines

● Minimum 3 minutes in length

● Doesn’t need to follow phase 4 guidelines – just a nice, simple, clear presentation

● Sample

○ https://www.youtube.com/watch?v=MsoUZzGtoOs&ab_channel=NikiParkin

Need 250 to 300 words with references for each discussion in 2 separate documents. No APA format required and the textbook is attached.

Question 1. 1. (TCO1) The Central Office is the place: (Points : 5)

Where the operator makes connections.

Where all ISDN capabilities begin.

Where calls from subscribers are routed.

To connect the ADSL lines.

Question 2. 2. (TCO2) Like many softPBX systems, Asterisk refers to each leg of a voice call as a ____. (Points : 5)

Loop

SIP setup line

Channel

Ping

Question 3. 3. (TCO3) Known as ‘connectionless networking’, this protocol employs a method where IP datagram are sent over a network using a ‘best-effort’ approach. The recipient would not know if the packets sent were received by the intended recipient. (Points : 5)

UDP

TCP

ICMP

H.323

Question 4. 4. (TCO4) These are facility connections from the phone company switch to the residential analog telephones; or the term used for delivering dial-tone to a group of phones. (Points : 5)

Tip-ring

Lines

Trunks

Call links

Question 5. 5. (TCO5) Used by hackers to see vulnerabilities and gain access, it is a systematic process that attempts to identify all of the open and available services on a TCP/IP host. (Points : 5)

Firewall scan

DNS scan

Port scan

DMZ scan

Question 6. 6. (TCO6) This is a call accounting software that is retrieved from a PBX, where the incoming and outgoing call information are logged. The logged information can contain data as date, time, extension, trunk, caller ID, and duration of call. (Points : 5)

Call Database

SMDR

PBX log files

ACD

Question 7. 7. (TCO7) Along with CTI and ACD, this is a PBX supported application where multiple phones, telephony processes, phone operators, IVR, complex dial-plan, and hunt groups, run in a confined space and take information from customers, then, facilitate a response over the phone. (Points : 5)

Call Center

Auto Attendant

Intercom calling

Conferencing

Question 8. 8. (TCO10) This was the first VoIP standard, ratified by ITU-T in 1996, that addressed having real time communications for video and voice in an unreliable packet network, and applied for PBX-styled signaling that supports packet-based networks. (Points : 5)

SNMP

Megaco

H.323

SIP

Question 9. 9. (TCO11) This layer organizes and synchronizes dialogues between presentation entities in the OSI 7-Layer Communications Model, (Points : 5)

Data Link Layer

Transport Layer

Session Layer

Address of Destination

Question 10. 10. (TCO12) In Ethernet transmission, this is the result when two nodes transmit at the same time, which leads to data loss, re-transmission, delay, or latency. (Points : 5)

Error control

Termination

Collision

Multiple Station Access

Essay Questions (20 points each)

Question 1. 1. (TCO3) Name and explain the three most important factors that you must protect when Securing a VoIP Network. (Points : 20)

Question 2. 2. (TCO4) What makes coaxial cable popular among broadband applications to customer premises? Discuss its advantages. (Points : 20)

Question 3. 3. (TCO7) Out of CLECs, ILECs, and TSPs, which of these companies would use VoIP to offer voice services? Explain why. (Points : 20)

Question 4. 4. (TCO10) Briefly explain the importance of a Gateway in the VoIP infrastructure. (Points : 20)

Question 5. 5. (TCO5) How can it be determined if an ACD has been effective? What information would be provided from the ACD that would be viewed as valuable? List and define three reasons. (Points : 20)

1. (TCO6) What is a TMN? Discuss at least two Management Layers of TMN. (Points : 30)

Question 2. 2. (TCO8) What are the advantages and disadvantages of replacing a traditional PBX-type phone system with a Wireless IP phone? (Points : 30)

Question 3. 3. (TCO9) What role, if any does, VoIP play in terms of the call center space? (Points : 30)

Question 4. 4. (TCO11) Describe what a converged network is and what benefits are derived from that. (Points : 30)

Question 5. 5. (TCO12) When deploying a VoIP system, what are some of the critical components that should be looked at in terms of assessing the environment for the readiness of a VoIP deployment? (Points : 30)

Think of three simple tasks where you believe the sequence of instruction matters.  Is there a way to modify it to where sequence doesn’t matter?   Find steps in each task where the sequence can be changed and still achieve the desired outcome.  Write out the original and modified algorithms AND pseudocode for each task. Write a short paragraph for each task describing the changes in sequence.

Minimum requirements:

• A minimum of one paragraph for each of the three tasks (three paragraphs total).
• Two algorithms and two pseudocode statements for each of the three tasks (6 algorithms and 6 pseudocode statements total)
• Submit only one document via the link title above.
• Use paragraph structure. Use complete sentences and proper grammar and spelling.
• Include a cover page that contains your name, the assignment name, and the course code from page two of the syllabus.
• Your document must be one of the following formats (.doc, .docx, or .rtf).
• Cite any and all sources

After reading the chapter by Capri (2015) on manual data collection.  Answer the following questions:

1. What were the traditional methods of data collection in the transit system?
2. Why are the traditional methods insufficient in satisfying the requirement of data collection?
3. Give a synopsis of the case study and your thoughts regarding the requirements of the optimization and performance measurement requirements and the impact to expensive and labor-intensive nature.

In an APA7 format answer all questions above.  There should be headings to each of the questions above as well.  Ensure there are at least two-peer reviewed sources to support your work. The paper should be at least 2 pages of content (this does not include the cover page or reference page).