Suppose that each of the following Update operations is applied directly to the database state shown in Figure 3.6. Discuss all integrity constraints vio- lated by each operation, if any, and the different ways of enforcing these con- straints. a. Insert <'Robert, 'F, 'Scott', '943775543, '1972-06-213 '2365 Newcastle Rd, Bellaire, TX, M, 58000, '888665555, l> into EMPLOYEE. b. Insert <'ProductA, 4, 'Bellaire, 2> into PROJECT. c. Insert <'Production', 4, '943775543, '2007-10-01’> into DEPARTMENT. d. Insert <'677678989', NULL, '40.0'> into WORKS_ON. e. Insert <'453453453, 'John, 'M, '1990-12-12, 'spouse'> into DEPENDENT. f. Delete the WORKS_ON tuples with Essn = '333445555? g. Delete the EMPLOYEE tuple with Ssn = '987654321?. %3D h. Delete the PROJECT tuple with Pname = 'ProductX. i. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to ʻ123456789' and '2007-10-01', respectively. j. Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn = '999887777’ to '943775543' k. Modify the Hours attribute of the WORKS_ON tuple with Essn = '999887777’ and Pno = 10 to '5.0.

Suppose that each of the following Update operations is applied directly to the database state shown in Figure 3.6. Discuss all integrity constraints vio- lated by each operation, if any, and the different ways of enforcing these con- straints. a. Insert <'Robert, 'F, 'Scott', '943775543, '1972-06-213 '2365 Newcastle Rd, Bellaire, TX, M, 58000, '888665555, l> into EMPLOYEE. b. Insert <'ProductA, 4, 'Bellaire, 2> into PROJECT. c. Insert <'Production', 4, '943775543, '2007-10-01’> into DEPARTMENT. d. Insert <'677678989', NULL, '40.0'> into WORKS_ON. e. Insert <'453453453, 'John, 'M, '1990-12-12, 'spouse'> into DEPENDENT. f. Delete the WORKS_ON tuples with Essn = '333445555? g. Delete the EMPLOYEE tuple with Ssn = '987654321?. %3D h. Delete the PROJECT tuple with Pname = 'ProductX. i. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to ʻ123456789' and '2007-10-01', respectively. j. Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn = '999887777’ to '943775543' k. Modify the Hours attribute of the WORKS_ON tuple with Essn = '999887777’ and Pno = 10 to '5.0.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

We think other solution in bartleby is wrong so be carefull please. A database must store an employee table consisting of 100000records each of which is 80byteslong. Answer the following questions by assuming these congurations/parameters: B = 512bytes,interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace =400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads),rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, andbtt = 0.03255ms. 1. How many records can be stored per block (blocking factor) using spanned and unspannedcongurations?2. What is the utilization (%) for the unspanned conguration?3. If the le is physically ordered, what is the average time in milli second to read a record ineach conguration?
Design a direct file organization using a hash function, to store an item file withitem number as its primary key. The primary keys of a sample set of records ofthe item file are listed below. Assume that the buckets can hold two records eachand the blocks in the primary storage area can accommodate a maximum of fourrecords each. Make use of the hash function h(k) = k mod 8, where k represents thenumerical value of the primary key (item number).369 760 692 871 659 975 981 115 620 208 821 111 554 781 181 965
(Q.17) Consider this functional dependencies {AB->C, BC->D, CD->E, E->F} Which of the following functional dependencies is/ are member of the given FD set? A) AB->F B) BC->A C) BC->E D) DEF->C Only the correct answer will be liked
Imagine for a minute that a financial institution's database is safeguarded by a technique known as snapshot isolation database.Do you offer an example of how a nonserializable execution may be detrimental to the bank? Please share it if so.
5. Let a database contain initial values x=3, y=6, z=9 Suppose the logging-and-recovery scheme uses deferred update, the log can contain only the after-image values, that is, log records for write_item operations have only a single value. The new value of database element written. let the log contain the sequence of records:[Checkpoint][start_transaction, T1][write_item, T1,x,6][write_item, T1,y,9][commit, T1][start_transaction, T2][write_item, T2,x,9][start_transaction, T3][write_item, T3,y,12][write_item, T3,z,12][commit, T3][write_item, T2,y,3]Determine all the possible values of data items x, y, and z that might be written on disk during the execution of the above log operations. a) x=6, y=6, z=9 b) x=9, y=9, z=9 c) x=9, y=9, z=12 d) x=9, y=12, z=9 which one ?
Suppose for a second that a technique known as snapshot isolation database is being used in order to provide security for the database of a financial institution.Do you have an example that explains how a nonserializable execution might be detrimental to the bank? If so, please share it with me. If so, please spread the word.
Assume a bank's database is protected using snapshot isolation database technology. Do you provide any examples of how a nonserializable execution may be detrimental to the bank?
A database has 4 transactions, shown below.TID Date items_boughtT100 10/15/04 {K, A, D, B}T200 10/15/04 {D, A, C, E, B}T300 10/19/04 {C, A, B, E}T400 10/22/04 {B, A, D}Assuming a minimum level of support min_sup = 60% and a minimum level ofconfidencemin_conf = 80%:(a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate and acceptable frequent itemsets. You should show your work similar to the way the example was done in thePowerPoint slides.(b)List all of the strong association rules, along with their support and confidence values, whichmatch the following metarule, where X is a variable representing customers and itemi denotes variables representing items (e.g., “A”, “B”, etc.).x  transaction, buys(X, item1)  buys(X, item2)  buys(X, item3)Hint: don’t worry about the fact that the statement above uses relations. The point of the…
Design a direct file organization using a hash function, to store an item file with item number as its primary key. The primary keys of a sample set of records of the item file are listed below. Assume that the buckets can hold two records each and the blocks in the primary storage area can accommodate a maximum of four records each. Make use of the hash function h(k) = k mod 8, where k represents the numerical value of the primary key (item number).369 760 692 871 659 975 981 115 620 208 821 111 554 781 181 965 don't copy bartleby old answer its wrong
Design a direct file organization using a hash function, to store an item file with item number as its primary key. The primary keys of a sample set of records of the item file are listed below. Assume that the buckets can hold two records each and the blocks in the primary storage area can accommodate a maximum of four records each. Make use of the hash function h(k) = k mod 8, where k represents the numerical value of the primary key (item number).369 760 692 871 659 975 981 115 620 208 821 111 554 781 181 965
Transaction T1 has the following distribution over database objects A and B: R(A), W(A), R(B), W(B)Give an example of a transaction T2 that, run in parallel with transaction T1, could lead to a conflict.Assume we don't have any concurrency control.
For the purpose of argument, let us imagine that an airline has a database that employs a technique known as "snapshot isolation." Airline could agree to a non-serializable execution if it results in better overall performance.