Question
For all parts of this project, your system must be application or web-based. Some simple GUI interfaces are required for each functionality. All functionality must
For all parts of this project, your system must be application or web-based. Some simple GUI interfaces are required for each functionality. All functionality must be performed via the interface of your system; direct SQL statement execution via any tools (like MySQL Workbench) is not allowed. Part 1 Use Java/Python and SQL, implement the following functionality: 1. (5 pts) Create a database schema and implement a user registration and login interface so that only a registered user can login into the system. The schema of the user table should be: user(username, password, firstName, lastName, email) username is the primary key, and email should be unique. You have to prevent the SQL injection attack. There is an attached pdf file about SQL injection attacks. 2. (5 pts) Sign up for a new user with information such as: username, password, password confirmed, first name, last name, email. Duplicate username, and email should be detected and fail the signup. Unmatching passwords should be detected, as well. 3. (10 pts) Implement a button called Initialize Database. When a user clicks it, all necessary tables will be created (or recreated) automatically. Hint: 1) For step 3, you can use the DDL.sql from reference book for now. Later you will replace this .sql script file with the SQL file of your project database. Open the DDL.sql file in any text editor and add the following SQL commend in line 1 to make sure your project database is set as the default: use yourdatabaseName;. Make sure the database name is the same as the database of steps 1 and 2 (user login and registration).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started