Database Management Systems	Signin
Home | Syllabus |Assignments | SQL Tutorial | SQL Learn | Quick SQL | Downloads | Handouts | MY Page | Contact

Assignments

Assignmnent #4 -Due Date(6/2/2004)

Create the database for selling books online as discussed in the Lecture. Research how to create relationships among tables and use it for this assignment.

Assignmnent #3 -Due Date(5/26/2004)

Create the following tables in your SQL Learn account as discussed in the Lecture

• STUDENT
• TEST_TYPE
• COURSE
• GRADES

Assignmnent #2 -Due Date(5/24/2004)

Write appropriate SQL for the following english queries. Use the SPJ datasheet for reference

1. Get the names of all suppliers
2. Get the names of parts whose weight is between 10 and 15
3. Which supplier supplied what parts to the 'Sorter' job?
4. Which jobs require red parts?
5. Get the names of the suppliers who supplied in 1998 and 1999
6. Get the names of the suppliers who never supplied anything in 1999
7. Which supplier supplied the most parts ever?
8. What is the total quantity of parts ordered for the 'Sorter' job?
9. What are the parts that 'Adam' ever supplied?
10. What is the most recently shipped job?
11. What is the total weight of a 'Terminal'?
12. Which supplier has the lowest status?
13. What is the total weight of all the parts?
14. Which of the jobs had all the parts from the same city?
15. Get the names of the parts required to finish the 'Tape' job
16. Which city had the maximum number of parts originating from it?

Assignmnent #1 -Due Date(5/19/2004)-

Write appropriate SQL for the following english queries. You could use Quick SQL to test your queries

1. Get the names of all people
2. Get the names and phone numbers for all John's in the database
3. Get the maximum and minimum phone numbers
4. How many people in the database have their first name that starts with 'J' or 'P'