Databases | SQL | Oracle | MS Access Answers

b) DRAM is used in the main memory. To compensate for the slow speed of the DRAM, there are advanced DRAM organizations introduced. Discuss the advanced DRAM organization.

a, Investigate and discuss the external memory storage trends.

Get videos from TEDx channel (id=353) with more than 50 thousand views.

Note:

Sort the output in the descending order of

no_of_viewsand in the ascending order of videonameExpected Output Format

video_id, name ,duration_in_secs ,no_of_views

please help

Get all the videos with more than 1 lakh views.

Note:

Output must be in the alphabetical order of video

name

video_id, name, duration_in_secs published_datetime no_of_vie

Get the total number of users in the platform asusers_count

Get the top 10 most viewed videos till date.

Note:

Sort the output in the descending order of

no_of_viewsandpublished_datetime

Get all the videos with more than 1 lakh views.

Note:

Output must be in the alphabetical order of videoname

can you please explain query how to convert 17200 into 17.2 in sql

examples:

18990 into 18.9

12300 into 12.3

8. A specific manufacturer makes each launch vehicle type, and a manufacturer can make

many different launch vehicle types.

9. Each launch carries one payload, and a payload is only carried by one launch.

10. A manufacturer also makes each payload, and a manufacturer can make many different

payloads over time.

11. Multiple crew members can be carried on a crewed launch, and each crew member can be

carried on multiple launches over time.

12. Each crew member has a nationality (the country they come from), and their name and

surname also need to be recorded.

13. Crew members can appear in the database before they launch for the first time.

  Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation, representing these business rules. Your design should be at the logical level – include surrogate primary key and foreign key fields and remember to remove any many-to-many relationships.

4. A launch requires a launchpad that hosts it, a launch vehicle (the rocket), and the payload.

5. For a launch, the date, time and name should be recorded as well as whether it is a crewed

launch or not.

6. Each launch is performed by a launch vehicle. The serial number for the launch vehicle

should be recorded. A launch vehicle can perform multiple launches over time.

7. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and

whether it is reusable need to be recorded for the launch vehicle type.

8. A specific manufacturer makes each launch vehicle type, and a manufacturer can make

many different launch vehicle types.

9. Each launch carries one payload, and a payload is only carried by one launch.

  Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation, representing these business rules. Your design should be at the logical level – include surrogate primary key and foreign key fields and remember to remove any many-to-many relationships.