[go: up one dir, main page]
Scribd
Upload
59 views1 page

Database Management SQL Activity

This document provides instructions for performing 5 SQL queries on a Videos database. The queries include: 1) Listing all films in the database, 2) Listing customer information for action videos ordered by last name, 3) Listing customer names and addresses for female customers who rented tapes beginning with D, 4) Listing customer information for last names beginning with B, and 5) Listing video titles, types, costs and quantities for drama videos.

Uploaded by

Jerry Chable
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views1 page

Database Management SQL Activity

This document provides instructions for performing 5 SQL queries on a Videos database. The queries include: 1) Listing all films in the database, 2) Listing customer information for action videos ordered by last name, 3) Listing customer names and addresses for female customers who rented tapes beginning with D, 4) Listing customer information for last names beginning with B, and 5) Listing video titles, types, costs and quantities for drama videos.

Uploaded by

Jerry Chable
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Information Technology Database Management SQL Activity

Points: (17pts)

Perform the following queries for the Videos database that is provided. Please note that two files are
provided, one id for Libreoffice base and the other is for Microsoft Access. Please choose the appropriate
file.

Note: For queries that require more than one table please remember to include your relationship.

Instructions:

1. Create a query to show all films in the database. Name the query as “Query01”. (2 pts).
2. List all customers in ascending order by last name, show first name, last name, video id, title, type
code, date rented, and rental fee for all action videos. Name the query as “Query02”. (3 pts.)
3. Display the names (First and Last) and address of all female customers who rented tapes beginning
with a “D”. Name the query as “Query03”. (4 pts.)
4. Display all customers whose last name begins with a “B”. Display the First and Last Name, Address
and Gender. Name the query as “Query04”. (4 pts).
5. List all the videos that are of type Drama. Display the Title, Type Description (not the code), the
Cost and the Quantity. Name the query as “Query05”. (4 pts).

You might also like