Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Needs to be done in sql using cmd 3:11 PM moodle.latech.edu AT&T Hint you have two ways to define foreign key, one is to define

image text in transcribedNeeds to be done in sql using cmd
3:11 PM moodle.latech.edu AT&T Hint you have two ways to define foreign key, one is to define foreign key within the CREATE TABLE statement, for example: CREATE TABLE products (product id numeric(10) not nul, supplier id numeric(10) CONSTRAINT fk supplier FOREIGN KEY (supplier id) REFERENCES supplier(supplier_id) ON DELETE SET NULL) Another way is to create table without defining foreign key and add foreign key later using the ALTERTABLE statement (sometimes you might have to do like this), for example: ALTER TABLE Products ADD CONSTRAINT fk supplier FOREIGN KEY (supplier id) REFERENCES supplier(supplier id) ON DELETE SET NULL Insert Data Table Name: EMPLOYEE XXx SaperSSN Table Name: DEPARTMENT XxX DName Mamafacture escarch 133445555 22-MAY-78 Table Name: DEPT LOCATION XXX New York Salt Lake afford

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

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

Which team solution is more likely to be pursued and why?

Answered: 1 week ago

Question

4. I can tell when team members dont mean what they say.

Answered: 1 week ago