Lab 4. Procedures, functions, views, triggers, indexes

• assigned: weeks 9/10; due: weeks 11/12

On the database created for lab 1:

1. implement a stored procedure for the INSERT operation on a table; the procedure’s parameters should describe the entities / relationships in the table; the procedure should use at least 2 user-defined functions to validate certain parameters;

2.…

Lab 3. Altering the Database

• assigned: weeks 7/8; due: weeks 9/10

Sometimes, after you design a database, you need to change its structure. Unfortunately, changes aren’t correct every time, so they must be reverted. Your task is to create a versioning mechanism that allows you to easily switch between database versions.…

Lab 2. SQL Queries

• assigned: weeks 3/4; due: weeks 7/8

On the relational structure created for the first lab, write SQL statements that:

• insert data – for at least 3 tables;
• update data – for at least 2 tables;
• delete data – for at least 1 table.

Lab 1. Database Design

• assigned: weeks 1/2; due: weeks 3/4

Imagine a simple application that requires a database. Represent the application data in a relational structure and implement the structure in a SQL Server database. The database must contain at least: 7 tables, one 1:n relationship, one m:n relationship.…