Requirements : Let's say we need to design a Databse model for Fox Sports.
Considerations :
- Fox supoorts live TV.
- How we are going to store the sport programmes in database ?
- How we are going to store the timing of the programme ?
- How it will calcualte what's the next tv programme is scheduled ?
- What if a sport programme went over time, than all the other programmes needs to be shifted accordingly ?
- The Database should be highly available ?
- Should be use Cache for a faster response time for the fron end apps ?