Write sql statement to delete dept

Write sql statement to delete dept_id 1

Reference no: EM13775615

Add 2 employees into EMPLOYEE12 table with one employee should belong to dept_id 1 and another employee should belong to dept_id 2. Remember to create and use Sequence number for employee_id which will start from 1000 and increment by 1 20.Write SQL statement to delete dept_id 1 from Department table. Explain what happens when you attempt the SQL statement 21.To enable delete of department with dept_id 1, you need to use the ON DELETE clause in Foreign Key constraint. Refer to Oracle documentation for further guidance. Drop
Foreign Key constraint and recreate with ON DELETE clause 22.Now, delete department with dept_id 1. Explain what happens
23.Modify table DEPARTMENT12 to add a column DIVISION that should be constrained to check values in the range of 51 and 100
24.Modify DEPARTMENT12 table to add constraint on dept_name to ensure that all records inserted will have dept_name in UPPERCASE. Review Oracle Documentation if needed 25.Test the constraint 26.Write a query to display all constraints for table EMPLOYEE12 and DEPARTMENT12

Reference no: EM13775615

Questions Cloud

Identify and discuss the chain of command : Write a 500-600 word, 2 page paper, identify and discuss the chain of command and how problems can arise within the organizational structure

Health care environment issues : What is prevention? Why is it important?

Construct flexible budget for hospitals electricity costs : Red River Hospital’s controller estimates that the hospital uses 30 kilowatt-hours of electricity per patient day, and that the electric rate will be $.12 per kilowatt hour. The hospital also pays a fixed monthly charge of $1,250 to the electric util..

Labour-intensive production operating standard absorption : A labour-intensive production unit operating a standard absorption cost accounting system provides the following information for period 10:

Write sql statement to delete dept_id 1 : Add 2 employees into EMPLOYEE12 table with one employee should belong to dept_id 1 and another employee should belong to dept_id 2. Remember to create and use Sequence number for employee_id which will start from 1000 and increment by 1 20.Write SQL..

Human resources for a large organization : Explain the need for equal employment opportunity laws in organizations. How has it impacted HRM? Defend your position.

Describe in detail a problem at work and convincing : Describe in detail a problem at work, persuading and convincing the reader that it needs fixing. Provide a detailed description of two possible solutions ("alternatives") that could be implemented to resolve the problem identified.

Were the items grown and shipped in from another country : Were the items grown and shipped in from another country? What types of processing and packaging must take place in order for you to be able to purchase the product

Companys break-even point in units : A company manufactures and sells a product for $150 per unit. The company's fixed costs are $68,200, and its variable costs are $95 per unit. The company's break-even point in units is:

User Account

All Pages