Question: Task 1 1) Write a Java program that displays in the terminal the title, label and price of the albums in the 'Album' table. A

Task 1 1) Write a Java program that displays in the terminal the title, label and price of the albums in the 'Album' table. A sample program output is [10 marks) Title: Diamond Dogs Label: RCA Price: 7.99 Title: Station to Station Label: RCA Price: 6.99 Title: The Beatles Label: Apple Price: 10.99 Title: The Idiot Label: RCA Price: 5.99 Title: For Your Pleasure Label: Island Price: 4.99 Title: Revolver Label: Parlophone Price: 9.99 Title: Sabbath Bloody Sabbath Label: Vertigo Price: 5.99 Title: Welcome to Jamrock Label: Universal Price: 7.99 Title: The Top Label: Fiction Price: 4.99 Title: Strange Days Label: Elektra Price: 4.99 Title: Appetite for Destruction Label: Geffen Price: 5.99 Title: Trans-Europe Express Label: Kling Klang Price: 9.99 Title: Bleach Label: Sub Pop Price: 8.99 Title: The Man Who Sold The World Label: RCA Price: 5.99 Title: Abbey Road Label: Apple Price: 9.99 Title: Hounds of Love Label: EMI Price: 5.99 Title: The Velvet Underground and Nico Label: Verve Price: 4.99 Title: The Stone Roses Label: Silvertone Price: 4.99 Title: Kid A Label: Parlophone Price: 7.99 Title: Exile on Main St Label: Rolling Stones Records Price: 9.99 Title: It Takes A Nation Of Millions To Hold Us Back Label: Def Jam Price: 7.99 Title: Led Zeppelin Label: Atlantic Price: 4.99 Title: The Southern Harmony and Musical Companion Label: Def American Price: 5.99 Title: Imagine Label: Apple Price: 4.99 2) Modify the above program such that it displays only five rows (title, label and price) in the 'Album' table (sorted by price). A sample program output is 15 marks] Title: Strange Days Label: Elektra Price: 4.99 Title: The Velvet Underground and Nico Label: Verve Price: 4.99 Title: The Top Label: Fiction Price: 4.99 Title: For Your Pleasure Label: Island Price: 4.99 Title: The Stone Roses Label: Silvertone Price: 4.99 [In the answers' document you must include a screenshot from your IDE showing the output)

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!

PHASE 1 You will implement a virtual bookstore in this time and next time homework assignments. Your task is to write a Java program to keep track of books in a bookstore. The program should have a...

First to Four-of-a-Kind Card Game vs Computer Player (Java Programming) Directions: Your task is to write a java program that plays a simple card game with one human player and one computer player....

Babette's Bistro is a restaurant which sells delicious French bistro fare, although with a very limited selection. The menu consists of the following items with associated prices: Braised Rabbit...

In java, please DNA Background DNA, the carrier of genetic information in living things, has been used in criminal justice for decades. But how, exactly, does DNA profiling work? Given a sequence of...

I need help with this project in java DNA Background DNA, the carrier of genetic information in living things, has been used in criminal justice for decades. But how, exactly, does DNA profiling...

Assignment 1 Before attempting this project, be sure you have completed all of the reading assignments,nongraded exercises, discussions, and assignments to date. Write a Java program that: 1. Prompts...

***in java*** disregard the assignment policy, it has nothing to do with the code, but rather how it should be turned in when due Assignment Description The table below shows types of insects with...

in java what do i need to add? Assignment Description The table below shows types of insects with different abilities - pollinators, builders, predators, and decomposers. Each insect has a fixed set...

write a java program, please write the program using comands in order to understan clearly A few students got together to form an investment group. They wanted to pool their savings and decide which...

After studying this module and as part of emotional and social development, you learned the difference between gender, sexual orientation, and gender expression. You also learned previously in the...

Write a research paper on Measures of Centre and Variability focus on descriptive statistics including Hypothesis and measure of dispersion

Demand - oriented pricing opproaches weigh which factors most heavily? expected customer tastes and preferences number of competatien products on the market expected supply of the product at its time...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

6. Is all Internet training the same? Explain.

5. Discuss how new technologies make it easier to learn. How do they facilitate transfer of training?

4. Are training support technologies always needed? Justify your answer.