2 votes 2 votes The number of concurrent schedules can be formed with 3 transactions having 3, 2 and 1 operations respectively _________ I am getting 54 but the given ans is 60. My doubt is are serial schedules counted or not in the concurrent schedules. Databases made-easy-test-series databases transaction-and-concurrency + – shivangi5 asked Nov 24, 2017 edited Mar 3, 2019 by adeebafatima1 shivangi5 655 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
5 votes 5 votes yes 60 is correct answer... total concurrent schedules possible here are (3+2+1)! / (3!*2!*1!)......that is 6!/(6*2*1)....that is 60... SO 60 ARE ALL POSSIBLE CONCURRENT SCHEDULES ..WHICH ARE BOTH (SERIAL+NON-SERIAL....) for any schedule with n transaction ...WE HAVE N! serial schedules ...so here 3!=6... so you are correct but they have asked total concurrent schedules ....so answer is 60 .... only NON-SERIAL concurrent schedules are 60-6 = 54..... SO 54 will be answer if we exclude serial schedules... SHUBHAM SHASTRI answered Nov 24, 2017 SHUBHAM SHASTRI comment Share Follow See all 0 reply Please log in or register to add a comment.