Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. 2. Alter the definition of
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started