Question: Stored PL/SQL Procedure Implement a stored PL/SQL procedure that insert into a database full information about an employee i.e., the values of the following attributes

Stored PL/SQL Procedure Implement a stored PL/SQL procedure that insert into a database full information about an employee i.e., the values of the following attributes E#, NAME, DOB, ADDRESS, HIREDATE, L#, STATUS, EXPERIENCE (only for mechanics). Your procedure should enforce a logical consistency constraint such that "the sets of drivers and mechanics must be disjoint". It means that it is not allowed to have in the tables MECHANIC and DRIVER the rows with the same employee number (E#) and/or the same driving license number (L#). Execute your procedure twice. The first execution should insert full information about a new employee. The second execution should fail due to the violation of logical consistency constraint given above.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres an example of how you can implement such a procedure CREATE OR REPLACE PROCEDURE insertemploye... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Can you please explain the code answers to me line by line with comments? I have the questions and answers but I am having trouble understanding everything that is going on. Thank you. This is in...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

) Explain the term overloading in the context of Java constructors and methods. [2 marks] (b) Without describing the details of either, outline the relationship between the Java methods...

Give condition for tracking down the most likely arrangement of grammatical feature (POS) labels that could be used by a stochastic POS tagger. You ought to accept a bigram model. [5 marks] (b) Given...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

web project Palestinian Best Food Store (PBFS), is an online food store that sales authenticated Palestinian Food, such as Zater, Olive Oil, Sage, ets. Also sales pre-packaged Palestinian meals such...

Johnson is asking the bank to extend the existing line of credit to 1 million to help with the cash flow during the seasonal demands of the business and for the expansion of the business The bank is...

A system is composed of four process, {P1, P2, P3, P4}, and three types of consumable resources, {R1, R2, R3}. There is one unit each of R1 and R3 available. a. P1 request one unit of R1 and one unit...

Explain the difference between an S corporation and a C corporation. ( Select all the choices that apply. ) A . S corporations are limited to 1 0 0 shareholders and cannot have corporate or foreign...

The following information was taken from the records of Chua Motorsports, Inc. at November 30, 2018: Prepare a multi-step income statement for Chua Motorsports for the fiscal year ended November 30,...

What is stagflation and why does cost-push inflation cause stagflation?

Multiple Choice Questions 1. When the Federal Reserve increases the money supply, it __________ aggregate demand and moves the economy along the Phillips curve to a point with __________ inflation...

Evaluating Four Alternative Inventory Methods Based on Income and Cash Flow At the end of January 2011, the records of Donner Company showed the following for a particular item that sold at $16 per...

A summary of data from Pinder Construction Supply Companys income statements and balance sheets for 2014 and 2013 follows. Total assets and owners equity at the beginning of 2013 were $1,360,000 and...

(a) Find the slope of the curve y=x23x3 at the point P(3,3) by finding the limiting value of the slope of the secant lines through point P.(b) Find an equation of the tangent line to the curve at...

Write SQL queries to answer the following questions: a. What are the names of the course(s) that student Altvater took during the semester 1-2015? b. List names of the students who have taken at...

Display employee information for all the employees in each state who were hired before the most recently hired person in that state.

List four objectives of derived data.

A manufacturing company buys a certain part in varying quantities throughout the year. Ordering cost is $ 11 per order, and holding cost is $0.14 per piece per month. Given the following demand (net...

Information concerning the product structure , lead times, end quantities on hand for an electric golf cert is shown in the following table. Use this information to do each of the following: a....

Refer to Problem 12. Assume drat unusually mild weather has caused a change in the quantity and timing of orders for golf carts. The revised plan calls for 100 golf carts at the start of week 6, 100...