Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IF THE PICTURE IS NOT VIEWABLE, PUT YOUR EMAIL IN THE COMMENTS BOX, I CAN SEND YOU THE PICTURE AND THEN YOU CAN POST IT

IF THE PICTURE IS NOT VIEWABLE, PUT YOUR EMAIL IN THE COMMENTS BOX, I CAN SEND YOU THE PICTURE AND THEN YOU CAN POST IT HERE. DO NOT ASK TO UPDATE IT BECAUSE THE PLATFORM HAS ITS LIMIT. image text in transcribed

Create a node and express application, called app.js, that allows weather descriptions to be added to a database. The weather description table should have the following columns. Location Date and time Description Lowest temperature in Celsius Highest temperature in Celsius Average Wind Speed Average Wind Direction Sqlite should be used as the database engine. The form created in the previous exercise can be used to add a new weather record. Alternatively, you can design your own form. The application should provide a page the allows weather records to be added, deleted, and edited. This page should contain all the weather descriptions sorted by date and time. Each record should be editable. The application should provide a web page that contains five buttons that generate the following reports. The location and time of a record with the maximum temperature. The location and time of a record with the minimum temperature. The average minimum, maximum temperature and the average wind speed and direction for all records. The average minimum and maximum temperatures for each unique location. A sorted list of all the records by time. All the information for each record should be displayed. Pressing a button should either generated a new page with the report or update the current page with the report. The editing page and report page should provide links to the other editing or report page. CSS should be used to make the page layout look similar. The index.html page for the application should contain links to the editing and the reporting pages. This application should be stored in a directory called weather. The weather directory should contain the complete node application (i.e. package.json, any javascript, html, and css files). The node_modules directory should not be included (the marker will use npm install to create the required node_modules directory). The provided directory will be used to run and test the application. A database file should be provided that has at least 10 records. This database will be used to test the report generator. Create a node and express application, called app.js, that allows weather descriptions to be added to a database. The weather description table should have the following columns. Location Date and time Description Lowest temperature in Celsius Highest temperature in Celsius Average Wind Speed Average Wind Direction Sqlite should be used as the database engine. The form created in the previous exercise can be used to add a new weather record. Alternatively, you can design your own form. The application should provide a page the allows weather records to be added, deleted, and edited. This page should contain all the weather descriptions sorted by date and time. Each record should be editable. The application should provide a web page that contains five buttons that generate the following reports. The location and time of a record with the maximum temperature. The location and time of a record with the minimum temperature. The average minimum, maximum temperature and the average wind speed and direction for all records. The average minimum and maximum temperatures for each unique location. A sorted list of all the records by time. All the information for each record should be displayed. Pressing a button should either generated a new page with the report or update the current page with the report. The editing page and report page should provide links to the other editing or report page. CSS should be used to make the page layout look similar. The index.html page for the application should contain links to the editing and the reporting pages. This application should be stored in a directory called weather. The weather directory should contain the complete node application (i.e. package.json, any javascript, html, and css files). The node_modules directory should not be included (the marker will use npm install to create the required node_modules directory). The provided directory will be used to run and test the application. A database file should be provided that has at least 10 records. This database will be used to test the report generator

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

135 001+2)

Answered: 1 week ago