HELP : How to Design a database model of a TV channel which supports Live Tv ?

Requirements : Let's say we need to design a Databse model for Fox Sports.
Considerations :

  1. Fox supoorts live TV.
  2. How we are going to store the sport programmes in database ?
  3. How we are going to store the timing of the programme ?
  4. How it will calcualte what's the next tv programme is scheduled ?
  5. What if a sport programme went over time, than all the other programmes needs to be shifted accordingly ?
  6. The Database should be highly available ?
  7. Should be use Cache for a faster response time for the fron end apps ?
Comments (3)