Assignment Name: Real Estate App Assignment Specifications: Write a basic Real Estate Management Application using JavaF that allows your user to perform the following database operations: 1. Display all of the real estate data in the database in a JavaFX table view. 2. Add a new real estate data item. Update an existing real estate data item. 4. Delete real estate data item selected from the table view (prompt the user itf they are sure they want to delete the selected record). An Export button that exports the selected row in the table view to a text file (extra credit if your program exports to HTML, and/or XML format - 1 point extra credit for each format) Other functionalities your instructor will be looking for: 1. Usage of regular expressions for data input validation in all input text fields (your instructor will try to crash your progra 2. Ensure user input values are within the constraints of the database table field constraints (ie. If you have a field that is a yarchar(30), do not let your program attempt to insert/update a string to the field in excess of 30 characters). 3. Come up with an approach for securing log in credentials into the database. Some ideas (you can implement all of these ideas or any combination of them): a. Create a database specific user account that is only allowed to select records, insert records, update records, and delete records (no other database privileges). b. Use a secure cryptographic hash digest method (SHA256, RIPEMD160, etc) c. Singleton Pattern (https://www.journaldev.com/1377/java-singleton- design-pattern-best-practices-examples) that holds the user credentials in a secure manner. Assignment Name: Real Estate App Assignment Specifications: Write a basic Real Estate Management Application using JavaF that allows your user to perform the following database operations: 1. Display all of the real estate data in the database in a JavaFX table view. 2. Add a new real estate data item. Update an existing real estate data item. 4. Delete real estate data item selected from the table view (prompt the user itf they are sure they want to delete the selected record). An Export button that exports the selected row in the table view to a text file (extra credit if your program exports to HTML, and/or XML format - 1 point extra credit for each format) Other functionalities your instructor will be looking for: 1. Usage of regular expressions for data input validation in all input text fields (your instructor will try to crash your progra 2. Ensure user input values are within the constraints of the database table field constraints (ie. If you have a field that is a yarchar(30), do not let your program attempt to insert/update a string to the field in excess of 30 characters). 3. Come up with an approach for securing log in credentials into the database. Some ideas (you can implement all of these ideas or any combination of them): a. Create a database specific user account that is only allowed to select records, insert records, update records, and delete records (no other database privileges). b. Use a secure cryptographic hash digest method (SHA256, RIPEMD160, etc) c. Singleton Pattern (https://www.journaldev.com/1377/java-singleton- design-pattern-best-practices-examples) that holds the user credentials in a secure manner
