Assume that, in addition to storing the grade a student has received in every course he has completed, the system stores the student’s cumulative GPA. Describe an integrity constraint that relates this information. Describe howthe constraint would be violated if the transaction that records a newgrade were not atomic.
What will be an ideal response?
The integrity constraint is that the GPA stored in the database is the GPA of the course grades stored. That constraint could be violated if a transaction updated a course grade and aborted before it could update the GPA.
You might also like to view...
Answer the following statements true (T) or false (F)
1. There are numerous DBMS's in use today, and Visual C# can interact with many of them. 2. Data stored in databases is organized into one or more tables. 3. Data stored in a database table is organized into rows and columns 4. Data stored in a database table’s column is divided into tables.
The Captions Group is found on the Reference tab
Indicate whether the statement is true or false
Which of the following is not true regarding clearing formats?
a. You can choose to clear the contents of a cell, the formatting of a cell, or both. b. Clearing the contents of a cell deletes the value or formula typed there, including the formatting applied to a cell. c. Deleting the contents does not delete the formatting of the cell. d. Clearing the date formatting from the cell displays the date's serial number.
Clicking the refresh button in the Media panel defines the current frame in the preview window as the current poster frame.
Answer the following statement true (T) or false (F)