Introductory Circuit Analysis (13th Edition)
Introductory Circuit Analysis (13th Edition)
13th Edition
ISBN: 9780133923605
Author: Robert L. Boylestad
Publisher: PEARSON
Bartleby Related Questions Icon

Related questions

Question
Problem 1.1: Create a table called EMP with the following structure.
Name
Туре
EMPNO
NUMBER(6)
ENAME
VARCHAR2(20)
JOB
VARCHAR2(10)
MGR
NUMBER(4)
DEPTNO
NUMBER(3)
SAL
NUMBER(7,2)
Problem 1.2: Add a column COMMISSION which can hold NULL value.
Problem 1.3: Modify the column width and data type of the JOB field of EMP1 table.
Problem 1.4: Create DEPT table with the following structure.
NAME
TYPE
DEPTNO
NUMBER(2)
DNAME
VARCHAR2(10)
LOC
VARCHAR2(10)
DEPTNO as the PRIMARY KEY
Problem 1.5: Add constraints to the EMP1 table that EMPNO as the PRIMARY KEY and
DEPTNO as the FOREIGN KEY.
Problem 1.6: Add constraints to the EMP1 table to check the EMPNO value while
entering (i.e) EMPNO > 100.
Problem 1.7: Salary value by default is 5000, otherwise as entered values.
Problem 1.8: Add a column DOB to the EMP1 table.
Problem 1.9: DROP the column DOB from EMP1 table.
Problem 1.10: Create the table EMP2 with all its columns from EMP1 using AS SELECT
keyword. Delete all its records and finally DROP the EMP2 (pseudo table).
expand button
Transcribed Image Text:Problem 1.1: Create a table called EMP with the following structure. Name Туре EMPNO NUMBER(6) ENAME VARCHAR2(20) JOB VARCHAR2(10) MGR NUMBER(4) DEPTNO NUMBER(3) SAL NUMBER(7,2) Problem 1.2: Add a column COMMISSION which can hold NULL value. Problem 1.3: Modify the column width and data type of the JOB field of EMP1 table. Problem 1.4: Create DEPT table with the following structure. NAME TYPE DEPTNO NUMBER(2) DNAME VARCHAR2(10) LOC VARCHAR2(10) DEPTNO as the PRIMARY KEY Problem 1.5: Add constraints to the EMP1 table that EMPNO as the PRIMARY KEY and DEPTNO as the FOREIGN KEY. Problem 1.6: Add constraints to the EMP1 table to check the EMPNO value while entering (i.e) EMPNO > 100. Problem 1.7: Salary value by default is 5000, otherwise as entered values. Problem 1.8: Add a column DOB to the EMP1 table. Problem 1.9: DROP the column DOB from EMP1 table. Problem 1.10: Create the table EMP2 with all its columns from EMP1 using AS SELECT keyword. Delete all its records and finally DROP the EMP2 (pseudo table).
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Electrical Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, electrical-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Introductory Circuit Analysis (13th Edition)
Electrical Engineering
ISBN:9780133923605
Author:Robert L. Boylestad
Publisher:PEARSON
Text book image
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:9781337900348
Author:Stephen L. Herman
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Electrical Engineering
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Text book image
Fundamentals of Electric Circuits
Electrical Engineering
ISBN:9780078028229
Author:Charles K Alexander, Matthew Sadiku
Publisher:McGraw-Hill Education
Text book image
Electric Circuits. (11th Edition)
Electrical Engineering
ISBN:9780134746968
Author:James W. Nilsson, Susan Riedel
Publisher:PEARSON
Text book image
Engineering Electromagnetics
Electrical Engineering
ISBN:9780078028151
Author:Hayt, William H. (william Hart), Jr, BUCK, John A.
Publisher:Mcgraw-hill Education,