Concept explainers
Explanation of Solution
Stale:
The stale means that the value of an item dependent on other data and the same item is not updated when another data is changed.
Example:
Consider an example of stale which is given below:
//class definition
Class Test
//fields declaration
Private Real parts
Private Real labor
//definition of constructor
Public Module Test (Real p, Real l)
//set the values
Set parts = p
Set labor = l
//end the module
End Module
//definition of matator
Public Module setParts (Real p)
//set the value
Set parts = p
//end the module
End Module
//definition of matator
Public Module setLabor (Real l)
//set the value
Set labor = l
//end the module
End Module
//definition of accessor
Public Function Real getParts ()
//return the value
Return parts
//end the function
End Function
//definition of accessor
Public Function Real getLabor ()
//return the ...
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Starting Out with Programming Logic and Design (4th Edition)
- A(n) _____ is a request for specific information from a database.arrow_forwardWhat method of Statement is used if you want to execute DELETE SQL statement?arrow_forwardChapter 16 How to manage transactions and locking Excercises using the My Guitar Shop Database Use Microsoft SQL Server Write a script that includes two SQL statements coded as a transaction to delete the row with a customer ID of 8 from the Customers table. To do this, you must first delete all addresses for that customer from the Addresses table. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.arrow_forward
- External data is typically excluded from a Data Strategy. A. True B. Falsearrow_forwardRange controls and null value controls may improve or hinder data integrity.arrow_forwardIn user-defined records, the first step that you need to do is to define or declare the type and variable of that type. a.true b.falsearrow_forward
- What's the connection between keys and data types?arrow_forwardUSE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.arrow_forwardA(n)______________is a collection of data fields that are all related to the same object, activity, or individual. a. attribute b. byte c. record d. columnarrow_forward
- Executing an UPDATE statement will return______. the number of records updated the set of records updated the identifiers of updated records NULLarrow_forwardThe process of connecting an object in a dataset to a control is called________ .arrow_forwardThe key to sellotape method of data entry has the primary advantage that the sellotape may be used more than once.arrow_forward
- Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning