Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra A Modern Introduction

Authors: David Poole

3rd edition

9781133169574 , 978-0538735452

More Books

Students also viewed these Databases questions

Question

13-16 What are the rules of engagement for young consumers?

Answered: 1 week ago