Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id :...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id : integer, dept_id: integer, basic: integer, deductions: integer, additions: integer, DOJ: date) payroll(emp_id: integer, pay_date: date) For the above schema, perform the following- a) Create the tables with the appropriate integrity constraints Insert around 10 records in each of the tables List the employee details department wise List all the employee names who joined after particular b) c) d) date e) List the details of employees whose basic salary is between 10,000 and 20,000 f) Give a count of how many employees are working in each department g) h) i) Give a names of the employees whose netsalary> 10,000 List the details for an employee_id=5 Create a view which lists out the emp_name, department, basic, dedeuctions, netsalary j) Create a view which lists the emp_name and his netsalary Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id : integer, dept_id: integer, basic: integer, deductions: integer, additions: integer, DOJ: date) payroll(emp_id: integer, pay_date: date) For the above schema, perform the following- a) Create the tables with the appropriate integrity constraints Insert around 10 records in each of the tables List the employee details department wise List all the employee names who joined after particular b) c) d) date e) List the details of employees whose basic salary is between 10,000 and 20,000 f) Give a count of how many employees are working in each department g) h) i) Give a names of the employees whose netsalary> 10,000 List the details for an employee_id=5 Create a view which lists out the emp_name, department, basic, dedeuctions, netsalary j) Create a view which lists the emp_name and his netsalary
Expert Answer:
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date:
Students also viewed these programming questions
-
1. Draw direction vectors in unit cells for the following cubic directions: [ITT] (6) LI TO] [T3] (a) (d) Example : [T3] (d) 7 Dividing by 3, y=-%
-
Write a C++ prgram for the following question For a given K value ( K > 0) reverse blocks of K nodes in a single linked list. Example: Input: 1 2 3 4 5 6 7 8 9 10. Output for different K values:...
-
a. Establish response categories and codes for the following question that was asked of a sample of business executives: "In your opinion, which types of companies have not been affected by the...
-
International Microcircuits, Inc. Megan Bedding, vice-president of sales for International Microcircuits, Inc. (IM), was delighted when IM was one of the few firms invited to enter a bid to supply a...
-
Explain the concept of maximum sustainable yield for a fishery. Is maximum sustainable yield required to preserve biodiversity? Is it the most efficient rate of harvest for a renewable natural...
-
Figure P.10.30 is a computer-generated Fraunhofer irradiance distribution. Describe the aperture that would give rise to such a pattern and give your reasoning in detail. Figure P.10.30
-
When to use a settlement brochure?
-
Lohn Corporation is expected to pay the following dividends over the next four years: $10, $7, $6, and $2.75. Afterwards, the company pledges to maintain a constant 5 percent growth rate in dividends...
-
The following data were included in a recent Zhu and Ramos Incorporated annual report (in millions) Net revenue Net property, plant, and equipment Required: 2915 $ 167,500 15,510 2916 $ 167,910 2917...
-
Ryan Ross (111-11-1112), Oscar Omega (222-22-2222), Clark Carey (333-33-3333), and Kim Kardigan (444-44-4444) are equal active members in ROCK the Ages LLC. ROCK serves as agent and manager for...
-
Flight Caf prepares in-flight meals for airlines in its kitchen located next to a local airport. The company's planning budget for July appears below: Flight Caf Planning Budget For the Month Ended...
-
what differentiates a glycerophospholipid from a triacylycerol?
-
How do contemporary theories of social stratification explain the persistence of class hierarchies, and what mechanisms contribute to social mobility or the lack thereof in modern societies ?
-
The impact of social and digital media on marketing communications cannot be underestimated. Marketing executives and marketing managers are expected to develop strategies and craft campaigns that...
-
Please draft a short Diversity, Equity, Inclusion, and Access: (A.) Public Statement and (B.) Corporate policy to address the issues above. You may use internet search engines to gain ideas. Public...
-
Identify any upcoming or potential policy changes within an electrical company that will have an impact on the people that they serve. This change could be putting a policy into action or making...
-
thetable below gives the power consumption P in meqawatts in a countyfrom midnight to 6:00 a.m. on a day in December. Use Simpson's ruleto estimate the energy used during that time period. (Use the...
-
Find the numerical value of each expression. (a) sech 0 (b) cosh -1 1
-
Explain the statement that relational algebra operators can be composed. Why is the ability to compose operators important?
-
Why would you choose a database system instead of simply storing data in operating system files? When would it make sense not to use a database system?
-
The description in Section 18.6.1 of the Analysis phase made the simplifying assumption that no log records appeared between the begin checkpoint and end checkpoint records for the most recent...
-
Ten students are chosen from a statistics class of 25 students. Let X be the number who got an A in the class. In Exercises 1116, determine whether the random variable X has a binomial distribution....
-
In a college with 5000 students, 100 are randomly chosen to complete a survey in which they rate the quality of the cafeteria food. Let X be the number of freshmen who are chosen. Does X have a...
-
= 0.1, t = 10, P(2) In Exercises 918, determine the indicated probability for a Poisson random variable with the given values of and t.
Study smarter with the SolutionInn App