Databases | SQL | Oracle | MS Access Answers

_ is used to specify gap between cells

Get top 5 genres in the platform with most positive users activity i.e the genres with videos having more number of likes

1.Write a procedure that displays the number of countries in a given region (prompt for value) whose highest elevations exceed a given value (prompt for value). The procedure should accept two formal parameters, one for a region_id and the other for an elevation value for comparison. Use DBMS_OUTPUT.PUT_LINE to display the results in a message. Test your procedure using the value 5 for the region_id and 2000 for the highest evaluation

Provide a detailed hardware specification for the computer system to be sourced

for John. The hardware specification should centre around the main components

common to all computer systems and should specify details such as make, model,

cost, power or capacity and supplier.

Provide a detailed hardware specification for the computer system to be sourced

for John. The hardware specification should centre around the main components

common to all computer systems and should specify details such as make, model,

cost, power or capacity and supplier.

Create a table with 3 rows and 3 columns .

Categorise the performance of all the videos released by the “Motivation grid” Channel (id = 350).

Performance of a video is measured based on the number of views of the video.

Categorization

no_of_viewscategory<= 10000poor10000 < views <= 100000 andaverage> 100000good

Note

Sort the output in the ascending order of

published_datetimeExpected Output Format

nameno_of_viewscategory.........

ORACLE transaction is a logical unit of work which contains one or more than one SQL commands. It is an atomic unit which means that all SQL commands in the transaction can be either committed (Done) or rolled back (Undone).

Accounts:

Ac_Ttile  Ac_Number Ac_Type Balance 

You are required to write PL/SQL code for an ORACLE transaction on Accounts table (given above) containing the following SQL commands. 

• INSERT (ADD) a new account having title as “Waqar Hassan” , account number 2025660 ,account type   as “Current” and balance 1000. 
• DELETE an already existing account having account number 2025665 .

Question 1 

Consider a company named “ABC” that provide the exercise machines to various customers. This company purchase these machines from different suppliers and then further sale to gyms and individual (home) customers. The company has regular as well as casual customers while the regular customers also have some special discount. The customers simply place orders and on availability of demanded equipments (machines), the company dispatches the machines along with vouchers (bills) and the customers pay the price according to the provided vouchers.

In order to develop the ER Model for this scenario, the first task is to extract the Entity types. So, you are required to only identify/extract the Entity types from the above scenario.

. Explain using an example how you would covert subtype/supertype relationships to relations in database design.