Description
Part 4: Queries and Forms (due in Week Five)
a) Queries
<Describe the types of information that should be retrieved from the database.>
b) Forms
<Explain your vision for what forms and menus should appear in the database application.>
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Really useful study material!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
3 pages
Eztech Movie Week 5 Discussions
In the previous weeks, we have effectively designed and implemented a database management system for our EZTechMovie proje ...
Eztech Movie Week 5 Discussions
In the previous weeks, we have effectively designed and implemented a database management system for our EZTechMovie project. This implementation has ...
create tables in database - java/ MySQL
Assignment InstructionsComplete the following steps for this assignment:Create a MySQL script that creates the tables in t ...
create tables in database - java/ MySQL
Assignment InstructionsComplete the following steps for this assignment:Create a MySQL script that creates the tables in the database with the appropriate primary and foreign keys.Your script must add data into the database tables. Every table must be loaded with at least two rows of data.Create screen captures showing the creation and contents of each table.Check and implement the database connectivity using JDBC.Check and implement exception handling for the database connectivity.Implement the Log-in action in your CapestraApp project, checking for the specified username and pass-word in the database and reporting a successful or unsuccessful log-in.Run your CapestraApp program and do screen captures of both successful and unsuccessful log-in attempts.Do not capture your entire desktop—just capture the individual screens.Paste all screen shots into a single MS Word document.Your name should appear at the top of the MS Word document.Name your document, following this pattern: LastName_Week5.docx.Create a .zip file containing your MySQL script file, your MS Word document, and a .zip of your CapestraApp project.Rename your .zip file, following this pattern: LastName_Week5.zip.SQL: CREATE ALL TABLES IN DATABASE; LOAD DATA INTO DATABASEOverviewTo integrate the functionality between the database and the application, you need to create the connection using JDBC. The JDBC API allows Java to connect to MySQL 5.7 using the MySQL Driver on any platform. The JDBC API allows Java to connect to the database, create and execute queries, and view and modify resulting records. Be sure to view the videos to guide you through the database creation and connection. You will need to create a MySQL script to create the ‘orderentrysystem’ database used by the CapestraApp application. The script must not only create all appropriate tables but also must load some sample data into each table. Note that just creating the database within MySQL Workbench does not satisfy the requirements of this assignment—you must create the database using a MySQL script file.This week’s assignment also includes a small programming assignment: You will create the semantics behind your revised Log-in scene. Currently your Log-in scene only provides the employee with a field for entering a username. Checking the SRS, you will see that the Log-in scene must provide for both a username and a pass-word. A successful log-in takes place only if both are provided to the system and they match what is in the orderentrysystem Employee table. You need to modify the Log-in scene to provide for a correctly functioning pass-word field, as well as using MySQL to determine whether the username-passwor-d combination matches an employee in the database. If a match is found, an appropriate message (including the employee's first name, last name, and employee ID) should be displayed to the user. If no match is found, an appropriate message should be displayed.In this assignment, you will create the database tables in MySQL 5.7 for the CapestraApp application. In addition, you will create and check the functionality to connect to the database from the application through a connector using JDBC. Use CapestraApp code provided to check that the database connection is correctly implemented. You need to ensure that exception handling is done correctly in case the database does not exist or if the connection fails.Check the SRS to see precisely what the Log-in action must do. Examine what is implemented in the CapestraApp template code to see what it does and how it does it. You’ll need to think about how to modify the existing code to meet the SRS requirements.
Cascading style sheet, programming homework help
Cascading Style Sheets are used to provide style, presentation, and layout for the HTML content of a Web page. You will de ...
Cascading style sheet, programming homework help
Cascading Style Sheets are used to provide style, presentation, and layout for the HTML content of a Web page. You will develop an external CSS to provide style, presentation, and layout to an HTML document.If you have not installed Microsoft Visual Studio Software in a prior course, follow these instructions for installation steps. Download the provided Unit2.zip document and save it to your computer. Click here to download the Unit2.zip document. Right-click the Unit2.zip folder and Extract All. Open Visual Studio and select File > Open Web Site from the menu.Navigate to the extracted Unit2 folder and select it to open the Website in Visual Studio. Select Website > Add New Item from the menu and select Style Sheet from Add New Item dialog box. Name the style sheet Unit2.css. Add style rules to Unit2.css to accomplish the following: Ensure that the semantic elements format in older browsers. Eliminate the default spacing around all elements. Use the Verdana font or any available sans-serif font for the text. Set the font size for the body to 80% of the browser’s default font size. Set the width of the window to display the document to 700. Center the text in the header. Provide spacing at the top of the level-one heading in the header to the equivalent of one capital M without affecting the spacing of the image. Set the font size for the level-one heading in the header to three times the browser’s default font size. Display the image in the header to the right of the text. Ensure the text of the section does not flow around the image in the header. Display the image in the first paragraph to the left of the text. Set the font size for the level-one heading in the section to two times the browser’s default font size. Center the text in the level-one heading in the section. Provide spacing at the bottom of the level-one heading in the section to the equivalent of one capital M. Set the font size for the level two headings in the section to one and one-half times the browser’s default font size. Center the text in the level two headings in the section. Center the text in the navigation. Provide spacing at the bottom of the navigation to the equivalent of two capital Ms. Bold the text of a hyperlink when the user hovers over the hyperlink or a hyperlink gets the focus. Set the text of a hyperlink to red when the user hovers over the hyperlink or a hyperlink gets the focus. Display the footer on the right side of the page. Set the font size of the text in the footer to 75% of the browser’s default font size. Validate the CSS style rules. Zip (compress) the Visual Studio project folder into a .zip file to submit.
CUMS Machine Learning Apply Dimension Reduction Techniques Case Study
Context/Background: The central idea is to use ML algorithms to recognize images, both static and dynamic, without specifi ...
CUMS Machine Learning Apply Dimension Reduction Techniques Case Study
Context/Background: The central idea is to use ML algorithms to recognize images, both static and dynamic, without specifically providing any guidance to the computer. This task is achieved by training algorithms to recognize various images while also mapping the feature space of those images to a categorical label or name. This task was first successfully achieved in the 1990s when computers were trained to recognize handwritten digits. The trained algorithm was used by postal services to sort mail and efficiently distribute it to the right destination. We will use the same dataset and problem for this case.The dataset is called MNIST (Modified National Institute of Standards and Technology). More information on MNIST can be found here: https://www.kaggle.com/c/digit-recognizer Use the only train.csvTo do: The main objective is to write a fully executed R-Markdown program performing dimension reduction techniques PCA, t-SNE, and UMAP on high dimensional image data using MNIST (digits) images that are 28 x 28 pixels resolution.Make sure to describe the final hyperparameter settings of all algorithms that were used for comparison purposes. Need rmd and pdf for this request.
Similar Content
Need Help Original Work Please
Assignment 1: Financial Portfolio Due Week 6 and worth 200 pointsThis assignment consists of two (2) sections: A java p...
Creating a database in sql
Based on the problem statement given below, derive the entities, associated attributes, and the
relationships between ent...
Analyze the design of a website, computer science homework help
I chose FC barcelona website...
Operational Excellence
What must companies focus on in order to survive in today’s business environment? Use at least two unique references. Le...
I need Help please
Take the data below and create a Model with functional dependencies.In a text/word file, write out the “Model” of your...
Prince Georges Community College Python Worksheet
3. Part 3: System and network configuration using Python [70 points]
In this part, you write the Python scripts to configu...
Web Design
The use of internet as a means of information exchange has greatly dominated the world today. One of these means has been ...
20210316110301hw8 Recursion Scope Exceptions 1
1. If you are going to solve a problem using recursion, which of the following is true? a. The recursive solution will be ...
Topic 1 Big Data
Explain how big data is helping businesses today. Do you think that this collection is a Exponentially, fast technological...
Related Tags
Book Guides
Of Mice and Men
by John Steinbeck
Alice in Wonderland
by Lewis Carroll
The President is Missing
by James Patterson, Bill Clinton
Cant Hurt Me - Master Your Mind and Defy the Odds
by David Goggins
Big Little Lies
by Liane Moriarty
The King Must Die
by Mary Renault
The Age Of Light
by Whitney Scharer
Milkweed
by Jerry Spinelli
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
3 pages
Eztech Movie Week 5 Discussions
In the previous weeks, we have effectively designed and implemented a database management system for our EZTechMovie proje ...
Eztech Movie Week 5 Discussions
In the previous weeks, we have effectively designed and implemented a database management system for our EZTechMovie project. This implementation has ...
create tables in database - java/ MySQL
Assignment InstructionsComplete the following steps for this assignment:Create a MySQL script that creates the tables in t ...
create tables in database - java/ MySQL
Assignment InstructionsComplete the following steps for this assignment:Create a MySQL script that creates the tables in the database with the appropriate primary and foreign keys.Your script must add data into the database tables. Every table must be loaded with at least two rows of data.Create screen captures showing the creation and contents of each table.Check and implement the database connectivity using JDBC.Check and implement exception handling for the database connectivity.Implement the Log-in action in your CapestraApp project, checking for the specified username and pass-word in the database and reporting a successful or unsuccessful log-in.Run your CapestraApp program and do screen captures of both successful and unsuccessful log-in attempts.Do not capture your entire desktop—just capture the individual screens.Paste all screen shots into a single MS Word document.Your name should appear at the top of the MS Word document.Name your document, following this pattern: LastName_Week5.docx.Create a .zip file containing your MySQL script file, your MS Word document, and a .zip of your CapestraApp project.Rename your .zip file, following this pattern: LastName_Week5.zip.SQL: CREATE ALL TABLES IN DATABASE; LOAD DATA INTO DATABASEOverviewTo integrate the functionality between the database and the application, you need to create the connection using JDBC. The JDBC API allows Java to connect to MySQL 5.7 using the MySQL Driver on any platform. The JDBC API allows Java to connect to the database, create and execute queries, and view and modify resulting records. Be sure to view the videos to guide you through the database creation and connection. You will need to create a MySQL script to create the ‘orderentrysystem’ database used by the CapestraApp application. The script must not only create all appropriate tables but also must load some sample data into each table. Note that just creating the database within MySQL Workbench does not satisfy the requirements of this assignment—you must create the database using a MySQL script file.This week’s assignment also includes a small programming assignment: You will create the semantics behind your revised Log-in scene. Currently your Log-in scene only provides the employee with a field for entering a username. Checking the SRS, you will see that the Log-in scene must provide for both a username and a pass-word. A successful log-in takes place only if both are provided to the system and they match what is in the orderentrysystem Employee table. You need to modify the Log-in scene to provide for a correctly functioning pass-word field, as well as using MySQL to determine whether the username-passwor-d combination matches an employee in the database. If a match is found, an appropriate message (including the employee's first name, last name, and employee ID) should be displayed to the user. If no match is found, an appropriate message should be displayed.In this assignment, you will create the database tables in MySQL 5.7 for the CapestraApp application. In addition, you will create and check the functionality to connect to the database from the application through a connector using JDBC. Use CapestraApp code provided to check that the database connection is correctly implemented. You need to ensure that exception handling is done correctly in case the database does not exist or if the connection fails.Check the SRS to see precisely what the Log-in action must do. Examine what is implemented in the CapestraApp template code to see what it does and how it does it. You’ll need to think about how to modify the existing code to meet the SRS requirements.
Cascading style sheet, programming homework help
Cascading Style Sheets are used to provide style, presentation, and layout for the HTML content of a Web page. You will de ...
Cascading style sheet, programming homework help
Cascading Style Sheets are used to provide style, presentation, and layout for the HTML content of a Web page. You will develop an external CSS to provide style, presentation, and layout to an HTML document.If you have not installed Microsoft Visual Studio Software in a prior course, follow these instructions for installation steps. Download the provided Unit2.zip document and save it to your computer. Click here to download the Unit2.zip document. Right-click the Unit2.zip folder and Extract All. Open Visual Studio and select File > Open Web Site from the menu.Navigate to the extracted Unit2 folder and select it to open the Website in Visual Studio. Select Website > Add New Item from the menu and select Style Sheet from Add New Item dialog box. Name the style sheet Unit2.css. Add style rules to Unit2.css to accomplish the following: Ensure that the semantic elements format in older browsers. Eliminate the default spacing around all elements. Use the Verdana font or any available sans-serif font for the text. Set the font size for the body to 80% of the browser’s default font size. Set the width of the window to display the document to 700. Center the text in the header. Provide spacing at the top of the level-one heading in the header to the equivalent of one capital M without affecting the spacing of the image. Set the font size for the level-one heading in the header to three times the browser’s default font size. Display the image in the header to the right of the text. Ensure the text of the section does not flow around the image in the header. Display the image in the first paragraph to the left of the text. Set the font size for the level-one heading in the section to two times the browser’s default font size. Center the text in the level-one heading in the section. Provide spacing at the bottom of the level-one heading in the section to the equivalent of one capital M. Set the font size for the level two headings in the section to one and one-half times the browser’s default font size. Center the text in the level two headings in the section. Center the text in the navigation. Provide spacing at the bottom of the navigation to the equivalent of two capital Ms. Bold the text of a hyperlink when the user hovers over the hyperlink or a hyperlink gets the focus. Set the text of a hyperlink to red when the user hovers over the hyperlink or a hyperlink gets the focus. Display the footer on the right side of the page. Set the font size of the text in the footer to 75% of the browser’s default font size. Validate the CSS style rules. Zip (compress) the Visual Studio project folder into a .zip file to submit.
CUMS Machine Learning Apply Dimension Reduction Techniques Case Study
Context/Background: The central idea is to use ML algorithms to recognize images, both static and dynamic, without specifi ...
CUMS Machine Learning Apply Dimension Reduction Techniques Case Study
Context/Background: The central idea is to use ML algorithms to recognize images, both static and dynamic, without specifically providing any guidance to the computer. This task is achieved by training algorithms to recognize various images while also mapping the feature space of those images to a categorical label or name. This task was first successfully achieved in the 1990s when computers were trained to recognize handwritten digits. The trained algorithm was used by postal services to sort mail and efficiently distribute it to the right destination. We will use the same dataset and problem for this case.The dataset is called MNIST (Modified National Institute of Standards and Technology). More information on MNIST can be found here: https://www.kaggle.com/c/digit-recognizer Use the only train.csvTo do: The main objective is to write a fully executed R-Markdown program performing dimension reduction techniques PCA, t-SNE, and UMAP on high dimensional image data using MNIST (digits) images that are 28 x 28 pixels resolution.Make sure to describe the final hyperparameter settings of all algorithms that were used for comparison purposes. Need rmd and pdf for this request.
Earn money selling
your Study Documents