Consider the insurance database of Figure, where the primary keys are underlined. Construct the following QBE queries
Question:
Consider the insurance database of Figure, where the primary keys are underlined. Construct the following QBE queries for this relational-database.
a. Find the total number of people who owned cars that were involved in accidents in 1989.
b. Find the number of accidents in which the cars belonging to ?John Smith? were involved.
c. Add a new accident to the database; assume any values for required attributes.
d. Delete the Mazda belonging to ?John Smith.?
e. Update the damage amount for the car with license number ?AABB2000? in the accident with report number ?AR2197? to $3000.
Transcribed Image Text:
person (driver-id, name, address) car (license, model, year) accident (report-number, date, location) owns (driver-id, license) participated (driver-id, car, report-number, damage-amount)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 72% (18 reviews)
a Find the total number of people who owned cars that were involved in ac cidents in 1989 participat...View the full answer
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
4.40+
65+ Reviews
86+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer Sciences questions
-
Consider the relational database of Figure where the primary keys are underlined. Give expressions in QBE for each of the following queries: a. Find all employees who earn more than the average...
-
Consider the AIRLINE relational database schema shown in Figure 3.8, which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or...
-
Cars A and B are d = 60 m apart and are traveling respectively at the constant speeds of (vA)0 = 32 km/h and (vB)0 = 24 km/h on an icecovered road. Knowing that 45 s after driver A applies his brakes...
-
(1.71, 2.05) Use the confidence interval to find the margin of error and the sample mean.
-
The Ohio State Fair is one of the largest state fairs in the United States. It draws nearly one million visitors over the twelve-day period each July and August. The fair is a nonprofit organization....
-
Sk8 Company produces skateboards and purchases 20,000 units of a wheel bearing each year at a cost of $1 per unit. Sk8 requires a 15% annual rate of return on investment. In addition, the relevant...
-
How might the attributes of a highly motivated employee change for different job descriptions?
-
Listed below are several transactions. For each transaction, indicate by letter whether the cash effect of each transaction is reported in a statement of cash flows as an operating (O), investing...
-
1. Graph the functions: a. y = 2x (= b. y =
-
A researcher wishes to compare the height (cm) of four plant varieties within a greenhouse. The greenhouse has six benches and each bench can accommodate 4 pots. The sunlight streaming in the...
-
Describe the circumstances in which you would choose to use embedded SQL rather than SQL alone or only a general-purpose programming language.
-
Consider the employee database of Figure. Give expressions in QBE, and Datalog for each of the following queries: a. Find the names of all employees who work for First Bank Corporation. b. Find the...
-
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them...
-
we will derive the Maxwell-Boltzmann speed distribution P(v) for molecules with m my mass m at temperature T, P(v) = 4, v exp where kB is Boltzmann's 2kBT 2kBT 00 constant. Show explicitly that this...
-
Question 4. Construct the phasediagram for the economy. Provide an infor- mal argument that there is only one trajectory for consumption and capital that the economy can take which is consistent with...
-
1. An investor creates a trading position using a long position in a "strangle" and a short position in a "straddle. The strangle is created by a long call with strike $60 and a long put with strike...
-
Question 5. Derive the real rate of interest, output per capita and the savings rate () in the steady state. Comment on how the depreciation rate affect the three outcomes; compare with the...
-
Ronald is an Economics students who likes to spend his leisure time of sixty hours a month doing one of two activities: watching movies at Dendy Cinemas Newtown (x), and indoor-climbing (y). A trip...
-
Talk to students at your school who are interviewing for jobs this term. Possible questions to ask them include the following: What field are you in? How good is the job market in that field this...
-
If the amplifier indicated by the box input impedance of oo, which of the following statements are true ? has an open loop gain as well as Feedback factor (\beta = 1/ R_1\) The feedback is voltage...
-
A plant is removing a trace of Cl2 from a waste-gas stream by passing it over a solid granulm absorbent in a tubular packed bed (Figure P14-8B). At present, 63.2% removal is being acomplished, but it...
-
In write-optimized trees such as the LSM tree or the stepped-merge index, entries in one level are merged into the next level only when the level is full. Suggest how this policy can be changed to...
-
Consider the instructor relation shown in Figure 14.1. a. Construct a bitmap index on the attribute salary, dividing salary values into four ranges: below 50,000, 50,000 to below 60,000, 60,000 to...
-
Suppose you are given a database schema and some queries that are executed frequently. How would you use the above information to decide what indices to create?
-
Estimate the final temperature in Celsius of the combination if I drop 5 rolls of pennies at 2 0 C ( each roll is 5 0 pennies stacked together; assume they are pure copper ) into a cup of recently -...
-
A 100 gram mass is hung of then end of a cantilever beam . The beam is made of brass, and is 30 cm long (), 2 cm wide, and 3 mm thick. Find the resulting deflection ()
-
The nitrogen-vacancy (NV) and silicon-vacancy (SiV) defects in diamond can lead to many exciting quantum nanotechnologies in physical and biological sciences, including single-photon sensors,...
Study smarter with the SolutionInn App