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

Q

Consider the function f x x 3 What is the domain and the range of...

Algebra
Q

Sprinter Usain Bolt reached a maximum speed of 11.2 m/s in 2.0s while running 100-m dash....

Physics
Q

This question is based on the current Covid-19 pandemic. The pandemic will cause a recession. Provide...

Economics
Q

When activity times are known with certainty, the critical path is defined as the set of...

General Management
Q

7 Determine which two of the three given triangles are similar Find the scale factor...

Geometry
Q

The table below shows a summary of Henry s credit card statement for the month...

Basic Math
Q

Show that the Bell state y 1 2 100 111 is an entangled s

Basic Math
Q

A perfect gas enclosed by an insulated upright cylinder with a weightless piston on top...

Basic Math
Q

The campus of a college has plans to construct a rectangular parking lot on land...

Algebra
Q

if the bank balance was R10000( favorable) at the end beginning of the year and...

Accounting
Q

The management of Devin Corporation is testing two of its reporting units for impairment of...

Accounting
Q

Data on Solito Co. for the most recent year are shown below, along with the...

Finance