ERD Diagram, Project, Using MySQL

  

Build out the ERD diagrams for the entire solution based on the following questions (you must have at least 3 tables for full credit, there is no limit based on your simplification of the data. The simplification of the data should follow the in-class examples of data, with no duplication in tables)

Provide 

I. The MYSQL code (within the word document) to build the database and tables

II. The MYSQL code (within the word document) to answer each of the following questions

III. Provide screen shots answering each question along with any supporting text

The answers must be done in SQL, not table presentation and manual interpretation of the data

Questions :

1. What is the total revenue for the year? 

2. What is the gross profit for the year? (based only on what is in the tables)

3. How much revenue did each wine provide for the year?

4. What is the Average revenue per month per location for the year?

5. What is the final inventory of the Premium Red wine?

6. If the retail price of the wine increases by 10%, what is the gross profit margin ?

7. How many bottles of the different wines were ordered in July? 

8. What is the revenue per year per restaurant?

Write an essay of at least 500 words discussing discussing how a blockchain implementation would improve data security in a military, education, or other context.

Write in essay format not in outline, bulleted, numbered or other list format.  

Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaningful title.

 Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations). 

Assignment,Due Date 19th July

 

 Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study 

My course details:  Descriptive Statistics ,  Paired and Independent samples t-tests .

  1. describe the essential characteristics of quantitative research.
  2. Apply inferential statistical tests on problems requiring parametric and non-parametric analyses.
  3. Identify potential research designs for various problems.
  4. Analyze statistical information in the professional literature on a topic related to their own research project. 

 Note: Minimum 500 words not including title and reference page. References should be taken from peer revived 

 Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited. 
Share a personal connection that identifies specific knowledge and theories from this course. 
Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.  
You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace

Assignment

1. There are n marble balls, one of which is made of a different material. You have access to a Comparator that can compare two inputs (of an arbitrary number of marble balls) and determine if the two inputs are the same or not. The problem is to find the single marble ball that is different from the others while minimizing the number of times you access the Comparator. Design an efficient algorithm based on prune-and-search to solve the problem. Derive the time complexity of your algorithm.

2. Exercise 14.3-6 (page 354). Use an example to demonstrate your augmented data structure and operations.

(14.3-6 Show how to maintain a dynamic set Q of numbers that supports the operation MIN-GAP, which gives the magnitude of the difference of the two closest numbers in Q. For example, if Q D f1; 5; 9; 15; 18; 22g, then MIN-GAP.Q/ returns 18 15 D 3, since 15 and 18 are the two closest numbers in Q. Make the operations INSERT, DELETE, SEARCH, and MIN-GAP as efficient as possible, and analyze their running times.). This is the exercise question 14.3-6 as mentioned above.

Research Paper Bitcoin Economics

 Articles:  

WALDO, J. (2019). A Hitchhiker’s Guide to the Blockchain Universe. Communications of the ACM, 62(3), 38–42. https://doi.org/10.1145/3303868 

PAVLUS, J. (2018). The World Bitcoin Created. Scientific American, 318(1), 32–37. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=buh&AN=126727561&site=eds-live

Question:

This week’s reading centered around Bitcoin Economics.  For this  week’s research paper, search the Internet and explain why some  organizations are accepting and other organizations are rejecting the  use of Bitcoins as a standard form of currency.  Your paper needs to  identify two major companies that have adopted Bitcoin technology as  well as one that has refused accepting Bitcoin as a form of currency. Be  sure to discuss each organization, how they adopted (or why they won’t  adopt) Bitcoin, and what recommendations you have for them to continue  to support Bitcoin (or why they should support Bitcoin). 

Your paper should meet these requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page.
  • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at  least two scholarly journal articles to support your positions, claims,  and observations, in addition to your textbook. The UC Library is a  great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent  grammar and style techniques. You are being graded in part on the  quality of your writing.

Power Point presentation as it applies to USB Thumbdrives

Create a PowerPoint presentation, outlining the content of your paper. At a minimum include the following:

Detailed description of the area researched

Technology involved in the area

Future trends in the area

Example companies involved in the area

Regulatory issues surrounding the area

Global implications for the area

References (minimum of 10)

Submission Instructions: A PowerPoint presentation with a minimum of 10 slides [not including title slide and reference slide(s)].

Process Synchronization Using Monitor and Pthreads

 

The purpose of this programming project is to explore process synchronization. This will be accomplished by writing a program to solve the bounded buffer problem using monitor concept. Your program must be written using C or C++ and you are required to use the Pthread libraries. 

Bounded buffer is used to enable multiple producers and consumers processes to share memory. A producer can place items into the buffer only if the buffer has a free memory location to store the item. A producer cannot add items to a full buffer. A consumer can remove items from the buffer if the buffer is not empty. A consumer must wait to consume items if the buffer is empty. The “items” stored in this buffer will be integers. Your producer processes will have to insert random numbers into the buffer. The consumer processes will consume a number. 

Web Development Timeline and/or Cycle COLLAPSE 1 page paragraph

 

Web Development Timeline and/or Cycle
COLLAPSE

No two websites are developed the same, but there are likely timelines and best practices. Phrases I would focus on would be customer-focussed, user-focussed, internal communication, and external communication.

This is NOT you casually talking about topics. 

You should be REPORTING EVIDENCE and EXAMPLES from what you read.

  1. Identify the topic for this week. The title of this discussion board thread lists topics 
  2. Find three high-quality sources of related information on the Internet. 
  3. Read your chosen high-quality sources of related information.
  4. state your three sources of information.
  5. DESCRIBE each of the three sources of information within a few sentences providing EXAMPLES.
  6. SUMMARIZE with three things about the topic that you want to remember forever.