Write the necessary SQL DDL command to create the Employee table in the given Company Database....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write the necessary SQL DDL command to create the Employee table in the given Company Database. (Ctr)- Table EMPLOYEE EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 MARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER Table DEPARTMENT DEPTNO DNAME 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS Table SALARYGRADE GRADE 1 INMAA 2 3 4 5 LOSAL 700 1201 1401 2001 3001 308 CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK LOC NEW YORK DALLAS CHICAGO BOSTON HISAL 1200 1400 COMPANY DATABASE 2000 3000 9999 MGR HIREDATE 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP-81 7839 01-MAY-81 7839 09-JUN-81 7566 19-APR-87 17-NOV-81 7698 08-SEP-81 7788 23-MAY-87 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 SAL B00 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 COMM 300 500 1400 DEPTNO 20 30 30 20 30 30 10 20 10 30 20 30 20 10 Write the necessary SQL DDL command to create the Employee table in the given Company Database. (Ctr)- Table EMPLOYEE EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 MARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER Table DEPARTMENT DEPTNO DNAME 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS Table SALARYGRADE GRADE 1 INMAA 2 3 4 5 LOSAL 700 1201 1401 2001 3001 308 CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK LOC NEW YORK DALLAS CHICAGO BOSTON HISAL 1200 1400 COMPANY DATABASE 2000 3000 9999 MGR HIREDATE 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP-81 7839 01-MAY-81 7839 09-JUN-81 7566 19-APR-87 17-NOV-81 7698 08-SEP-81 7788 23-MAY-87 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 SAL B00 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 COMM 300 500 1400 DEPTNO 20 30 30 20 30 30 10 20 10 30 20 30 20 10
Expert Answer:
Answer rating: 100% (QA)
Referencing to your question As given Employee Table with ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
In today's world, a lot of business- and marketing-related events occurs. Business students should follow what is going on out there to stay current and to prepare for the future. So, choose and read...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...
-
In Exercises 8194, begin by graphing the absolute value function, f(x) = |x| . Then use transformations of this graph to graph the given function. h(x) = x +31-2
-
Determine by direct integration the moment of inertia of the shaded area with respect to the y axis. b. -y= k(x-a)2+ e
-
Tell how many roots of the following polynomial are in the right half plane, in the left half-plane, and on the j-axis: P(s) = s 5 + 6s 3 + 5s 2 + 8s + 20
-
Consider the delivery time data discussed in Example 11.3. Find the PRESS statistic for the model developed from the estimation data. How well is the model likely to perform as a predictor? Compare...
-
In 2014, Pennington Corporation had net sales of $600,000 and cost of goods sold of $360,000. Operating expenses were $153,000, and interest expense was $7,500. The corporations tax rate is 30%. The...
-
Who and what defines professionalism? As emerging leaders in the field, it will be your role to set the standard - the bar - for those who follow in your footsteps. As with children, modeling for...
-
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSRs products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per...
-
On July 1, 2020, ZI was admitted to the partnership when he purchased a proportionate interest from JE and LAI representing 20% interest in the net assets and profits of the firm for P100,000. On...
-
Compute Arrow's Net Income for the year 2023 based upon their Statement o Retained Earnings: Beginning Retained Earnings Net Income for 2023 Dividends paid in 2023 $ 350,000 $ ???? Ending Retained...
-
In exploring the global landscape of financial regulation and supervision, what are the key challenges and opportunities associated with cross-border coordination and cooperation among regulatory...
-
In examining the intricacies of bank capital adequacy and risk management frameworks, could you delineate the nuances of Basel III regulatory standards, including the measurement of credit, market,...
-
The credit card as a form of electronic payment is widely used both nationally and internationally.South African consumer legislation especially the national credit act has a profound effect on the...
-
During 2023, Nale Corp. received dividends of $1,000 from a 10%-owned taxable domestic corporation. When Nale computes the maximum allowable deduction for charitable contributions in its 2023 return,...
-
Your research project must be TYPED, double-spaced, and 7th edition APA formatted. Use Times New Roman size 12 font for the body of the report (4-5 pages excluding the cover page and reference page)....
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
How do you sort data in an Access query?
-
In Example 1, why is the data type for the Postal Code field CHAR and not SMALLINT or INTEGER? Is the length of the field long enough? Why or why not?
-
List the changes you would need to make in your answer to Question 7 if you must store the year and the semester in which a student took a course and received a grade.
-
The pocket of hot air appears to be a pool of water because A. Light reflects at the boundary between the hot and cool air. B. Its density is close to that of water. C. Light refracts at the boundary...
-
Which of these changes would allow you to get closer to the mirage before it vanishes? A. Making the pocket of hot air nearer in temperature to the air above it B. Looking for the mirage on a windy...
-
If you could clearly see the image of an object that was reflected by a mirage, the image would appear A. Magnified. B. With up and down reversed. C. Farther away than the object. D. With right and...
Study smarter with the SolutionInn App