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.2K

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

54 million aborted Americans never had the choice you had by the way Based on...

Biology
Q

Given f x 6x and g x 2x 6 find the following expressions a fog...

Algebra
Q

F IF B 4 Graphing Quadratic Functions Zb 1 Which parabola has an axis of...

Algebra
Q

Type your answers in all of the blanks and submit X Q Fill in each...

Algebra
Q

Please show your work 8 One of the first...

Accounting
Q

Westwood specialties had in increase in taxable income of $5,000,000 this year. Their increase in...

Accounting
Q

RECEIVABLES LEDGER CONTROL ACCOUNT Opening balance 138400 Cash received from credit customers 78420 216820 Credit...

Accounting
Q

PLEASE ANSWER P8.11 PART A ONLY PLEASE!!! 100 18.11 (LO...

Accounting
Q

Power Corporation acquired 75 percent of Best Companys ownership on January 1, 20X8, for $90,000....

Accounting
Q

eBook Show Me How Contribution Margin and Contribution Margin Ratio For a recent year, McDonald's...

Accounting
Q

per year: machine for $2,600 pet year and per-unit inspection conts of $3.20. The good...

Accounting
Q

CR Corporation distributes $70,000 to its sole shareholder H. CR's has earnings and profits of...

Accounting