The relational database below contains two related tables Supplier and Product Product table Primary key Prod code, Foreign key Supp code Prod code Prod name Prod desript Prod stocktype Prod stocklevel Prod expireDate Supp code 10010 aaa qwert 615 123445677 2017 11 14 501x 10011 bbb asdfgg 615 234567899 2017 11 16 501x 10012 ccc zxxcvv 234 345678900 2017 11 13 502x 10013 eee ytuytu 234 454577777 2017 10 13 503x 10014 jjj werewr 231 436436885 2017 10 23 503x 10015 sdg rtyrtyry 275 676446322 2017 10 30 504x 10016 ewt erterter 789 232317879 2017 12 30 501x Supplier table Primary key Supp code, No Foreign key Supp cod e Supp lname Supp fname Supp Initial Supp areacode Supp phone 501x xxx qwert F 615 123445678 502x yyy asdfgg B 615 234567890 503x zzz zxxcvv X 234 345678901 From the above data, what type of relationships one to one, one to many, or many to many, do the above two tables have Explain your answer or draw the entity relationship diagram for these 2 tables (2 marks) The above database contains an error in the data Identify and describe this error (3 marks) Write a Query by example (QBE) to display the Prod code, Prod name, Prod descript for those products that are supplied by supplier with Supp code 502x Sort the display results by Prod name in ascending order Use the table below for your answers (5 marks) Field Table Total Sort Show Criteria Or

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

Question: The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name

The relational database below contains two related tables - “Supplier” and “Product”:

“Product” table: Primary key = Prod-code, Foreign key = Supp-code

Prod-code	Prod -name	Prod -desript	Prod -stocktype	Prod -stocklevel	Prod -expireDate	Supp-code
10010	aaa	qwert	615	123445677	2017-11-14	501x
10011	bbb	asdfgg	615	234567899	2017-11-16	501x
10012	ccc	zxxcvv	234	345678900	2017-11-13	502x
10013	eee	ytuytu	234	454577777	2017-10-13	503x
10014	jjj	werewr	231	436436885	2017-10-23	503x
10015	sdg	rtyrtyry	275	676446322	2017-10-30	504x
10016	ewt	erterter	789	232317879	2017-12-30	501x

“Supplier” table: Primary key = Supp -code, No Foreign key

Supp -code	Supp -lname	Supp -fname	Supp -Initial	Supp -areacode	Supp -phone
501x	xxx	qwert	F	615	123445678
502x	yyy	asdfgg	B	615	234567890
503x	zzz	zxxcvv	X	234	345678901

From the above data, what type of relationships: one-to-one, one-to-many, or many-to-many, do the above two tables have? Explain your answer or draw the entity relationship diagram for these 2 tables. (2 marks)
The above database contains an error in the data. Identify and describe this error. (3 marks)
Write a Query-by-example (QBE) to display the Prod-code, Prod-name, Prod-descript for those products that are supplied by supplier with Supp-code “502x”. Sort the display results by Prod-name in ascending order. Use the table below for your answers. (5 marks)

Field Table Total Sort Show Criteria Or

Step by Step Solution

★★★★★

3.43 Rating (166 Votes )

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 Human Resource Management Questions!

Table P-16 contains data for 23 cities on newsprint consumption (Y) and the number of families in the city (X) during a particular year. a. Plot newsprint consumption against number of families as a...

What is a database and how does a relational database organize data? 1. Define a database. 2. Define and explain the significance of entities, attributes, and key fields. 3. Define a relational...

Name some specific accounting files and a potential primary key for each one.

Multiple-Choice Questions 1. The data attributes that a particular user has permission to access are defined by the a. Operating system view. b. Systems design view. c. Database schema. d. User view....

Use information on the endpapers of this book to calculate the average density of the Earth. Where does the value fit among those listed in Tables 1.5 and 14.1? Look up the density of a typical...

Enhance the Sales Transactions database file to perform a database query that finds the transaction code and amount associated with any customer ID input. Apply your results to customer ID 10029....

Experimental data for density of mercury versus pressure at 20C are as follows: p, atm: 1 500 1000 1500 2000 , kg/m3: 13545 13573 13600 13625 13653 Fit this data to the empirical state relation for...

UB is examining its capital structure with the intent of arriving at an optimal debt ratio. It currently has no debt and has a beta of 1 . 5 . The riskless interest rate is 9 % . Your research...

2. Consider a 6-year 5.5% coupon bond that is rated BBB when issued... 2. Consider a 6-year 5.5% coupon bond that is rated BBB when issued at par (i.e.,$1,000) at the beginning of this year. Assume...

Pinder Inc. in the U.S. is examining its capital structure, with the intent of arriving at an optimal debt ratio. It currently has no debt and has a beta of 1.5. The riskless interest rate and the...

Amsyari Enterprise bought the secondhand motor vehicles for RM40,000. He incurred a major overhaul cost of RM10,000. The car was repainted for RM2,000. He also spent RM800 on road tax and insurance....

RC Ice Cream produces three products and allocates overhead cost using a plantwide rate of $2 per direct labor hour. Strawberry and Vanilla uses the facilities of Dept SV while Chocolate uses Dept C....

What are the equivalent units of production for materials? - What are the equivalent units of production for labor and overhead? - What is the total material unit cost? - What is the total conversion...

Case Study: Property Purchase Strategy Glenn Foreman, president of Oceanview Development Corporation, is considering submitting a bid to purchase property that will be sold by sealed bid at a county...

Activity 2 - De Leon, Prob 8, Chap 11 A company manufactures three products in a joint production process. The three products X, Y and Z. No by-product is produced in the process. Additional...

QUESTION 4 (25 MARKS) a. You have made your decision to choose UNISEL to further your study. Using your current experience of using UNISEL service, interpret how the tri- component attitude model...

NIL As each portion is an independent, the come Par Rental Value of 3.700 / 1 1/2 home (Unit under onceptes 13.00 / 100 Annual value Interest on loan to 1/2 500 Lore from pintu I. 1/2 he Unit- lot...

Independent random samples of sizes n1 = 30 and n2 = 50 are taken from two normal populations having the means 1 = 78 and 2 = 75 and the variances 21 = 150 and 22 = 200. Use the results of Exercise...

ODB's 2 0 2 3 sales were $ 1 0 million. If sales grow at 5 % per year, how large will they be 5 years later, in 2 0 2 8 ? Note: Apply the FV formula. The growth rate replaces the interest rate. $ 1 2...

List and explain some of the problems with the traditional waterfall SDLC.

Go to the Internet and find commercial websites that demonstrate each of the common errors listed in Table 10-11. Table 10-11. Error Recommendation Nonstandard Use Make sure that when using standard...

What is the difference between how a range control statement and a referential integrity control statement are handled by a file management system?

What amount today is equivalent to $10,000 four years ago, if money earned 5.5% compounded monthly over the last four years?

What total interest will be earned by $5000 invested at 5.4% compounded monthly for 3 years?

How much more will an investment of $10,000 earning 8% compounded annually be worth after 25 years than after 20 years? Calculate the difference in dollars and as a percentage of the smaller maturity...