Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. dbms create/insert/update sql i need the create, i

DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table as if...

70.2K

Verified Solution

Question

Programming

DBMS Create/Insert/Update SQL

I need the create, insert, and update SQL statement for thistable as if it were being added to MySQL (please give explanationsfor each line of SQL code and a copy of the code as it would beentered into the query by itself:

Customer
PKCustomer IDText
Phone Numberint
nametext
address IDint
emailtext
FKvendor IDint

Vendor is the name of the table the FK comes from.

Answer & Explanation Solved by verified expert
3.7 Ratings (640 Votes)
1 Sql Query for creating vendor table create table VendorvendorID int primary key vendorname varchar100 primary key synatx is used to create primary key 2 Sql Query for creating Customer table create table    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

Culver Company, a manufacturer of small tools, provided thefollowing information from its accounting records...

Biology
1.2K views

List the steps for the Acid Fast Stain Procedure: List the steps for processing specimens for AFB...

Psychology
1.2K views

Childhood friend eassay in Arabic language

Basic Math
1.2K views

Write a quadratic equation having the given number as a solution.9, only solution (Hint: It...

Accounting
1.2K views

On October 1, 2020, Blue Equipment Company sold...

Accounting
1.2K views

Answer the following scenarios regarding the Blueberry company A. Blueberry company had net...

Accounting
1.2K views

A company produces 600 microwave ovens per month, each of which includes one electrical circuit....

Finance
1.2K views

Multiple Choice Question 59 E] Your answer is incorrect. Try again. You are considering two...

Finance
1.2K views

Nuclear power plants are required to have full decommissioning costs accumulated during the useful life...

Finance
1.2K views

just step 1 and 2 on part d please Anne-Marie...

Accounting
1.2K views

ofit on the appropriate financial statement (amounts in thousands), assuming the perpetual inventory system is...

Accounting
1.2K views

Pina Colada Corp. uses a perpetual inventory system. The company had the following inventory transactions...