Forum Discussion

zac_lim's avatar
zac_lim
New Member
9 years ago

Relationship between Channel Views and Programme

Hi guys,   This was an exercise given several days ago. I could not find a good way to solve the relationship between these two tables.     I would like to find information about the c...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Do u want create relationship between this two tables ?

 

if yes tell me the relationship

Channel to channel 

or 

Channel-Date to Channel-Date

zac_lim's avatar
zac_lim
New Member
9 years ago

> Do u want create relationship between this two tables ?

 

Yes, if possible.

 

> if yes tell me the relationship

 

Matching Channel views of 5 mins interval with the Programming Schedule. Each channel has many different programmes. Its not just the date but time as well, down to the minute. What you see here is just a snapshot. there are several thousand rows.

 

I need to find the Programme rankings. However the table only shows Channel Views at specfic time. I need it to somehow match the programming schedules so I can find the Programme rankings. It was an exercise introduced by a company I applied for. Maybe a relationship cannot be directly established and we may need to clean the table?

 

Thanks

 

Zac