Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need it in MySQL: Thanks Now we're going to work out the back-end of the address book app. And most of this is up to
Need it in MySQL: Thanks
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 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. Part 1: 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. Part 2: 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 archiveStep 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