ASSIGNMENT:

• Research a current or previous year article on any of the topics listed below or topics related to week the materials. Narrow down your topics if possible.
• Then, in a 2-3 page paper, write an applied summary paper. Applied means what you write from the viewpoint of a project manager in a work or project setting.

Suggested topics for the assignment include:

• Leadership
• Cybersecurity Project Management
• Software Development Management
• Database Project Management
• Cybersecurity
• IT Security
• IT Project Management
• Information Security Management
• Business Analytics

Activity 2: Injection Basics Injection attacks trick an application into including unintended commands in the data send to an interpreter.

Interpreters Interpret strings as commands such as SQL, shell (cmd.exe, bash)

Critical Thinking Questions: 1. What does a user/attacker see at the webpage? Where can an attacker enter exploit data/input? 2. Which entity builds user string input and send SQL query to Database server? 3. Which entity executes query including exploit and send back to web server and then user?  

Draw a relational model for the following case study.
Case Study
The local under-sixteen football league needs a database to help track teams, children
that sign up to play in the league, the parents of these children and the coaches for each
team.
The league wishes to record the details for each parent of a particular player (the parents
last name, first name, phone contact number and address). For each player, the system
needs to record the player's last name, first name, blood type and their date of birth. Any
allergies that the player has also need to be recorded.
A player may only play in one team with this league. Each team is given a unique id, the
system needs to record this id, the teams name, and the city their home ground is located
(a city may have several under-sixteen teams based in it). A team’s colours are also to be
recorded, teams may choose to use a single or multiple team colours. A team may have
several coaches – one of the coaches is designated as the head coach.
A coach is only permitted to coach one team in the under-sixteen leagues. All
communications from the league to the team are via the head coach. To be registered to
play in this league a team must have a head coach and at least one player. The database
needs to track a coach's first and last name, phone and address contact details and the
team that they are coaching.

Exercise 1

A company is planning to reconfigure storage for their accounting application for high availability

Current configuration and challenges:

Application performs 15% random writes and 85% random reads

Currently deployed with five RAID 0 configuration

Each disk has an advertised formatted capacity of 200 GB

Total size of the accounting application's data is 730 GB which is unlikely to change over 6 months

Approaching end of financial year, buying even one disk is not possible

Task

Recommend a RAID level that the company can use to restructure their environment fulfilling their needs

Justify your choice based on cost, performance, and availability

Exercise 2

The same company is now planning to reconfigure storage for their database application for high availability

Current configuration and challenges

The application performs 40% writes and 60% reads

Currently deployed on a six disk RAID 0 configuration with advertised capacity of each disk being 200 GB

Size of the database is 900 GB and the amount of data is likely to increase by 30% over the next 6 months

It is a new financial year and the company has an increased budget

Task

Recommend a suitable RAID level to fulfill the company's needs

Estimate the cost of the new solution (200GB disk costs $1,000)

Justify your choice based on cost, performance, and availability

Consider the following relational database schema:

            employee(employee-name, employee-id, street, e-city)

            works(employee-id, company-id, salary)

            company(company-name, company-id, c-city)

            manages(employee-id, manager-id)

Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below.

1. Retrieve the name and address of employees who work for First Bank Corporation.

2. Retrieve the name, street address, and city of residence of all employees who work for Thrifty Industries and earn more than $10,000 per year.

3. Retrieve the name of all employees who live in the same city as the company for which they work.

4. Retrieve the name of all employees who live on the same street and in the same city as do their managers.

5. Retrieve the name of all employees who do not work for First Bank Corporation.

6. Retrieve the name of all employees who earn more than every employee of Small Bank Corporation.

7. (Assume that companies may be located in several cities) Retrieve all companies located in every city in which Thrifty Industries is located.

8. For each company, find the average salary of employees working for that company.

9. For each city, find the number of employees who work for at least one company in that city.

You have been given the following specifications for a simple database about the requests for software that staff members make for their units (note that primary keys are shown underlined, foreign keys in bold). You should run your SQL to demonstrate that it works correctly, and paste in the statements used plus the output from Oracle.

LAB (RoomNo, Capacity)

SOFTWARE (SoftwareID, SoftwareName, Version)

REQUEST (SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress)

Based on the table specifications provided, answer the following questions.

a. Give the SQL to create the LAB and SOFTWARE tables. Choose appropriate data types. None of the attributes should be allowed to be null. Include the primary key constraints.

b. Give the SQL to create the REQUEST table. Use appropriate data types, and include the primary key and foreign key constraints. Referential integrity should be set such that if a lab is deleted from the database, any requests that exist for that lab are also deleted.

c. Give the SQL to add a record to each of the tables: LAB, SOFTWARE and REQUEST. Make up your own data (you may wish to add lab 350.2.006 to the LAB table for testing in part (e) later).

d. Give the SQL to create a constraint to the REQUEST table to restrict the possible values of Progress to the following 5: Requested, Installed, Function Testing, User Acceptance Testing, and Deployed.

e. Give the SQL to record the fact that the capacity of lab 350.2.006 has increased by 5.

Write the following questions as queries in Relational Algebra. Use only the operators discussed in class (select, project, Cartesian product, join, union, intersection, set difference and renaming —in particular, no outer joins or aggregations). Type your answers. If you can’t find Greek letters in your word processor, you can simply write out the operator, all uppercase (i.e. ’SELECT’). Please use renaming consistently, as indicated in the handout. Before starting, make sure you understand the schema of the database. If you are in doubt about it, please ask the instructor.

Assume a database with schema:

ACTOR(name,age,address,nationality)

MOVIE(title,year,genre,budget,director-name,studio)

APPEARS(name,title,salary)

Write the following questions in Relational Algebra:

1. List the titles and budgets of movies where actor Keanu Reeves appeared in 1999.

2. List the names and ages of actors who have appeared in a comedy produced by Studio ’MGM’.

3. List the names of directors who have directed a drama or a comedy.

4. List the names of directors who have directed a drama and a comedy.

5. List pairs of actors who have appeared together in a movie (note: the schema of your answer should be (name1,name2), where both name1 and name2 are names of actors.

3. Find the correlation and regression lines for the data above.

r=

LinReg(ax+b)=

During the 1990’s and 2000’s many public intellectuals, including economists, predicted that specialization according to comparative advantage would increase the standard of living both in the United States and in the countries with which it traded.

Discuss the benefits and costs of trade with China at the individual and national levels.