Create table department

Assignment Help Basic Computer Science
Reference no: EM13780826

Create table DEPARTMENT12 that includes columns dept_id and dept_name2. Create a table EMPLOYEE12 that includes the columns employee_id, FirstName , MiddleName,LastNarne, and social security number3. Modify the EMPLOYEE12 table to create a composite unique key on combination of firstname,middlename and lastname4. Create a sequence as below:CREATE SEQUENCE deptseqSTART WITH 1INCREMENT BY 1;5. Insert 2 records into DEPARTMENT12. Remember to use Sequence numbers for dept_id6. Modify EMPLOYEE12 table to add column dept_id (Foreign key)7. Add 2 employees into EMPLOYEE12 table with one employee should belong to dept_id 1 andanother employee should belong to dept_id 2. Remember to create and use Sequence numberfor employee_id which will start from 1000 and increment by 18. Write SQL statement to delete dept_id 1 from Department table. Explain what happens whenyou attempt the SQL statement9. To enable delete of department with dept_id 1, you need to use the ON DELETE clause inForeign Key constraint. Refer to Oracle documentation for further guidance. Drop Foreign Keyconstraint and recreate with ON DELETE clause10. Now, delete department with dept_id 1. Explain what happens11. Modify table DEPARTMENT12 to add a column DIVISION that should be constrained to checkvalues in the range of 51 and 10012. Modify DEPARTMENT12 table to add constraint on dept_name to ensure that all recordsinserted will have dept_name in UPPERCASE. Review Oracle Documentation if needed13. Test the constraint14. Write a query to display all constraints for table EMPLOYEE12 and DEPARTMENT12

 

 

Reference no: EM13780826

Questions Cloud

Order quantity that minimizes total annual cost of inventory : The Central Hydraulic Supply Company is a distributor of hydraulic supplies in the Midwest. Central handles standard fittings, tubing, and similar items. Generally Central carries an entire product line for each manufacturer it represents providing l..
Order it by faculty last name in descending order : Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose offices are located in the 'LIB' building. Order it by faculty last name in descending order. This is in MySQL
Develop and prototype a new interface design : Your task is to develop and prototype a new interface design for the system’s function using Graphical User Interface. Include the same functions shown on page 361 plus possible messages during user interface such as error messages, confirmation, sta..
What skills does a non-legal person need as an employee : Consider how the world of business interacts with the legal realm. What skills does a non-legal person need as an employee? What legal training do you feel a businessperson needs in order to make good decisions? Please refer to U.S. Bureau of Labor S..
Create table department : Create table DEPARTMENT12 that includes columns dept_id and dept_name2. Create a table EMPLOYEE12 that includes the columns employee_id, FirstName , MiddleName,LastNarne, and social security number3. Modify the EMPLOYEE12 table to create a composite ..
Each activity contained a series of milestones : Each activity contained a series of milestones that represented a previously agreed-upon amount of work. Once the low graffiti was erased, 35% of the activity had been completed and once the mid-level graffiti was erased, 70% of the activity had been..
About critical chain methodology is best : Which statement about critical chain methodology is best?
Cost estimation-cost control for many project organization : How has the global economy affected the importance of cost estimation and cost control for many project organizations? Please be specific and offer examples. Feel free to use your own organization if possible.
What would be the direct cost of labor for an employee : Assume that overhead is charged on a flat rate basis. Each member of the project is assigned an overhead charge of $300/week. What would be the direct cost of labor for an employee, given that she is assigned to the project for 120 hours at $10.50?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Create a list with or more rows and topics

Can someone give me detailed instructions on how to do this step by step please? Create a list with 8 or more rows and 3 topics. After you have this done, separate this list by topic.

  What is the probability that the observed traffic in network

what is the probability that the observed traffic in the network will be classified at threat level ‘Medium'?

  Create two constructors

Create two constructors (default and initialization), accessor (get/set) methods, a printInfo method, a toString method, a method deposit that will increase the balance by a specified amount returning nothing.

  Convert the decimal integer

Convert the decimal integer -24 to 16 bit and 32 bit two's complement hexadecimal representation. show your calculations.

  Speculate on the primary concerns of deploying ad rms

Speculate on the primary concerns of deploying AD RMS in a corporate environment. Recommend a strategy that you might use to mitigate these types of concerns during the initial implementation of the AD RMS. Provide a rational for your recommendation.

  What would be the best choice of the degree

A B+ - tree index is to be built on the name attribute of the relation student

  Explaining use of information technologies to act ethically

When it comes to use of information technologies, it is frequently difficult to find out how to act ethically. Consider some of your own use of information technologies.

  Prepare a gantt chart or project plan

Create a Gantt chart or project plan to record tasks,subtasks, resources and identify the schedule of the project - update the Gantt chart or project plan. -

  Best and least expensive solution for faulty modem port

When troubleshooting a motherboard, you discover the modem port no longer works. What is the best and least expensive solution to this problem?

  How do you create a 3d array of doubles in c++

How do you create a 3D array of doubles in C++

  Write a program using a beginner c language

Write a program using a beginner C language which calculates the value of ? from the series ?=(4/1)-(4/3)+(4/5)-(4/7)+(4/9)-(4/11)+... Print a table that shows the value of ?

  What is the size of a char and a string

What are the sizes in memory of other data types in C++? I mean, I know that a double is 8 bytes and an int is 4 bytes. What is the size of a Char and a String?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd