Language SQL Database Management Question Choose a primary key for the users table, fully explaining and justifying your answer, including why any other potential candidate keys are not suitable The following four data tables describe the available items, orders, users, and deliveries for a certain restaurants online delivery service items code description price HAMBGR Hamburger 4 29 CHZBGR Cheeseburger 4 99 FRYSML Small fries 1 99 FRYLRG Large fries 2 99 FNCOLA Coke 1 49 orders order id item quantity 0001 CHZBGR 2 0001 FRYLRG 1 0002 HAMBGR 1 0002 FNCOLA 1 0003 CHZBGR 3 users login name address john123 geemail com John 123 Number St alice89 h0tmail edu Alice 88 Infinity Rd jdepp pirates com Johnny 21 Jump St kat22 yah000 net Kathryn 65 Leonin Ln deliveries order id user delivered 0001 alice89 h0tmail edu Yes 0002 john123 geemail com Yes 0003 alice89 h0tmail edu No

The Answer is in the image, click to view ...

Question: Language: SQL / Database Management Question: Choose a primary key for the users table, fully explaining and justifying your answer, including why any other potential

Language: SQL / Database Management

Question: Choose a primary key for the users table, fully explaining and justifying your answer, including why any other potential candidate keys are not suitable.

The following four data tables describe the available items, orders, users, and deliveries for a certain restaurants online delivery service:

items

code	description	price
HAMBGR	Hamburger	4.29
CHZBGR	Cheeseburger	4.99
FRYSML	Small fries	1.99
FRYLRG	Large fries	2.99
FNCOLA	Coke	1.49

orders

order_id	item	quantity
0001	CHZBGR	2
0001	FRYLRG	1
0002	HAMBGR	1
0002	FNCOLA	1
0003	CHZBGR	3

users

login	name	address
john123@geemail.com	John	123 Number St
alice89@h0tmail.edu	Alice	88 Infinity Rd
jdepp@pirates.com	Johnny	21 Jump St
kat22@yah000.net	Kathryn	65 Leonin Ln

deliveries

order_id	user	delivered
0001	alice89@h0tmail.edu	Yes
0002	john123@geemail.com	Yes
0003	alice89@h0tmail.edu	No

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Language: SQL / Database Management Question: Choose a primary key for the items table, fully explaining and justifying your answer, including why any other potential candidate keys are not suitable....

Needs correct answer for the 18 multiple choice questions on Accounting Information & Control Systems (AIS) home / homework help / questions and answers / business / accounting / 1. of the following,...

Indicate the answer choice that best completes the statement or answers the question. 1. A form of wireless transmission called _____ is very popular for short-distance wireless communication that...

Please find attached assignment and see if you can help me in that and provide me the main points (in the article of spencer and web (2015) as attached) that need to be criticized, also I need an...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Who is chief knowledge officer? What the primary role? A senior executive in an organization responsible for ensuring that firm fully utilizes the value it gets through knowledge- which is the most...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

You are called by Tim Duncan of Spurs Co. on July 16 and asked to prepare a claim for insurance as a result of a theft that took place the night before. You suggest that an inventory be taken...

How long will it take $2,000 to reach $5,000 when it grows at 10 percent per year?

What penalty may the FTB assess against taxpayers who fail or refuse to make and file a return upon notice and demand by the FTB ? Group of answer choices 8 percent penalty of the total tax assessed...

Accounting I The following information was obtained from the accounting records: 1. An inventory of supplies indicates supplies with a cost of $1,800 remain 2....

1. One of Bill Conatys tips for developing leadership is Be Inclusive. Based on what was discussed in Chapters 7, 8, 9, and 10, what does Be Inclusive mean to you?

3. How can employees and their managers determine whether they are interested and qualified for leadership positions? Source: D. Brady, Secrets of an HR Superstar, Business Week (April 9, 2007)....

6. Go to www.uawford.com, the Web site for the UAW-Ford National Programs Center. Choose one of the joint programs to investigate. Search the Web site to find information about the program. What is...