Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. assignment 3 note: tables referred in this assignm

Assignment 3 Note: Tables referred in this assignment are same as that of Assignment 2. 1. For each...

60.1K

Verified Solution

Question

Programming

Assignment 3 Note:

Tables referred in this assignment are same as that ofAssignment 2.

1. For each table, append your student id along with the tablename. For e.g. employee_student id (employee_T16363737)

2. Format for questions: a. Question: b. SQL statement solutionc. Screenshot for correct input d. Screenshot for violation (ifany)

Q1) Check the structure of tables.

Q2) Check the constraint name for applied constraints?

Q3) Drop the unique constraint on ENAME

Q4) Drop the Foreign Key constraint on DEPTNO

Q5) Add Foreign Key constraint on DEPTNO

Q6) Change Data type of ENAME. (If previously you have marked itas VARCHAR 2, then make it CHAR or vice versa)

Q7) Change width of DNAME ( For e.g. If you have defined it’ssize has 20 then make it 30)

Q8) Add COMM column in EMP table

Q9) Drop CITY column from S table

Q10) Create duplicate copy of EMP table

Q11) Copy structure of DEPT table in another table withdifferent column names

Q12) Change the name and job of the employee whose EMPNO=100

Q13) Delete the record of employee who belong to computerdepartment

Q14) Drop DEPT Table

Q15) Drop duplicate table of EMP table

Answer & Explanation Solved by verified expert
3.8 Ratings (303 Votes)
1 SELECT FROM INFORMATIONSCHEMACOLUMNS WHERE TABLENAMEtableName for one particular table OR SELECT TABLENAME FROM INFORMATIONSCHEMATABLES it will return all the tables in the database that we are querying 2 SELECT CONSTRAINTNAME    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A(aq) + B(aq) → 2C(aq) If Kc = 3.4 x 10-17, this indicates that ..... At equilibrium there...

Chemistry
Q

X and Y are large parallel conducting plates close to each other Each face has...

Physics
Q

5 A beam of cathode rays is subjected to crossed electric E and magnetic fields...

Physics
Q

Question 14 Write an equation for the polynomial graphed below 5 4 y x 3...

Basic Math
Q

Final Assignment You are an assistant in a department of a...

Accounting
Q

At the end of the fiscal year Zeta Tube performs an analysis comparing current year...

Accounting
Q

Students should write a full report to compare between applying the periodic inventory system and...

Accounting
Q

Intermediate accounting 51) What is interest? a) Return on capital. b)...

Accounting
Q

Cavy Company estimates that total factory overhead costs will be $495,880 for the year. Direct...

Accounting
Q

Alpha Corporation was organized in 2017. At December 31, 2017. Alpha Corporation's balance sheet reported...

Accounting
Q

Hi! I n eed help with problem. Thanks a bunch! :)...

Accounting
Q

f ! Required Information [The following information applies to the questions displayed below.]...

Accounting