Real-Time Hospital Resource Allocation Optimizer

Create a dynamic SQL solution for real-time hospital bed and resource management. Design a set of interconnected stored procedures that: 1) Track current patient occupancy across departments, 2) Predict patient discharge probabilities, 3) Recommend optimal resource reallocation based on current and projected demand, and 4) Generate automated alerts for potential bottlenecks. Include sophisticated time-series analysis and implement concurrent transaction management to ensure data consistency.