HOW DO I CREATE AN SQL FILE AND RUN IT FOR THE FOLLOWING TABLE. STEP 2 AND 3. LA
ID: 3596935 • Letter: H
Question
HOW DO I CREATE AN SQL FILE AND RUN IT FOR THE FOLLOWING TABLE. STEP 2 AND 3.
LAB 03- CREATE/ALTER TABLE&TABLE; CONSTRAINTS For this lab exercise, you will deal with four tables for the CoyoteCorp DB Table Name EMP Attributes Primary Key Description An individual who works in CovoteCor Unique id, format 9999 First name of the emplovee Last name of the emplovee Home address of the employee Gender of the em Yearly salary of the employee, format 999999, salary cannot be lower than $12,000 Job role of the employee in CoyoteCorp - clerk, programmer, manager, sales representative, account representative, dba Department number that this employee works for, format 99 An employee can work in only one department and a department can have more than one employee Every employee must work in a department. Every department must have at least 1 employee Not every employee will manage a department. An employee need not work on a project. But every project must have at least one employee working on it. A functional division within CoyoteCorp Unique id, format 99 Name of the functional division - IT, Sales, Accounting, Marketing, empNo empNo fname Iname address sex salary F- female or M-male position deptNo DEPT deptNo deptNumber deptNameExplanation / Answer
2. Create table Queries
Employee:-
Department:-
Project:-
Emp_Project:-
3. Foreign Key updation Queries:-
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.