Purchase Solution

Database and SQL Database Manipulation Language

Not what you're looking for?

Ask Custom Question

For the Trident University Student database, generate reports that specified in module 2 SLP.

1. Students who live in California
2. Student who live outside California
3. Name of students who take ITM440 course
4. Name of students who live in California and take ITM440 course
5. Student names, courses they have taken, and letter grade for each of these courses.
6. Any other information you would like to retrieve from the database?

Write a paper (2-5 pages) that includes your SQL statements and screenshots of the result of your queries in OpenOffice.

Purchase this Solution

Solution Summary

This solution will help to understand how to insert and retrieve information from database tables created in an Access database. The business model is a university student database where students take different courses offered in specific faculties.

Purchase this Solution

Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

This quiz tests a student's knowledge about C++ operators.