All posts by : chebby

CSC 102: Application Development for Beginners 

entering the site CODE.ORG with my user and pass 

then creat a game and start using the codes that the ask in the assignment  to make a game 

1.  How does prescriptive analytics relate to descriptive and predictive analytics?

2.  Explain the differences between static and dynamic models. How can one evolve into the other?

3.  What is the difference between an optimistic approach and a pessimistic approach to decision making under assumed uncertainty?

4.  Explain why solving problems under uncertainty some-times involves assuming that the problem is to be solved under conditions of risk.

5.  Investigate via a Web search how models and their solutions are used by the U.S. Department of Homeland Security in the “war against terrorism.” Also investigate how other governments or government agencies are using models in their missions.

Question Three [30 marks]

Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address, city and URL. Every country is identified by country code, country name and country currency. Guests staying in the hotel is identified by guest number, guest name, guest address and guest city. Every room in the hotel is identified by room number, and room floor. Every room booking is identified by booking id, starting date, and ending date. There are different types of rooms in the hotel. Each room type is identified by room type code, room standard rate, and description. In each country, there may be no hotels or more than one hotel. A hotel may have one or more rooms. A guest can book one or more rooms and a room may be booked by one or more guests. A hotel may have one or more bookings and each booking is associated with exactly one hotel. Each room type may have one or more rooms and a room belongs to one room type. 

1) Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. [4 marks]

How did you identify the primary key and foreign key? Explain.  [2 Marks]   

2) Use the designed relations to write SQL statements for the following questions:  –  Explain the working of each query in detail.

a. Display all the rooms having the same rate in the ascending order of room rate.  [5 marks]

b. List the number of hotels in each country. Only include countries with more than 4 hotels.  [4 marks]

c. Display the details of hotels that is not yet included in any booking. [4 marks]

d. Display all the details of guests who booked hotels on ‘2021-05-01’. [4 marks]

e. Display the room number, room standard rate and the hotel id. [4 marks]

f. Display the details of countries with country name starting with letters other than any letter within ‘A’ and ‘P’. [3 marks]

The final project for the course is a technical blog post related to a data analysis project you will work on piecemeal over the course of the semester. 

The project is very open ended. The objective is to demonstrate your skill in asking meaningful questions of your data and answering them with results of the data analysis using R / Rmarkdown, and that your proficiency in interpreting and presenting the results.  The goal is not to conduct an exhaustive data analysis. The data analysis part should meet the following criteria:

1. Perform exploratory data analysis summarizing your data using descriptive statistics / summary statistics and visualizations relevant to your questions or ones that highlight some interesting insight.

2. Demonstrate at least two of the following techniques we have learned in class and that helps answer your question: PCA, hypothesis testing / confidence interval, regression analysis (linear /logistic) 

Proposal

The first task is to identify the dataset, understand the data and write questions you are planning to answer using that dataset. You may pick a data set from one of the resources mentioned on this webpage (Links to an external site.).  The proposal should meet the following criteria:

1. Perform checks to determine quality of the data (missing values, outliers, etc.)

2. Proposal on what questions you are interested in answering from the data

3. Initial visualizations and if required transform to get the data ready 

A good reference for ideas on questions and EDA in general: https://r4ds.had.co.nz/exploratory-data-analysis.html#questions

More information on the format:

It should be about 2+ pages in length, not exceeding 10 with appendix. It should include roughly the following sections:

1. Background or the context of data selected – sources, description of how it was collected, time period it represents, context in it was collected if available, perhaps why you selected it

2. Description of the data – how big is it (number of observations, variables), how many numeric variables, how many categorical variables, description of the variables

3. Goal – What questions you plan to understand from the data. 

3. Analysis – Descriptive statistics and visualization of key variables 

4. Summary of findings from the analysis and further questions for future analysis

5. References – link to data or analysis sources you have referenced for the report

6. Appendix – all the visualization that does not support your questions directly can go here

Final Write-up

The project should include

1. Introduction: What is your research question? Why do you care? Why should others care? If you know of any other related work done by others, please include a brief description.

2. Data: Include context about the data covering:

a. Data source: Include the citation for your data, and provide link to the source.

b. Data collection: Context on how the data was collected?

c. Cases: What are the cases (units of observation or experiment)? What do the rows represent in your dataset?

d. Variables: What are the variables you will be studying?

e. Type of study: was it an observational study or an experiment?

f. Data clean-up: (Optional) If you had to do any data clean up (missing values, outliers, transformation), include a very brief description of your steps.

3. Exploratory Data Analysis: summarize your data using descriptive statistics / summary statistics and visualizations relevant to your questions or ones that highlight some interesting insight. Additional plots not relevant to your research question can be included in the appendix.

4. Data Analysis: Pick and perform two of the following techniques we have learned in class and that helps answer your question about the dataset: PCA, hypothesis testing / confidence interval, regression analysis (linear /logistic) 

5. Conclusion: Summarize your findings and include a discussion of what you have learned about your data through this project. You may also want to include limitations of your approach and include ideas for possible future work. 

6. References: Include links that you have referenced for this project.

Data

 Read Google’s Handling of the “Echo Chamber Manifesto” and complete the questions at the end of the case study. (https://www.scu.edu/ethics/focus-areas/business-ethics/resources/googles-handling-of-the-echo-chamber-manifesto/)

– The answers should be a minimum of two pages with two references attached for each. There should be no plagiarism- attach a plagiarism report with 0% similarity index.   

one page summary of news article

analyze asymmetric and symmetric encryption.  Evaluate the differences between the two of them and which one that you would determine is the most secure. 

2 full pages and 3 APA references.

I need help with a database assignment

Pick only one topic:

-How to hack cryptocurrencies and block chain systems? What are the biggest weakness in those systems?

-Cloud security: Describe cloud security challenges and recent hacks and security controls to protect cloud environment

-Future of cybersecurity: Describe future of cybersecurity, what to expect in 5 year.

The attached pdf file introduces a real-world business problem as it presents the case study of some big online organizations that recently allow their customers to place their orders via Tweeter by using a Hashtag to place the items in their shopping  carts.

For your second individual case analysis, you need to critically analyze this case study, summarize the key idea, discuss the IT challenges and present your recommendations. This report will be organized as follows:

1.       Introduction – Short summary of the business problem. This section will also include a background of the organization.

2.       Challenges – Provide for a brief description of the challenges that the organization is facing and how they are planning to address them. This section will provide the audience with a picture of how the organization is planning to address some of the challenges.

3.       Change Management – Discuss how change is being managed by the organization. 

4.       Recommendations – Discuss what you would have done differently and why.

5.       Conclusions – Discuss the lessons learned and the key messages that you would like the audience to take away.

The report should not be more than 1000 words.