Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

More Books

Students also viewed these Databases questions

Question

How do Dimensional Database Models differ from Relational Models?

Answered: 1 week ago

Question

What type of processing do Relational Databases support?

Answered: 1 week ago

Question

Describe several aggregation operators.

Answered: 1 week ago