Purchase Solution

Complete New SQL Database

Not what you're looking for?

Ask Custom Question

To be used with SQL Server 2005 Express

Create a database and name it ITD_GPA. Populate your database with appropriate test data.
- Include all of the scripts in a single file called ITD_GPA.SQL
- Create at least three related tables in the database.
- Create at least two stored procedures and a script to use each of them.
- Create at least one view (using a script).
- Create at least one trigger.
- Create at least five useful queries. At least one of these queries should use a subquery and at least one of the queries should use an aggregate function.
- All scripts should be well documented.

Summary:
In addition to this will prepare a summary document with the following information. This document will be submitted as a separate item along with the ZIP of the database and the associated files..
1. a Word document describing the system
2. an ERD or other graphical representation of the system
3. a description of the views, stored procedures, triggers, and queries
4. step-by-step instructions on how to run the queries that will demonstrate the functionality of the system
5. a summary of strengths and weaknesses of the system, as designed
Submit the database, log file, query files in a zip file called ITD_GP.ZIP, and the individual summary document as a separate submission. Please detach the database before creating the zip file.

Attachments
Purchase this Solution

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.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Excel Introductory Quiz

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