Reference no: EM131057991
Testing SQL queries: To test if a query specified in English has been correctly written in SQL, the SQL query is typically executed on multiple test databases, and a human checks if the SQL query result on each test database matches the intention of the specification in English.
a. In Section 3.3.3 we saw an example of an erroneous SQL query which was intended to find which courses had been taught by each instructor; the query computed the natural join of instructor, teaches, and course, and as a result unintentionally equated the dept name attribute of instructor and course. Give an example of a dataset that would help catch this particular error.
b. When creating test databases, it is important to create tuples in referenced relations that do not have any matching tuple in the referencing relation, for each foreign key. Explain why, using an example query on the university database.
c. When creating test databases, it is important to create tuples with null values for foreign key attributes, provided the attribute is nullable (SQL allows foreign key attributes to take on null values, as long as they are not part of the primary key, and have not been declared as not null) Explain why, using an example query on the university database.
Hint: use the queries from Exercise 4.1.
|
Advantages and disadvantages of autocratic leadership
: What are the advantages and disadvantages of autocratic leadership? Cite an example from your own experience that describes autocratic leadership.
|
|
Which will be depreciated straight-line to zero book value
: $2.46 million which will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will ..
|
|
Assumption of risk or contributory negligence
: Assume that the jurisdiction does not recognize assumption of risk or contributory negligence. The jurisdiction does recognize the defense of comparative negligence.
|
|
How to calculate the cost of good sold and the gross profit
: Kokomochi plans to spend $5 million on advertising compaign this year. The ads are expected to boost sales of the Mini Mochi Munch by $12 million this year and by $8 million next year. Calculate the incremental earnings associated with the advertisin..
|
|
Give an example of a dataset that would help catch this part
: When creating test databases, it is important to create tuples in referenced relations that do not have any matching tuple in the referencing relation, for each foreign key. Explain why, using an example query on the university database.
|
|
Taxes per year in order processing costs
: Your firm is contemplating the purchase of a new $630,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $70,000 at the end of that time. You will save $260,000 before..
|
|
Articulating your business problem statement
: In the beginning of a design for study, a qualitative researcher should start by introducing a business problem statement. The objective of this statement is to provide the motivation for studying a particular area of interest. A business problem ..
|
|
Selecting a software vendor
: Name at least five important factors to be considered in selecting a software vendor. For each factor, explain why it should be considered and potential consequences of not considering the factor in selection of a software vendor.
|
|
What is the company equity value and value per share
: You are valuing a technology company whose enterprise value is $800 million. The company has no debt, but considerable employee options (10 million in total). Based on option pricing models, you value the options at $6.67 per option. If the company h..
|