dbTalk Databases Forums  

simple db - how am I doing so far?

Go Back dbTalk Databases Forums Databases comp.databases.theory simple db - how am I doing so far?

comp.databases.theory comp.databases.theory


Discuss simple db - how am I doing so far? in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
strongsilentone@gmail.com
 
Posts: n/a

Default simple db - how am I doing so far? - 12-14-2008 , 03:03 PM





Hi, I'm designing a simple database to help out a co-worker. There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. This database is intended to assist in managing massive
quantities of sheet music. Please don't laugh, I'm using MS Access.
It suits this purpose just fine

(if this is unclear you can view it on my blog
http://sscode.blogspot.com/2008/12/t...sid-title.html
)


table: INVENTORY (master)
sID TITLE ARRANGER PUBLISHER GENRE INSTRUMENTS
auto text long int long int long int long int


table: ARRANGER
aID arranger
auto text


table: PUBLISHER
pID publisher_name phone_number
auto text text


table: GENRES
gID genre
auto text


table: INSTRUMENTS
iID instrument
auto text


Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM





On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #3  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #4  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #5  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #6  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #7  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #8  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #9  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
  #10  
Old   
Ed Prochak
 
Posts: n/a

Default Re: simple db - how am I doing so far? - 12-16-2008 , 07:50 AM


On Dec 14, 4:03*pm, strongsilent... (AT) gmail (DOT) com wrote:
Quote:
Hi, I'm designing a simple database to help out a co-worker. *There
are some questions I think are worth asking this individual before I
go any further, but I'd like some feedback on the approach I've taken
so far. * This database is intended to assist in managing massive
quantities of sheet music. * *Please don't laugh, I'm using MS Access..
It suits this purpose just fine

(if this is unclear you can view it on my bloghttp://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html
)

table: INVENTORY (master)
sID * * TITLE * ARRANGER * * * *PUBLISHER * * * GENRE* INSTRUMENTS
auto * *text * *long int * * * *long int * * * *long int * * * *long int

table: ARRANGER
aID * * arranger
auto * *text

table: PUBLISHER
pID * * publisher_name *phone_number
auto * *text * *text

table: GENRES
gID * * genre
auto * *text

table: INSTRUMENTS
iID * * instrument
auto * *text
This has little to do with theory, so you should have posted in
comp.databases.

With this design, do you intend to have a row in INSTRUMENTS for every
combination?
1 bells
2 flute
3 bells, flute
4 snare drum
5 bells, snare drum
6 flute, snare drum

You should pull instrument out of the inventory table and add a cross
reference like this:
INSTRUMENT_USED
sID iID
FK to FK to
INVENTORY INSTRUMENTS

Your need to learn about Normalizing your data model. Look up database
normalization.
HTH,
Ed


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top