Category: Programming

Create the following SQL scriipt (Save as w6_darryl_dixon.sql) .
Create a simple Database with the following
1) Create insert scriipt (10 inserts)
2) Create update scriipt (10 updates)
3) Create the following:-
a) Select all records
b) Select all records sorted descending , ascending
c) Select all records with condition (where)
d) Count all records
e) Count all record with condition
4) Create 3 delete scriipts

Case Study Running a Multi-Unit Independent Restaurant Group(Using Restaurant 365)
Please you should know how to use (Restaurant 365) before accepting.
I will give more details about how to log in after accepting.
https://unlvsp24student15.restaurant365.com/?state…
You need to follow the guide in the PDF to complete it on Restaurant 365
Requirements: follow the guide in the PDF to complete it on Restaurant 365

Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.
Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.
Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.

Components – Pancreas
The pancreas is a vital organ located in the upper left abdomen, behind the stomach and in front of the spine. It plays a critical role in digestion and maintaining blood sugar levels.
Functions and Importance
The pancreas produces digestive enzymes that are released into the small intestine to help break down proteins, carbohydrates, and fats
The pancreas also produces hormones, including insulin and glucagon, that help regulate blood sugar levels
Insulin helps the body’s cells
glucose (a type of sugar) from the bloodstream, while glucagon helps release stored glucose when blood sugar levels drop
In conclusion, the pancreas plays critical roles in digestion and maintaining blood sugar levels. It produces digestive enzymes that aid in breaking down food and hormones that help regulate blood sugar.
Salivary System: Role and Importance
The salivary system plays a crucial role in the digestive process. The following are some of the key points regarding the role and importance of the salivary system:
Production of Saliva: The salivary system is responsible for producing saliva, which is a mixture of water, electrolytes, enzymes, and antibacterial compounds.
Digestion: The enzymes present in saliva, such as amylase, begin the digestion process by breaking down carbohydrates into simple sugars.
Moistening and Lubricating Food: Saliva helps moisten and lubricate food, making it easier to swallow.
Antibacterial Properties: The antibacterial compounds present in saliva help protect the mouth and digestive system from harmful bacteria.
Speech: Saliva also plays a role in speech, as it helps form sounds and words.
Taste: The taste of food is enhanced by saliva, as it helps dissolve chemicals in food and allows taste buds to detect flavors.
Overall, the salivary system plays a vital role in the initial stages of digestion, as well as in maintaining oral health and overall well-being.
Functions of the Respiratory System
The primary function of the respiratory system is to facilitate the exchange of gases between the body and the environment.
The nose and mouth filter, warm, and humidify incoming air, while the trachea and bronchi transport the air to and from the lungs.
The diaphragm and the muscles of the ribcage work in concert to allow us to breathe in and out by changing the volume and pressure within the lungs.
The alveoli are the site of gas exchange, where oxygen from the air we breathe is absorbed into the bloodstream and carbon dioxide is expelled from the body.
Additional Notes
The respiratory system also plays a role in protecting the body from harmful substances in the air we breathe, such as bacteria, viruses, and allergens.
The production of mucus and the movement of hair-like structures called cilia in the airways help to trap and remove these substances from the body.
Respiratory disorders such as asthma, emphysema, and chronic bronchitis can significantly impair lung function and lead to serious health complications.
Proper care and maintenance of the respiratory system, such as avoiding smoking, exercising regularly, and getting vaccinated against respiratory illnesses, can help to promote optimal lung health and prevent respiratory disease.

I have to make a Visualization in Tableau for the sports dataset. Req built 5-8 visualizations using the dataset. Try to incorporate parameters, filters, dual axis, sets, or some other advanced techniques. I will provide you the data set, as file link https://www.raed.net/file?id=848947 dataset is big, Visualization should be about most of the years. I Have to present the final Dashboard.

Use the CSV data file provided below to complete the “Coffee Chain Demo” presented in Chapter 8 of the Murray text. Start with a new, empty workbook; do not use the starter workbook provided by the author if you happen to find it online. Your workbook should contain your worksheets and the final dashboard
I have included the following PowerPoint slide set which contains screen images from each worksheet showing dimensions and filters. Use the FSCJ logo instead of the InterWorks logo displayed in the textbook and slides. To download the logo file, right-click the image below and select “Save Link As” or “Save Image As.”
(I had to zip the CSV file to upload it here you can unzip it)

summary 2-4 paragraphs will write and a brief summary of the important concepts using the file below.
2nd separate assignment is answer these 4 discussion posts, reply should be 5-6 sentences for each discussion:

Program 1 Roman Numerals: 
Design a program that prompts the user to enter a number within the range of 1 through 10. The program should display the Roman numeral version of that number. If the number is outside the range of 1 through 10, the program should display an error message. 
Program 2 Change for a Dollar Game:
Design a change-counting game that gets user to enter the number of coins required to make exactly one dollar. The program should ask user to enter the number of pennies, nickels, dimes, and quarters. If the total value of the coins entered is equal to one dollar, the program should congratulate the user for winning the game. Otherwise, the program should display a message indicating whether the amount entered was more than or less than one dollar.

The Task:
Write a program in PLP assembly that counts up by one starting from zero (or one) inside a loop and writes this
value to the LEDs every time the value is increased. The memory address of the LEDs is 0xf0200000.
check the attached pdf to get the whole idea

Which of the following statements best describes the transport layer of the TCP/IP hierarchical model?
Question 11 Choose one:.
(1) The main roles of the transport layer communication protocols are IP address management and routing.
(2) The main role of transport layer communication protocols is to control the standards of wired LANs and the hardware standards that comprise them.
(3) The main role of transport layer communication protocols is to determine and implement data transfer methods.
(4) The main role of transport layer communication protocols is to convert the data of a communication application into a data format that a computer can understand.
Which of the following statements best describes TCP and communication using TCP?
Question 21 Choose one:.
(1) It is a communication protocol that leaves data in packet units and does not perform error checking.
(2) Communication using TCP is connection-based communication.
(3) Communication using TCP is connectionless communication.
(4) TCP is used for communications that require real-time transmission of information, such as IP telephony and Internet video relay.
Which of the following statements best describes the TCP header?
Question 31 Choose one:.
(1) [1] Sender port number (16 bits), [2] Receiver port number (16 bits), [3] Sequence number (32 bits), [4] Acknowledgement number (32 bits), [5] Data offset (4 bits), [6] Reserved (6 bits), [7] Control flag (6 bits), [8] Window size (16 bits), [9] checksum (16 bits), [10] emergency pointer (16 bits), [11] options and [12] padding are written.
(2) The checksum is used as a means of communicating the communication status to the communicating party.
(3) Only the sending port number (16 bits), receiving port number (16 bits), length (16 bits) and checksum (16 bits) are written.
(4) The sequence number is used as data to identify which communication application created the data at the sending application layer.
Which of the following statements best describes the port number?
Question 41 Choose one:.
(1) The port number used by the client, reserved in the range 0 to 1023, is called the well-known port and is assigned to the communication application.
(2) The port number used by HTTP is 80.
(3) The port number used for SMTP is 110.
(4) The port number used by the communication application for the server is the same as the port number used by the communication application for the client.
Which of the following statements best describes the procedures for communication by TCP?
Question 51 Choose one:.
(1) The amount of data a receiver can receive at one time is called the segment size.
(2) The checksum of the TCP header is used as a means of communicating the communication status to the communication partner.
(3) The control flag SYN is used to establish a connection and Fin is used to terminate a connection, but these requests are always confirmed by the ACK flag, which is an acknowledgement.
(4) A number is written in the acknowledgement number of the TCP header to indicate where the split received data was located in the transmitted data so that it can be recovered by the receiving side.