Exercise 5: Database case study

Do EITHER Case A or Case B as your database case study for this exercise.

On your own machine, setup and test either database system and report your findings.
Case A: Microsoft SQL server
The relational DBMS uses Structured Query Language (SQL) as a standard. Microsoft SQL Server 2008 has support for .NET Framework, so that stored procedures can used be in any of the .NET languages. Microsoft Dreamspark at dreamspark.com is an interesting site for the student/developer using Microsoft products.

1. Investigate the. SQL Server 2008 architecture available from the Dreamspark website.

2. Test out the SQL Server Express as a lightweight application development tool. SQL Server 2008 Express Edition and report your findings.


Microsoft SQL Server is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions.
SQL Server 2008 contains "studios" to help you with development and management tasks: SQL Server Management Studio and Business Intelligence Development Studio.
In Management Studio, you develop and manage SQL Server Database Engine and notification solutions, manage deployed Analysis Services solutions, manage and run Integration Services packages, and manage report servers and Reporting Services reports and report models.
In BI Development Studio, you develop business intelligence solutions using Analysis Services projects to develop cubes, dimensions, and mining structures; Reporting Services projects to create reports; the Report Model project to define models for reports; and Integration Services projects to create packages.