Need this in MySQL Now were going to work out the backend of

Need this in MySQL

Now we\'re going to work out the back-end of the address book app. And most of this is up to you! We have two categories of data: Users Contacts (per user) Users have a user name, an email address and a password - don\'t worry about password security right now. We\'ll get to that later! A user has a name, an email address, a password and a phone number. A contact must have a surrogate key - the reason is that people might know the same person, but they need to be kept separate in case of deletion or modification! A user can have several contacts. No contact belongs to more or less than one user. Think about how to do that properly. Define a DB schema for the back-end. Find the best data types and build the DDL for Users and Contacts in one DB! Define two users (all data up to you) and add them to the DB For each, define two contacts (all data up to you) and add them to the DB. Run the script against your MySQL system and include a screen shot of the response. In your words describe the activities on this database (with two users and two contacts each) A user logs in successfully A user logs in unsuccessfully Produce a list of all contacts for a user that\'s logged in. A user adds a contact to his list For this use terms a \"read x from a form\", \"read x from the table y\", \"compare x to y\", \"store x in table y\". Be as specific as possible! Type it into a .doc and submit it with the other data in a zip archive.

Solution

1.

2.

Contacts:-