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

A job order cost accounting system is fully integrated into the general ledger of a company. Identify the major general ledger accounts used in a job order cost system. Explain how manufacturing...

A single-tank process has been operating for a long period of time with the inlet how rate q1 equal to 30.4 ft3/min. After the operator increases the flow rate suddenly by 10%, the liquid level in...

Sales tax transactions Obj. 2 Journalize the entries to record the following selected transactions: a. Sold $640,000 of merchandise on account, subject to a sales tax of 7%. The cost of the goods...

=+Here is a diagram of that experiment. Fill in the parts. Section 20.5

The comparative balance sheet of Whitman Co. at December 31, 2016 and 2015, is as follows: The noncurrent asset, noncurrent liability, and stockholders' equity accounts for 2016 are as follows: Dec....

2) Suppose that the price of a non-dividend-paying stock is $42, its volatility is 25%, and the risk-free rate for all maturities is 6% per annum. Provide a table showing the relationship between...

The accounting firm of Coopers & Andersen is conducting a benchmarking survey to assess the satisfaction level of its clients versus clients served by competing accounting firms. The clients are...

Accounting. 1. The adjusted account balances of Fitness Centre at July 31 are as follows: Accounts Account Balances Accounts Account Bal Cash $ 11,000 Service Revenue $105,000 Accounts Receivable...

Write a 175- to 350-word email that you could send to classmates informing them of the important points of the NHA exam and how to plan to sit for the exam. Address the following in your email: What...

10. According to the Harvard Business Review article "The Secrets of Great Teamwork," which one of the following is true? (5 Points) A compelling mission statement and vision are more important than...

Explain the basic tradeoff a state makes when it tightens regulations on licenses for physicians, pharmacists, or any other professionals. What are the costs and benefits?

Starting from your project idea, generate the complete structure of the Technical Title Project document, developing the "Preliminary or presentation section", corresponding to the contents of unit...

4.49 Mr. Williams deposits $200 in the bank at the end of each quarter. If the bank pays 6% per year. compounded quarterly. how much money will Mr. Williams have accumulated at the end of 12 years?...

Having a hard time with the Post Closing Trial Balance which ones are and how would I place them inside my general ledger Rocky Ram, Inc. Post Closing Trial Balance December 31, 2020 Acct# Account...

A simple random sample of 220 university students were asked what pasta they usually order and with which sauce. The preferences of these respondents are summarised below: Sauce Bolognese Pasta...

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