Cyber security

Cryptography Homework

Part 1: Find good encryption solutions

1. Search the web for various commercial encryption algorithms.
2. Find one that you feel may be “snake oil”.
3. Write a report explaining the encryption algorithm and your opinion
   *in-text citations and references are required
   *written in at least 2~3 paragraphs

Project: Building a Relational Database Management System

 This project is where you show off your ability to (1) translate a business requirement into a database design, (2) design a database using one-to-many and many-to-many relationships, and (3) know when to use LEFT and/or RIGHT JOINs to build result sets for reporting.

An organization grants key-card access to rooms based on groups that key-card holders belong to. You may assume that users below to only one group. Your job is to design the database that supports the key-card system.

There are six users, and four groups. Modesto and Ayine are in group “I.T.” Christopher and Cheong woo are in group “Sales”. There are four rooms: “101”, “102”, “Auditorium A”, and “Auditorium B”. Saulat is in group “Administration.” Group “Operations” currently doesn’t have any users assigned. I.T. should be able to access Rooms 101 and 102. Sales should be able to access Rooms 102 and Auditorium A. Administration does not have access to any rooms. Heidy is a new employee, who has not yet been assigned to any group.

After you determine the tables any relationships between the tables (One to many? Many to one? Many to many?), you should create the tables and populate them with the information indicated above.

Next, write SELECT statements that provide the following information:

• All groups, and the users in each group. A group should appear even if there are no users assigned to the group.

• All rooms, and the groups assigned to each room. The rooms should appear even if no groups have been assigned to them.

• A list of users, the groups that they belong to, and the rooms to which they are assigned. This should be sorted alphabetically by user, then by group, then by room.

HI.... just I want the <tags> of this scenario ....

Scenario-based Problem:
You are assigned to develop a web based Online Electronic showroom in the Sultanate of oman using HTML 5 with CSS, basic JavaScript and PHP&MySQL. The website should contain the following webpages:

•  Homepage

•  Sign In

•  Sign Up

•  About Us

•  Product Details

•  Feedback

•  Contact Us

  Following are the details about each page:

  Page-1: HOMEPAGE (Design using Bootstrap)

  This page should have picture/s, background color, text/headings with suitable font with link to all other pages and CSS.

  Page-2: ABOUT US

  This page should have a brief description of the company. This should contain a paragraph with sufficient text color, formatting tags, images, links and CSS.

  Page-3 and 4:Product DETAILS

  Each page should contain Tables with column span and row span, CSS, images, formatting tags, etc. Include any video related to the topic.

  Page-5: SIGN IN (No database)

  This should contain the login form with validations using HTML5, PHP form handling, database connectivity.

  Page-6: SIGN UP

  This should contain the Registration form with validations using JavaScript, PHP form handling, database connectivity. Display the records from the table.

  Page-7: FEEDBACK (No database)

  This should contain the Feedback form with validations using HTML 5 and PHP form handling. Display the feedback.

Page-8: CONTACT US

This should contain a paragraph with sufficient text color, formatting tags, images, links, CSS etc. Note: Kindly refer to the marking scheme for more information and clarity.

The number of cell phone subscribers in the United States between the years 2000 and 2010 is approximated by the function N(t) = 385.474 1 + 2.521e−0.214t (0 ≤ t ≤ 10) where N(t) is measured in millions and t is measured in years, with t = 0 corresponding to the year 2000.† How many cell phone subscribers were there in the United States in 2000? (Round your answer to one decimal place.) million subscribers.

If the trend continued, how many subscribers were there in 2011? (Round your answer to one decimal place.) million subscribers

The monthly absolute estimate of global (land and ocean combined) temperature indexes (degrees C ) in 2000 and 2001 are: 2000: 12.28, 12.63, 13.22, 14.21, 15.13, 15.82, 16.05, 16.02, 15.29, 14.29, 13.16, 12.47

2001: 22.44, 12.55, 13.35, 14.22, 15.28, 15.99, 16.23, 16.17, 15.44, 14.52, 13.52, 12.61

a) Graph the data and fit a regression line to predict 2001 temperatures from those in 2000. Is there a significant regression at ∝ = 0.05? What is P-value?

b) Estimate the correlation coefficient.

Please solve question without using software

For each counties in the metro area, it gives an estimate of the population on Jan. 1, 2000, and the percent change between 1/1/2000 and 1/1/2010. If we assume that the percent change for each county is constant, then the population of each county can be modeled using an exponential function with a growth rate given by the annual percentage change.

1. Find an exponential function of the form P(t)=P₀e^kt , which gives the population of the county in the year 2000 + t.
2. Evaluate the function at t = 16 and give a verbal interpretation of your answer.
3. Find the derivative of the function.
4. Evaluate the derivative at t = 16 and give a verbal interpretation of your answer.

The following data give the average price received by fishermen for several species of fish in 2000 and 2010. The price is in cents per pound.

1. Create a regression equation for the data.
   
   ˆy=y^= Round to 2 decimal places.
   
2. What is the correlation coefficient between the 2000 and 2010 prices.
   
   Round to 2 decimal places.
   
3. If a type of fish was 41.3 cents per pound in 2000, how much would you expect to pay for it in 2010?

1. Which of the following best describes a dimension table in a star schema:

1. Most attributes will likely be text
2. Most attributes will likely be numeric
3. The primary key should be a single integer surrogate key
4. Both a. and c.

2. Which of the following best describes a fact table in a star schema:

1. Most attributes will likely be text
2. Most attributes will likely be numeric
3. The primary key should be a single integer surrogate key
4. Both a. and c.

3. Which of the following best describes an advantage(s) of a snowflake schema:

1. It slows down queries by forcing more joins between dimension tables
2. It allows facts to be stored at different granularities of a dimension in a multi-star schema (e.g. day and month granularities of a date dimension)
3. Facts that are at the lowest level of the dimension can be more easily summarized at higher levels of the dimension than they can with a pure star schema by precomputing aggregates
4. Both b. and c.

Transactions and Recovery:

4. Which of the following best describes the atomicity property in regards to transactions:

1. Either all actions in a transaction are executed or no actions are done
2. The DBMS changes from one consistent state to another consistent state when a transaction completes successfully
3. A transaction executes with the same outcome, without any impact from other transactions executing concurrently
4. The DBMS guarantees that changes are made persistently upon successful completion of a transaction

5. Which of the following statements are true:

1. Verifying transaction consistency is the job of the semantic data controller
2. Managing consistency of transactions operating in parallel is the job of the concurrency controller
3. Both a. and b.
4. Neither a. nor b.

6. Which of the following statements best describes a phantom read:

1. A select from one user calculating a summary or aggregate function (e.g. avg, max, sum, etc.) reads some rows from a table. At the same time another user is updating some of those same rows to contain different values. The first user reads some of the rows before the update changes them and reads some rows after the update changes them.
2. One user reads the same row more than once. Between the reads, an update from another user modifies the row.
3. One user reads a set of rows from a table. Another user inserts a row that matches the where condition read by the first user. The first user reads the same set of rows again getting the new row in addition to the rows that the user read the first time.
4. Two users update the same columns of the same row of the same table at the same time. One update will be overwritten by the other.