Jerry,
I would expect you need tables like:
tblSongs (one record for each copyrighted song)
===================================
sonSonID autonumber primary key
tblCharts (one record for each different chart)
=====================================
chtChtID autonumber primary key
tblChartSongs (junction table between songs and charts)
==================
chsChSID autonumber primary key
chsSonID link to tblSongs.sonSonID
chsChtID link to tblCharts.chtChtID
chsDate the first day of the month, could use chsYear and chsMonth fields if desired
chsRanking the position on the chart
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 11:01:30 -0400
Subject: [MS_AccessPros] Re: Monthly Chart Tables ?
Thank you Duane. The charts will be monthly covering over a decade and yes, there could be multiple genres and not just a single chart. --Jerry
Jerry,
Not separate tables! I don't know much about song charting in terms of granularity. Are charts/rankings posted only monthly or weekly or other? Are there multiple charts?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 21 Apr 2015 11:47:18 -0400
Subject: [MS_AccessPros] Monthly Chart Tables ?
I'm working on a database for a publishing company
to show their copyrighted songs that charted over a period of
years. I'm trying to wrap my brain around the best way to show
that the same song charted for multiple months. Is it best to
create a date field that will be able to isolate everything in
queries, or would it be better to have separate tables for each
month, probably not?
Thanks,
I would expect you need tables like:
tblSongs (one record for each copyrighted song)
===================================
sonSonID autonumber primary key
tblCharts (one record for each different chart)
=====================================
chtChtID autonumber primary key
tblChartSongs (junction table between songs and charts)
==================
chsChSID autonumber primary key
chsSonID link to tblSongs.sonSonID
chsChtID link to tblCharts.chtChtID
chsDate the first day of the month, could use chsYear and chsMonth fields if desired
chsRanking the position on the chart
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Apr 2015 11:01:30 -0400
Subject: [MS_AccessPros] Re: Monthly Chart Tables ?
Thank you Duane. The charts will be monthly covering over a decade and yes, there could be multiple genres and not just a single chart. --Jerry
Re: Monthly Chart Tables ?
Tue Apr 21, 2015 9:01 am (PDT) . Posted by:
Not separate tables! I don't know much about song charting in terms of granularity. Are charts/rankings posted only monthly or weekly or other? Are there multiple charts?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 21 Apr 2015 11:47:18 -0400
Subject: [MS_AccessPros] Monthly Chart Tables ?
I'm working on a database for a publishing company
to show their copyrighted songs that charted over a period of
years. I'm trying to wrap my brain around the best way to show
that the same song charted for multiple months. Is it best to
create a date field that will be able to isolate everything in
queries, or would it be better to have separate tables for each
month, probably not?
Thanks,
Jerry in Michigan, USA
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar