Question: Objective: Create a single entity database. a . Examine the three data instances below about farm implements. Identify a primary key for a table to
Objective: Create a single entity database.
a Examine the three data instances below about farm implements. Identify a primary key for a table to be created. Choose natural language names for the table and columns. Minimize the use of codes or abbreviations for those names. The table may include the major attribute types: integer, character or variablelength character, date, and decimal with fractional part.
Choose types and lengths consistent with this data.
Farm Implement name cost datepurchased, category, modelYear:
Box Blade grader,
Cultivator, tillage,
Finishing Mower ft cutter,
b Prepare an SQL statement to create the table.
c Compose data instancesrows for your entity class. Character data should be in the same caseupper, lower, or "initial cap". Then Code SQL INSERT statements for your table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
