Question: 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

1 Expert Approved Answer

Step: 1 Unlock

CREATE PROCEDURE dboCreateeCommerceTables AS IF NOT EXISTS SELECT FROM sysTables WHERE namecustomer CREATE TABLE Customer CustID INT NOT NULL fname VA... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Early in its fiscal year ending December 31, 2024, San Antonio Outfitters finalized plans to expand operations. The first stage was completed on March 28 with the purchase of a tract of land on the...

To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Suppose you have a subject property with a 105,000 sq. ft. lot and existing improvements for which you estimate the reproduction cost new to be $2,500,000, physical deterioration to be $400,000,...

What are budgeted fixed costs at normal volume?

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

Find a qualitative study (e.g., Sample Study 1.2 or 1.3, or find a study by doing a literature search) and explain what the researchers did or could do to improve the quality of their study....

Suppose that we modify the model of the firm's investment behavior by assuming that any capital the firm has remaining at the end of the period can be sold at the price p'K (in our model we assumed...

4 3 4 . Nitriding of a steel part does not increase its Grain size Fatigue limit Surface hardness Wear resistance

Mercy, Nelly and Olive are in partnership sharing profits and losses equally after allowing for interest on capital at the rates of 5% per annum to the partners and a salary to Nelly of $ 60 per...

The primary tool for implementing integration in the Canadian tax system involves which two procedures: a. Dividend Gross Up and Dividend Tax Credit b. Dividend Gross Down and Royalties Tax Credit c....

Describe how a company's failure to determine its design capacity and system capacity will affect its ability to turn a profit. Give a concrete example to demonstrate this effect Note: In Essay Form

Q 1 . ?Consider the anthropomorphic arm as shown in Fig. where the link frames have been illustrated, determine the manipulator Jacobian matrix and analyze it . ( solve with complete step numerically...

As a health care consumer who recently switched to a managed care health plan, you were very worried about the quality of the care provided to you. You were wondering if there were any reviews of...

Given the estimated regression equation E(Y) = 30 + 2(x1) - 3(x2) + 10(x1x2) where x1= age and x2-gender (0 is female, 1 otherwise) what is the estimated value of Y when x1= 30 and x2-female? 90 387...

Consider a call center for software support: - 3 representatives answer phones (each can handle all types of calls) - Calls arrive according to a Poisson process. On average, there are 20 calls per...

Write as precisely as possible without plagiarizing. (30 pts) Place the following functions in order from asymptotically smallest to largest. As a convenience you may use f(n)

Refer to Example 9.15. Add the following functionality to this program: Allow the user to enter the cost of a gallon of gas on each trip and use a function, Cost() to calculate the cost of purchasing...

Under what circumstances would you not need to break down an overall design into a consideration of individual user views?

What does it mean when a data warehouse is nonvolatile?

Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Design a database to...

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

First substitute the given values into the formula obtained from the inside- back cover. Then manipulate the resulting equation to solve for the unknown variable. Obtain dollar amounts accurate to...