Answered step by step
Verified Expert Solution
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...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