Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want a Solution of this (ERD chen notation) By using sql language (create table,alter,etc) and Determine and determine PRIMARY KEY and FOREIGN KEY Legionid

I want a Solution of this (ERD chen notation) By using sql language (create table,alter,etc) and Determine and determine PRIMARY KEY and FOREIGN KEY

image text in transcribed

Legionid last_name salary first_name (phone_number commission_pco Chire_data name email (0.M) REGION region name employee_id manages M:1 min_salary (1,1) job_title max_salary EMPLOYEE (0.1) 1:M in jab_id (1.1) (1.1) (1,1) country_id JOB has 1:M COUNTRY country_name |(1,1) (0,M) start_date |(1,M) manages works_for 1.M (1.1) (1,1) job_history |(0,1) (0.1) 1:M end date (1,M) (1.M) location id department id street_address DEPARTMENT LOCATION department_name postal_code M:1 (1,1) (0,1) in city state_province

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_2

Step: 3

blur-text-image_3

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

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

2nd Edition

1597499471, 978-1597499477

More Books

Students also viewed these Databases questions