(Solved): Write an application for a construction company to handle a customer's order to build a new ho ...

Write an application for a construction company to handle a customer's order to build a new home. Use separate ButtonGroups to allow the customer to select one of four models, the number of bedrooms, and a garage type. Assume that the models are the Aspen, R110 000; the Brittany, R120 000; the Colonial, R120 000; or the Dartmoor, R130 000. Assume that any model can have two, three, or four bedrooms and that each bedroom adds R10 500 to the base price. Assume that the garage type can accommodate zero, one, two, or three cars, and that each car adds R7775 to the price. [15] QUESTION 2 20 MARKS Create a JApplet that contains two JTextFields, a JButton, and three JLabels. When the user types an employee's first and last names (separated by a space) in a JTextField, the employee's job title is displayed in a second JTextField. Include two JLabels to describe the JTextFields used for data entry. Also include a third JLabel that displays the employee's title or an error message if no match is found for the employee. Use parallel arrays to store the employees' names and job titles. [20] Develop a JFrame program that will be connected with MySQL database named richfield and allows a user to register his/her personal details that will be stored in a table named registration. Table fields (Name, Surname, DOB, Address, Gender, Username, Password, Security_Question, Security_Answer) Use appropriate data type for given fields names. Login form The user will be able to register first, before he/she can be able to login. See screenshot below. Use two labels for "Forgotten password" and "New user Signup". When the user clicks any of the two labels, a form must pop-up to allow the user to either reset the password or enter signup details depending on the label clicked. Your login form must be connected to a database that has the users table. When the user clicks the Login button, the program must verify user username \& password to check if they match with those in the users table. If so, a message must pop-up displaying "Welcome with [your name]". For example, "Welcome Samuel Rametse." Please note that you have to validate all form fields when the user click submit button to ensure that there are no missing values in all the fields. The message notifying the users about these missing values must be displayed in a dialog box. Use the following security questions: 1. What's your mother's middle name? 2. Which primary school did you attend? 3. Which year did you finish high school? 4. What is your favourite colour? Once the user is done completing the form correctly, data must be stored inside database table "registration" Clear button will reset all the fields in the form to blank. Exit button will terminate the form Forgotten password form The user is required to provide registered username, security question and security answer which were used the time he/she signed up. The program will compare the supplied information with the one in the database. If the information is correct the pop-up message will appear in the form of a dialog box with user password; otherwise it will show dialog message with "user information not found". Using java servlet and JSP, develop a web application that will assist the Richfield administrator to add new users to a portal. You're required to create MySQL database to store users' information. A database named portal should have one table called users. View All Records Once admin done registering the users, he/she must be able to view all records by clicking on the "View All Records" link, and a list of users will be displayed as shown in the screenshots below. The Admin should be able to "Edit" and "Delete" user records. Users List Add New User Note that you are advised to use Apache tomcat or Glassfish as your local web server to be able to run this web application. [20]