HW3 - CSCI 485: File & Database Management Homework 3: SQL...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSCI 485: File & Database Management Homework 3: SQL Queries and Microsoft SQL Server 2005 Professor Shahram Ghandeharizadeh Due: Tuesday, September 30 th 2008 (Noon Time) Description In the previous two assignments, we focused on the functionalities of a social networking site, i.e., MySpace. Individuals signup as members of the site and become friends with one another to socialize. Assuming fictional superheroes as members of a social network site, in this homework assignment, you will author SQL commands to perform the following tasks: 1. Retrieve the first and last name of all female superheroes. 2. Retrieve the first and last name of those superheroes whose friends is a superset of Superman’s friends. 3. Retrieve the first and last name of those superheroes with fewer than 4 friends. 4. Retrieve the name of each superhero and the number of his or her friends. 5. Delete the superhero with minimum number of friends. You are provided with both a database schema and its instance.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/28/2008 for the course CS 485 taught by Professor shahram during the Fall '08 term at USC.

Ask a homework question - tutors are online