Deliverable Length:

1 IPO Model, 1 Pseudocode, 1 Visual Logic Flowchart, 1 Output Display

The Restaurant Supply Warehouse requires an algorithm which will keep track of a customer’s appliance purchases at the Restaurant Supply Warehouse. Customers will not know exactly how many items they will purchase as they browse the store. (Hint: a For loop will not work.)

Requirements

• Accept the appliance name and price of each appliance purchased from the customer until the customer is finished.
• When purchases are complete, the customer will specify they are done by stating they have no further purchases.
• Keep track of the name and dollar amount of each appliance purchased.
• Keep a tally of the number of appliances purchased.

Once purchases are complete, display the following:

• The name and price of each appliance purchased
• The subtotal of all appliances purchased
• The tax
• The tally of the total number of appliances purchased
• The total cost of all appliances purchased

Bonus: What is required to show the list of appliances and prices in reverse order?

Please submit a .zip file with one Word document containing 1 IPO Model, 1 Pseudocode, 1 Visual Logic Flowchart, and 1 Output Display.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

•  A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
•  A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
•  A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:

1. Design a data model that will conform to the following criteria:
   1. Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.
   2. Create naming conventions for each entity and attributes.
   3. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
2. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.
3. Using the salesperson table described in the summary above, complete the following:
   1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).
   2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.
   3. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

 

As noted by Janssen, Wimmer and Deljoo (2015), the technological debate centers around technology and humans, technology and society, and technology itself. The question is: Who drives technology?

1. Are humans the drivers of technology or does technology drive humans?
2. Does technology possess any values of its own and are these values given to technology by humans or does technology have no values whatsoever and is it completely neutral?
3. What is the relationship between technology and society, does technology constitute society or is it the other way around?

Elaborate on each of the drivers of technology. Make sure to include your opinion for each driver.

Research paper should be at least 3 pages (800 words), double-spaced, have at least 4 APA references, and typed in an easy-to-read font in MS Word (other word processors are fine to use but save it in MS Word format).

 

1. Objectives

• To practice the formal procedure of system/network security analysis and planning.
• To examine the vulnerability and security needs of a private organization.
• To devise strategies to overcome potential malicious attacks, threats, and risks.

1. Target Network

You have just been hired as an Information Security Officer (ISO) for a mobile app development company. The organization network structure is identified in the below network diagram and some services may inadequate and absent. 

The network specifically contains:

• 2-Switches
• 1-Web/FTP server with Linux operating system using port 80 and port 21
• 1-Email Server with Exchange 2010 using port 25
• 2-Active Directory Domain Controllers (DC) with Windows Server 2016 operating system
• 2-Domain Name Service (DNS) Servers with Windows Server 2016 operating system
• 2-Windows file servers using port 21
• 3-Wireless Access Points (WAP) encrypted with WEP protocol.
• 100 – Desktop/Laptop computers with Windows 10 operating system
• 2- Multifunction printers (print, copy, scan, fax)
• 1- Voice Over IP (VOIP) telephone system with 100 IP phones

The company is in a single, two story building with no fencing. The entire building is accessed using a permanent 4-digit pin.  A single security guard is located on the second floor of the building.  The security guard works Monday – Friday, 8AM to 5PM. Users are in open area cubicles on the first floor of the building. The employee work area is an open floor with no wall separating areas. The data closet is also located on the first floor of the building near the front entrance and the HVAC system in the middle of the first floor. The data closet is accessible by anyone who knows the 4-digit permanent pin that is distributed to all employees.  The facility maintenance generally cleans the building on the weekends when building with no employees or security personnel present.

1. Assignment Details

The Chief Information Officer (CIO) has seen reports of malicious activity increasing and has become extremely concerned with the protection of the intellectual property and highly sensitive data maintained by your organization. As one of your first work assignments with the company, the CIO requested you identify and draft a report identifying potential malicious attacks, threats, and vulnerabilities specific to your organization. In addition, the CIO would like you briefly explain each item and potential impact it could have on the organization.

Write a four to six (4-6) page paper in which you:

• Analyze five (5) or more specific potential malicious attacks and/or threats that could be carried out against the network and organization.
• Explain in detail the potential impact of the five (5) or more selected malicious attacks.
• Propose at least nine (9) – 3 of each type of security controls (administrative, logical/technical, and physical) that you would consider implementing to protect against the selected potential malicious attacks.
• Analyze three (3) or more potential risks for data loss and data theft that may exist in the documented network and applications.
• Explain in detail the potential impact of the three (3) or more selected risks for data loss and data theft.
• Propose at least three (3) – 1 of each type of security controls (administrative, logical/technical, and physical) that you would consider implementing to protect against the selected risks for data loss and data theft.
• List and provide a product overview of only two (2) alternatives for each logical/technical security control for both data loss/theft and malicious attacks. Include web links to the products and why those products should be considered.

Expectations

• Use at least five credible and quality resources. Your external resources should not be more than two to three (2-3) years old.

Note: Wikipedia and similar websites do not constitute as credible and quality resources.

• Single Word document
• Double spaced
• Times New Roman, size 12 font
• One-inch margin on all sides
• Citations and references must follow APA format
• Include a cover page containing:
  • Title of the assignment
  • Student’s name
  • Professor’s name
  • Course title
  • Assignment due date

Note: The cover page and reference page are not included in the assignment page length requirement.