Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows:
Question:
CONSTRAINT EMPSUPERFK
FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN)
ON DELETE CASCADE ON UPDATE CASCADE,
Answer the following questions:
a. What happens when the following command is run on the database state shown in Figure 5.6? DELETE EMPLOYEE WHERE LNAME = 'Borg'
b. Is it better to CASCADE or SET NULL in case of EMPSUPERFK constraint ON DELETE?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 42% (7 reviews)
a The James E Borg entry is deleted from the table and each employee with ...View the full answer
Answered By
Hassan Imtiaz
The following are details of my Professional Experience. Responsibilities Eight years of demanding teaching experience in the field of finance and business studies at Master’s Level. Completion of the given tasks within given time with quality and efficiency. Marketing professional with practical experience in and solid understanding of a diverse range of management applications, including market analysis, sales and marketing, team building and quality assurance. I have excellent skills to approach deal and sustain corporate clients / customers by demonstrating not only extraordinary communication and interpersonal skills but also high caliber presentation, negotiation and closing skills. Manage and follow up the day-to-day activities. Manage and co-ordinate the inventories. Fulfillment of all the tasks assigned.
The following are details of my Areas of Effectiveness. Finance 1. Corporate Finance 2. Advanced Corporate Finance 3. Management of Financial Institutions 4. International Financial Management 5. Investments 6. Fixed Income 7. Real Estate Investment 8. Entrepreneurial Finance 9. Derivatives 10. Alternative Investments 11. Portfolio Management 12. Financial Statement Analysis And Reporting (US GAAP & IFRS) 13. International Financial Markets 14. Public Finance 15. Personal finance 16. Real estate 17. Financial Planning Quantitative Analysis 1. Time Value Of Money 2. Statistics 3. Probability Distribution 4. Business Statistics 5. Statistical Theory and Methods Economics 1. Principles of Economics 2. Economic Theory 3. Microeconomic Principles 4. Macroeconomic Principles 5. International Monetary Economics 6. Money and Banking 7. Financial Economics 8. Population Economics 9. Behavioral Economics International Business 1. Ethics 2. Business Ethics 3. An introduction to business studies 4. Organization & Management 5. Legal Environment of Business 6. Information Systems in Organizations 7. Operations Management 8. Global Business Policies 9. Industrial Organization 10. Business Strategy 11. Information Management and Technology 12. Company Structure and Organizational Management Accounting & Auditing 1. Financial Accounting 2. Managerial Accounting 3. Accounting for strategy implementation 4. Financial accounting 5. Introduction to bookkeeping and accounting Marketing 1. Marketing Management 2. Professional Development Strategies 3. Business Communications 4. Business planning 5. Commerce & Technology Human resource management 1. General Management 2. Conflict management 3. Leadership 4. Organizational Leadership 5. Supply Chain Management 6. Law 7. Corporate Strategy Creative Writing 1. Analytical Reading & Writing Other Expertise 1. Risk Management 2. Entrepreneurship 3. Management science 4. Organizational behavior 5. Project management 6. Financial Analysis, Research & Companies Valuation 7. And any kind of Excel Queries
4.80+
150+ Reviews
230+ Question Solved
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted:
Students also viewed these Computer Sciences questions
-
Consider the following relational schema and briefly answer the questions that follow: 1. Define a table constraint on Emp that will ensure that every employee makes at least $10,000. 2. Define a...
-
Consider the following BCNF schema for a portion of a simple corporate database (type information is not relevant to this question and is omitted): Emp (eid, ename, addr, sal, age, yrs, deptid) Dept...
-
Use the following description of the operations of the RC_Charter2 Company to complete this exercise. ¢ The RC_Charter2 Company operates a fleet of aircraft under the Federal Air Regulations...
-
1) The following information relates to the ABCs depreciable assets. Class 1 - During 2020, a new office building was acquired at a total cost of $623,000. Of this total, it is estimated that the...
-
Use the following table to answer the questions listed below. Total Output Cost TFC TVC AFC AVC ATC MC 0 $20 10 $ 40 20 $ 60 30 $ 90 40 $120 50 $180 60 $280 a. Calculate the total fixed costs, total...
-
Use random numbers to simulate tossing a coin 100 times. Let 0 represent heads, and let 1 represent tails. How many times did you obtain each number? Are the results what you expected?
-
If the assembly fits snugly between the two supports A and C when the temperature is T 1 , determine the normal stress developed in both segments when the temperature rises to T 2 . Both segments are...
-
1. How should the management team at Bally Hoo make an informed judgment about the future demand for retro clothing styles? 2. What is your evaluation of the creative thinking of Julia? 3. If you...
-
A 200 mm reinforced concrete wall carries a dead load of 140 kN/m including self-weight and a live load of 60 kN/m. It is to be carried by 500 mm thick footing with its bottom 1.5 m below NGL. Soil...
-
1. Is anything unique about Chriss idea? Explain. 2. What is the first thing he should do to follow up on his idea? Explain. 3. When this is done, what else should Chris do? Outline a general course...
-
Write SQL update statements to do the following on the database schema shown in Figure 1.2. (a) Insert a new student in the database. (b) Change the class of student 'Smith' to 2. (c) Insert a new...
-
Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results if applied to the database of Figure 3.6. (a) For each department whose average employee salary...
-
What are the primary characteristics of residential mortgage loans? Why does the ratio of adjustable-rate mortgages to fixed-rate mortgages in the economy vary over an interest rate cycle? When would...
-
In December 1994, the government of Mexico officially changed the value of the Mexican peso from 3.16 pesos per dollar to 5.52 pesos per dollar. What was the percentage change in its value? Was this...
-
1. Complete the following chart. (16 Marks) Situation Inflation is running at the high rate of 12 percent and is rising. Business investment is falling rapidly and inventories are piling up. Business...
-
Travels 20.3km to and from work for a 5 day work week, with 4 weeks per month. The cost is $1.45 CAD per gallon. Car average 25 miles per gallon. figure his monthly gas expense
-
A customer borrowed $1000, and must make 3 payments of $500 each to repay the loan. How much interest will they have paid on top of the amount they borrowed? Type your answer:
-
find all pair of positive integral a and b with a smaller than b such that a 2 + b 2 = 1 4 5 . use gaussian integers
-
On January 1, 2021, Samantha Clark Corp. established a cash-settled stock appreciation rights plan for its executives, the details of which are listed below: 100,000 stock appreciation rights (SARs)...
-
On October 31 Juanita Ortega, owner of Outback Guide Service, received a bank statement dated October 30. Juanita found the following: 1. The checkbook has a balance of $2,551.34. 2. The bank...
-
Consider the EER design for the ONLINE_AUCTION database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.29. Using the SQL schema generation feature of the modeling...
-
Consider the EER design for the GRADE_BOOK database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.28. Using the SQL schema generation feature of the modeling...
-
Consider the ER design for the MAIL_ORDER database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 3.32. Using the SQL schema generation feature of the modeling tool,...
-
Melissa Cutt is thinking about buying some shares of EZLawn Equipment, at $36.44 per share. She expects the price of the stock to rise to $43.62 over the next 3 years. During that time she also...
-
At the beginning of the week, Taylan's restaurant had a beginning inventory of food and beverages totaling $4,000. During the week, additional food and beverages purchases totaled $3,000. At the end...
-
1. Identify the auditor's role in the internal and external auditing processes. 2. Identify one law, regulation, and statue affecting healthcare
Study smarter with the SolutionInn App