shivakumar - Notepoints for Demonistration

docx

School

Illinois Institute Of Technology *

*We aren’t endorsed by this school

Course

509

Subject

Information Systems

Date

Oct 30, 2023

Type

docx

Pages

Uploaded by ChiefKnowledgeOyster25

1. The first function of my script is to show a user's details. This is done by querying the database for the user's username and then returning the user's details from the database. 2. The second function of my script is to show all users. This is done by querying the database for all users and then returning the user's details from the database. 3. The third function of my script is show only particular user by the username. This is done by querying the database for the user's username and then displaying the particular user's details in the database. 4. The fourth function of my script is creating a user. This is done by inserting a new row into the user data table in the database, creating a new entry for the user. The data that is inserted into the table is the user's username, hashed password, jobtitle, firstname, and lastname. The username is set to be unique so that there is no duplicate usernames in the database. The password is hashed using a one-way encryption algorithm to ensure that it is secure. 5. The fifth function of my script is to delete a user. This is done by querying the database for the user's username and then deleting the user's entry from the database. 6. The sixth function of my script is to update the user's password. This is done by first retrieving the user's encrypted password from the database. The encrypted password is then decrypted using the same algorithm that was used to encrypt it. The decrypted password is then compared to the user's new password, and if they are different, the new password is encrypted and stored in the database. The view is updated by querying the database for any changes in the user data table and returning the changed data to the view. The password is encrypted and decrypted using a one-way encryption algorithm. This ensures that the password is secure and cannot be easily guessed. For this we used the hashlib library The connection process involves establishing a connection between the script and the database. This is done by using a cursor to execute the SQL queries. Error handling is used to ensure that any errors that occur during the connection process are handled appropriately.

No custom functions or procedures were used, however a unique constraint is set on the user's username to ensure that it is unique. This is done by setting the username column to be a primary key. This ensures that there are no duplicate usernames in the database.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version