Lab Assignment 3
Querying a Relational Database COMPANY database
For Lab3, you use the Company database you created from Lab2.
Make sure that all your tables have the exactly same data as given in the Lab 2 (Note
that the data in Fig 3
Lab Assignment 1
Creating Relational Table Schema and Populating with Data
1. Creating tables for 2 Entities in the COMPANY database schema using SQL (Data Definition
Language) statements in MS SQL Server.
The COMPANY database schema i
Lab Assignment 2
Creating a Relational Database Schema from ER Diagram and Populating
1. BEFORE adding any PK Constraint or PK-FK Constraints in your tables, do the following
test. If you already added PK, then drop it using Alter