Databases | SQL | Oracle | MS Access Answers

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 .

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. 

In the below-mentioned example, there is an EMP Table having records of EMP_NAME, EMP_NO, SALARY, MANAGER_ Dep.

Now, you have to perform the following operations by using the commands INSERT INTO, DELETE, UPDATE and SELECT in detailed SQL code by following the main steps:

⦁ Firstly, you insert the data by using the command INSERT INTO.

⦁ Then, you have to update the SALARY record of Saqib by 80,000 to 85,000 by using the command UPDATE.

⦁ Finally, and delete the record of Shahid from the table by using the command DELETE.

EMP_NAME EMP_NO SALARY MANAGER_ Dep

Haseeb 1 70,000 Marketing

Saqib 11 80,000 Accounts

Shiraz 12 65,000 HR

Shahid 13 80,000 Supply chain

atm management system code in sql server