Databases | SQL | Oracle | MS Access Answers

Can you do assignment for free

What is the process of creating, arranging and maintaining a system of information retrieval called?

Define Concurrency in Database management System? 

What is Backup and Recovery in DBMS? 

What is SQL Aggregate Functions Define with Examples

1.

Get the top 10 channels for which more number of users are subscribed in the year 2018.

Note:

In case, if the no_of_subscribers are same, then sort the output in the ascending order of channel_name.

Expected Output Format:

channel_id channel_name no_of_subscribers

The following table shows the essential data required for this application. Hillar Furniture Company Purchasing Data is shown below: Attribute Name Material_ID Material_ Name Unit_of_Measure Standard_Cost Vendor_ID Vendor_name Unit_price Terms_Code Terms Sample Value 3792 Hinges 3” locking Each GHC 5.00 V300 Apex Hardware GHC 4.75 1 COD a) Using the dependency diagram, identify the functional dependencies for this data. You may assume the following: i. Each material has one or more suppliers. Each supplier may have supply one or more items or may not supply many items. ii. The unit price for a material may vary from one vendor to another iii. The terms of a code for a supplier uniquely identifies the terms of a sale (e.g. code 2 means 10% net 30 days, etc.). The terms for a supplier are the same for all material items ordered from that supplier. [E][9] b) Convert your data into a set of 3NF relations, identifying all the primary and foreign keys

Write a PL/SQL program to find greatest of three numbers and print Fibonacci series up the largest number found.

Write a PL/SQL code to print all tables up to a number fetched from a table using implicit cursors.