Headline

A relational database using SQL Server

Motivation

Please note: This implementation is prerequisite for Contribution:ef. A simple relational schema is used to model the data part of the system:Company. In particular, there are tables for companies, departments, employees (and persons). Further, there are primary and foreign keys that represent different types of relationships. For instance, departments associate themselves with a company by a foreign key. The SQL-based implementation also includes triggers--to represent constrains/cardinality. Finally, there are SQL scripts covering the operations for totaling and cutting salaries. An implementation of the query for the depth of departmental nesting is available as well, but it is strikingly complex because of SQL's known issues with recursion.

Architecture

The following artifacts are used to create relational model for 101companies:

  • Tables (TableName.table.sql)
  • Primary keys (Name.pkey.sql)
  • Foreign keys (Name.fkey.sql)
  • Triggers (Name.trigger.sql)
The scripts/Post-Deployment folder contains script file executed after the database schema was created to fill in the database with actual 101companies data.

Usage

Technology:Visual Studio 2010 should be used to open a project file. The deploy option should be used to create the database. The target connection (in project properties) should be adjusted for the local database server.

This contribution has been tested with SQL Server 2008 and Visual Studio 2010.


There are no revisions for this page.

User contributions

    This user never has never made submissions.

    User edits

    Syntax for editing wiki

    For you are available next options:

    will make text bold.

    will make text italic.

    will make text underlined.

    will make text striked.

    will allow you to paste code headline into the page.

    will allow you to link into the page.

    will allow you to paste code with syntax highlight into the page. You will need to define used programming language.

    will allow you to paste image into the page.

    is list with bullets.

    is list with numbers.

    will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.

    will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.

    will allow your to insert code snippets from @worker.

    Syntax for editing wiki

    For you are available next options:

    will make text bold.

    will make text italic.

    will make text underlined.

    will make text striked.

    will allow you to paste code headline into the page.

    will allow you to link into the page.

    will allow you to paste code with syntax highlight into the page. You will need to define used programming language.

    will allow you to paste image into the page.

    is list with bullets.

    is list with numbers.

    will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.

    will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.

    will allow your to insert code snippets from @worker.