Give an example of a dataset that would help catch this part

Assignment Help Basic Computer Science
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.

Reference no: EM131057991

Locate vendors of biometric products

Using the Web, locate vendors of biometric products. Find one vendor with a product designed to examine each characteristic mentioned in your textbook. What is the CER ass

What would the minimum payment be

The term of the loan is 60 months and an interest rate of 4%. What would the minimum payment be? Assuming he makes the minimum payments, how much would he pay at the end of

What are the estimates of the sizes of each neighborhood

Using this hash function, compute the values of R for each node and radius 1. What are the estimates of the sizes of each neighborhood? How do the estimates compare with rea

Company annual report on the internet

Select one of the two companies you identified above. Locate the company's annual report on the Internet. What is the company''s mission statement or overriding objective?

Splits the word into a unicode character array

These tasks entail developing a single program that contains methods of the following tasks. Your program may run either on the command-line or as an applet. Write methods t

Determine whether the constant was too conservative

Given the operating pressure of the system and your understanding of convective boiling heat transfer, determine whether the constant was too conservative. If it was, refine

Explaining network attacker steal secure google cookies

Explain how a network attacker (an active attacker that can intercept or forge network packets, etc.) could steal secure google.com cookies.

What is the response time for jobs in observed system

We observe a closed system for 30 minutes, during which 1600 tasks are completed, from 12 terminals. Each terminal (source of tasks). What is the response time for jobs in th

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd