Calculating Start and End Dates From Predecessors in SQL

SQL I have the following data in which I have duration and predecessors for my activities. Now I want to calculate the start and end date of activities with reference to their predecessors. The data is sampled below. Also please note there might be activities which may not have predecessors so their start date should be @startDate and end date should be calculated from their duration and sundays should be excluded.

Sample Data

https://i.imgur.com/JWTEO59.png

Required Data

https://i.imgur.com/6mbtTzo.png

Please provide me the solution asap.

Thanks.