1. Given an ERD, define tables and constraints on the data, using the Create Table statement...

 

Transcribed Image Text:

1. Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. 2. Alter the definition of an existing table using the Alter Table statement. 3. Create indexes on non-primary key fields using the Create Index statement. 4. Insert data using the Solution.sal file to insert data into your tables and debug any errors. Requirements: 1. Given the ERD shown in the appendix, create the required tables for the Graffiti Busters database including primary key and foreign key constraints. All the attributes that are on the ERD are required attributes and cannot be null. 2. Create the following constraints (check and default). The following constraints must be included in your table definitions. Table Column Check Default 20 3 StaffType Training Job Job Client Job Wage Credits Province PC Phone SubTotal/Total StaftType Client >0 Subtotal Column JobNumber StaffTypeCode 1. Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. 2. Alter the definition of an existing table using the Alter Table statement. 3. Create indexes on non-primary key fields using the Create Index statement. 4. Insert data using the Solution.sal file to insert data into your tables and debug any errors. Requirements: 1. Given the ERD shown in the appendix, create the required tables for the Graffiti Busters database including primary key and foreign key constraints. All the attributes that are on the ERD are required attributes and cannot be null. 2. Create the following constraints (check and default). The following constraints must be included in your table definitions. Table Column Check Default 20 3 StaffType Training Job Job Client Job Wage Credits Province PC Phone SubTotal/Total StaftType Client >0 Subtotal Column JobNumber StaffTypeCode