Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1: The XYZ company need a website for their organization. Its database and business tier are as follows. Database Tier: Use SQL database to

Question 1: The XYZ company need a website for their organization. Its database and business tier are as follows. Database Tier:

Use SQL database to store data on each worker as it is entered. Meeting our base requirements, you will need at least the following fields: the workers Id, the workers first name, the workers last name, the workers pay, and workers bonus percentage. Decisions you make regarding the types used, the properties of these fields, primary keys, and any additional fields needed should be made carefully and with justifications in mind. Your database must be persistent, meaning that it is maintained the next time the program runs. Business Tier: The system should have a user-friendly form to enter and store workers data. There is one new validation requirement for our workers: they must enter a first name and workers pay. The system should be able to calculate the workers gross pay (whereas gross pay= workers pay + workers bonus) The system should display workers processed information in tabular form. Class methods may generally require some adjustments to interact properly with the database, and new ones may be introduced. -Add a class method that writes a workers information to the database that could be called from your form(s). - You will also need a class method to somehow read all workers from the database to display them on the HTML Table, The HTML table should have the following table heads the workers Id, the workers first name, the workers last name, the workers pay, workers bonus percentage, and workers gross pay. - You may wish to abandon the summary variables and instead read the relevant values (overall total pay) from the database.

According to the given requirements solve the following questions: 1. Steps to configure WebHost builder and the required services to be added in startup class are properly listed. 2. Domain Model Class(s) and their respective properties are declared with proper validations, getters, setters, and access specifiers. 3. Database context is registered, and Domain Model classes are included. 4. Client and server-side code are listed to fulfill the above-mentioned business requirement.

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_2

Step: 3

blur-text-image_3

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

Oracle Database 11g SQL

Authors: Jason Price

1st Edition

0071498508, 978-0071498500

More Books

Students also viewed these Databases questions

Question

Th e complaint department was closed over the lunch hour.

Answered: 1 week ago

Question

Prepare a short profile of Henry words worth Longfellow?

Answered: 1 week ago

Question

What is RAM as far as telecommunication is concerned?

Answered: 1 week ago

Question

Question 1: What is reproductive system? Question 2: What is Semen?

Answered: 1 week ago

Question

Describe the sources of long term financing.

Answered: 1 week ago

Question

2. What should an employer do when facing an OSHA inspection?

Answered: 1 week ago