Assistance needed with SQL commands

/in /by

In the ever-evolving landscape of education, students face increasing challenges to meet the demands of their academic pursuits. Striking a balance between extracurricular activities, personal commitments, and a rigorous academic curriculum can be overwhelming. Amidst this struggle, online homework help services have emerged as invaluable resources for students seeking academic excellence. Among these, HomeworkProWriters.com shines as a beacon of light, standing tall as the best website for homework help.

I need assistance with the query commands assigned to an assignment. I have the databases properly created and do not need assistance with the commands associated with creating the databases. Here is the complete assignment. I have attached the database information.

 

 

The structure of the movies database is as follows:
Director (
DIRNUB
, DIRNAME, DIRBORN, YR-DIRDIED)
STAR (
STARNUB
, STARNAME, BIRTHPLACE, STARBORN, YR-STARDIED)
MOVIE (
MVNUB
, MVTITLE, YRMDE, MVTYPE, CRIT, MPAA, NOMINATIONS, AWRD,
DIRNUB
)
MOVSTAR (
MVNUB
,
STARNUB
, AMTPAID)
MEMBER (
MMBNUB
, MMBNAME, MMBADD, MMBCITY, MMBST, NUMRENT, BONUS, JOINDATE)
TAPE (
TAPENUM,
MVNUB, PURDATE, TMSRNT,
MMBNUB
)
 
Create Video Store database as discussed in the class. Make sure to correct column widths/types before creating tables. Use SQL to form queries to produce the following reports
:
 
  1. ** List the names and numbers of directors whose names begin with the alphabet ‘K’.
  2. List the tape no, movie title, and the membership number and name of members, who are currently borrowing tapes numbered below 20. Arrange the report in descending order by tape number.
  3. List the names and respective numbers of stars and directors who have worked together.
  4. ** List the tape numbers for movies of movie type: ‘HORROR’.
  5. List the name of the director who has received the maximum number of total awards considering all his/her movies: AWRD.
  6. ** List the names of all members who have not borrowed any movie currently.
  7. List the movie type and number of tapes for each type in the database.
  8. ** For each movie list total how many times it has been rented: TMSRNT.
  9. Report the total times rented (TMSRNT) for each movie type.
  10. The database administrator discovers that the name of director whose number is 7 in the database should be spelt as ‘JOHNNY FORD’. Make corrections to the data.
  11. Delete the movie number 14 and all its tapes. Print both tables to verify.
  12. List all tape numbers and their movie titles, and indicate the member number and member name if the tape is currently rented out.

13. List all tape numbers, and also indicate the member’s city if a tape is currently rented out by a member.

14. Who is the youngest director?
 
How many movies did he/she direct?
15. Grant access to me (joshi) to your movstar table for select and update.
16. Create a unique index on movstar table.
17. For each movie type list the average age of movies given the current year is 2011.
18. ** Create a view MEMB_TAPES that includes the currently rented movies and the members who are renting them, include movie type.
19. ** Use the view MEMB_TAPES to find all currently rented “COMEDY” type movies and members who are renting them.
20. ** List all tape numbers, along with movie name and member name if rented out (leave member name blank if not rented out).
 
 

At the core of HomeworkProWriters.com lies a team of exceptional and proficient writers. Each member of this distinguished cadre possesses advanced degrees in their respective fields, empowering them with the knowledge and expertise to tackle assignments from various academic disciplines. From complex mathematical problems to intricate literary analyses, their writers exhibit a remarkable ability to deliver impeccable content that adheres to the highest academic standards. One hallmark of the best homework help website is its comprehensive subject coverage. HomeworkProWriters.com leaves no academic stone unturned, catering to students across diverse subjects and levels of study. Whether it be fundamental sciences, nursing, humanities, social sciences, or technical disciplines, this platform ensures that no student is left without the support they need to excel.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.