Databases | SQL | Oracle | MS Access Answers

6. Find the sum of durations of the videos published by each channel in hours.

Note:

• The output must contain the duration as number of hours.

.

Sort the output in the descending order of the no_of_hours

5. For all the videos, represent the number of views in multiples of thousands.

For example, if the number of views of a video is 17,200, it is represented as 17.2 in the output.

Note:

• Sort the output in the descending order of no_of_views_in_thousands, and then in the alphabetical order of name

Expected Output Format

video_id

name

no_of_views_in_thousands

get the total number of distinct countries where the users are located.country of the user is present in the user table

Jst a query how to write please help me

Polly Pipe is a water sports provider and installer based in Braintree, England. They need to design and implement a database. Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. Because these facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Draw the Use Case Diagram and Class Diagram for this scenario.

Polly Pipe is a water sports provider and installer based in Braintree, England. They need to design and implement a database. Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. Because these facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Produce a technical documentation and a user guide for the developed database system. Suitable diagrams (Use case diagram, class diagram, flow charts, DFD level 0 and 1) should be included in the technical documentation to show data movement in the system. Assess the developed database by suggesting future enhancements to ensure the effectiveness of the system. 

Get the number of male and female premium users in the platform.

As mentioned above, We need to count the users who has the premium membership, but you are trying to sum instead of count(). And also in the WHERE clause, we need to check premium users have premium_membership value as 1 , and the value 0 is considered as non-premium user.

Table: USER

user_id name gender age country premium_membership

2000 John White M 63 AUSTRALIA 1

2001 John Andrews M 67 AUSTRALIA 1

2002 April Robinson F 60 SRILANKA 1

2003 Kathy Ryan F 81 SRILANKA 0

2004 Megan Bradshaw F 53 AUSTRALIA 1

2005 Melissa Sullivan F 45 BANGLADESH 1

there is still having lot of data in the table, but I just gave the limited data for example to get the solution related to question and the expected output format should be as follows:

Table: gender total_users

F ...

M ...

/*7. Show any employee who is not a manager, but earns more than any manager in

the employees table. Show first name, last name, job id, and salary. Sort the result 

by salary.*/

What are some ways of writing is query?

Identify the user and system requirements to design a database for the above scenario and design a relational database system using conceptual design (ER Model) by including identifiers (primary Key) of entities and cardinalities, participations of relationships. Convert the ER Model into logical database design using relational database model including primary keys foreign keys and referential Integrities. It should contain at least five interrelated tables.

https://docs.google.com/document/d/16o4eJA_nK8IyUxHcPhavXGYliqWpnHujbm1JDnZ3Z5M/edit?usp=sharing

Open the above link and Identify at least THREE Non Functional Requirements according to it.

https://docs.google.com/document/d/16o4eJA_nK8IyUxHcPhavXGYliqWpnHujbm1JDnZ3Z5M/edit?usp=sharing

Open the above link and Identify at least FIVE Functional Requirements according to it.