Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Delete all the tables in your database. Make a script that creates the tables for the ERD below. Choose data types that seem appropriate.

Delete all the tables in your database. Make a script that creates the tables for the ERD below. Choose data types that seem appropriate. Make sure that you use the proper cascading foreign key constraint actions where necessary. Ensure that the composite foreign key in Field is truly composite. Set cpolicylD in Field so the value is set to NULL if the parent value is deleted. Attribute names in bold cannot be null (all primary keys plus Username, Password, AgencyID, InsuredID, StateCode and SectionID). Leave your populated tables in your database so I can check them. You must do this on my SQL Server instance. Upload your script to Canvas as FarmandRanch.sql Agency AgencyID AgencyStreet H AgencyCity AgencyZip AgencyPhone System Account SystemiD AgencyID Username Password Crop CPolicy D CropName Field Field10 CPolicy D StateCode Section D YieldPerAcre Policy PolicylD AgencylD InsuredID CoverageAmount PolicyDate Cattle LPolicy D Breed Section StateCode H-SectionID SoilType PercentArable -H- Primary Insured Insuredi InsuredName InsuredPhone

Step by Step Solution

3.50 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

CREATE PROCEDURE dboCreateeCommerceTables AS IF NOT EXISTS SELECT FROM sysTables WHERE namecustomer CREATE TABLE Customer CustID INT NOT NULL fname VA... 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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

What are budgeted fixed costs at normal volume?

Answered: 1 week ago

Question

6-49. What is the primary decision facing Starbucks?

Answered: 1 week ago

Question

What does it mean when a data warehouse is nonvolatile?

Answered: 1 week ago

Question

Evaluate each of the following expressions to six-figure accuracy.

Answered: 1 week ago