Mm Jhscajn Task Transaction Management And Concurrency Control Database Performance Tuning And Query Optimization 1 1 (72.12 KiB) Viewed 82 times
mm.jhscajn Task : Transaction Management and Concurrency Control& Database Performance Tuning and Query Optimization 1) Suppose you have the following table: Class Code Enroll Grade 10014 C 10014 B Table Enroll STU NUM 321452 424257 321452 424257 321452 424257 10018 A 10018 B 10021 C 10021 C and you need to update the grades of three students in three courses as shown in the previous table. a) How many database requests can you identify for the grades update? b) Write the complete transaction(s). c) Write the transaction log, using the following Table 2 as your template. ROW TRL ID 1 TRX PREV NEXT NUM PTR PTR 1A3 NULL 2 BEFORE VALUE AFTER VALUE ID ATTRIBUTE OPERATION START TABLE **START TRANSACTION 1
mm.jhscajn 2) Based on the following query: SELECT STU NUM, STU LNAME, STU FNAME, STU ADRESS FROM STUDENT WHERE STU LNAME='SULAIMAN AND STU FNAME='IBRAHIM ORDER BY STU NUM; a) What is the likely data sparsity of the STU_FNAME column? b) What indexes should you create? Write the required SQL commands. 2
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!