answer 5 using 4 c, please Question 5 (4 points): What kind of statistics that a

Question

answer 5 using 4 c, please

Question 5 (4 points): What kind of statistics that allows us to get a better estimate for point previous question. Show a small example including multiple brands and products. coudy Question 6: Library Books (Book-ISBN, Library ID, titte, lib_address, book_title, no_of_copies) Consider the relation above about library books with the following FDs: Book ISBN, Library_ID > no_of_copies Book ISBN book title Library ID lib_address lib address County County book_title lib address Book Library_ID C++ Prog. ISBN Multnomah 11 Burnside L1 Washington Data Structures 123 23 185th Ave. Intro. Databases L2 Multnomah 456 23 Powell Blvd. 789 no_of_copies 3 LI a) Which FD is not enforced in the database instance above? (1 point) b) Fix the data so the FD in point a is enforced. You only need to rewrite one rowo ok title) is satisfied. The query should c) Write one SQL query to test if the FD (Book ISBN book_title) is satisfied return an empty result if the FD is satisfied (enforced). (3 points)

Explanation / Answer

Solution:

5)

So in 4c we are extracting every column detail of the brand Starbuck and product coffee, this means we can analyze how the sales for the Starbucks for the coffee.

Example:

Using this statistical method we can extract the sales and popularity of the particular product for a particular brand which may help in those brands focusing on that product to expand the business because it is liked by most of the people so it will suit in other places too.

Or we can also extract which one is selling worse so that the product can be improved by the brand.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.