Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 archive

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

Practical Oracle8I Building Efficient Databases

Authors: Jonathan Lewis

1st Edition

0201715848, 978-0201715842

More Books

Students also viewed these Databases questions