Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL SERVER TABLE CODE IN NOTEPAD please SQL Table Creation Homework Due 2 April 1. You own a farm (ok, a big farm) and want

image text in transcribedSQL SERVER TABLE CODE IN NOTEPAD please

SQL Table Creation Homework Due 2 April 1. You own a farm (ok, a big farm) and want to start a DB to keep track of important things. In particular vou want to keep track of crops and animals. 2. Create the following tables, with at least the field information listed (the info provided are not field names; you supply them): A. Crop -crop name -cost of seed (per bushel) yield per acre (in bushels) -current number of acres planted in the crop -average cost to grow per acre -date the crop is ideally planted B. Animal -animal name (e.g., "cow"); this may not be null type (either "D? for domestic or " N" for foreign) -current number of head owned -offspring? (a yeso field that states if the animal could have baby animals on the farm) 3. Create the proper relationship between the two tables. The business rules are that an animal may be fed one crop, and a crop is fed to one or more animals. 4. After you have done the above, add a field the gives the average number of days that it takes for a crop to grow, from planting to harvesting. Do not let this value be left blank For this homework, I want the hardcopy Notepad++ printout of the code

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

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions