If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Design Question
Sorry to post another question but I'm still thinking I've missed something,
only because I didn't realize the other piece of the puzzle. I think seeing the "spreadsheet" of what exists today is handicapping my design. Please if somebody could help me understand. Right now, we have two different offerings. Within each offering we have the same regions and countries but the difference lies with the levels of support offered (4, one no service, or null value). So I could have Offering 1...then shows APAC....then showing the country Australia has 1st level of support. But on the Offering 2 there is no service. Again I have these tables, Region_t RegionID(PK), Region Country_t CountryID(PK), Country, RegionID(FK) Support SupportID(PK), Support Description, CountryID(FK), RegionID(FK) ---is this right? And how do I incorporate the 2 offerings? Does that start at top above region? Do I include the offering as a FK in the Region table? Sorry I'm lost and really trying to do things the right way. Since things are always added on, I'm preparing for Languages spoken to be thrown my way, just wonder if it would be easy to incorporate later on? Assuming it would be another table, connected to region perhaps? I really appreciate everyone's help. |
#2
|
|||
|
|||
Design Question
If you were to produce a report with columns Region, Country, Service, and
offering, what would it look like? Could you post this with sample data? I'm having a hard time understanding your requirements. I'm sure the DB is quite simple. And your table Support is wrong. If you know the Country, you know the Region. I'm happy to help you, just help me understand your requiremts. Again, a sample report with sample data would help. Thanks, Evan "jenniferspnc" wrote in message ... Sorry to post another question but I'm still thinking I've missed something, only because I didn't realize the other piece of the puzzle. I think seeing the "spreadsheet" of what exists today is handicapping my design. Please if somebody could help me understand. Right now, we have two different offerings. Within each offering we have the same regions and countries but the difference lies with the levels of support offered (4, one no service, or null value). So I could have Offering 1...then shows APAC....then showing the country Australia has 1st level of support. But on the Offering 2 there is no service. Again I have these tables, Region_t RegionID(PK), Region Country_t CountryID(PK), Country, RegionID(FK) Support SupportID(PK), Support Description, CountryID(FK), RegionID(FK) ---is this right? And how do I incorporate the 2 offerings? Does that start at top above region? Do I include the offering as a FK in the Region table? Sorry I'm lost and really trying to do things the right way. Since things are always added on, I'm preparing for Languages spoken to be thrown my way, just wonder if it would be easy to incorporate later on? Assuming it would be another table, connected to region perhaps? I really appreciate everyone's help. |
#3
|
|||
|
|||
Design Question
Sure, thanks for the help.
Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. 2nd example: Looking at 1st offering. In Austria, region EMEA, there is Level 2 support but nothing entered for APAC or America. On second offering, in Austria, Region EMEA, Level 1 Support is offered but nothing for APAC or America.. Hope this helps clarify what I'm looking to achieve. Thank you! "Evan Keel" wrote: If you were to produce a report with columns Region, Country, Service, and offering, what would it look like? Could you post this with sample data? I'm having a hard time understanding your requirements. I'm sure the DB is quite simple. And your table Support is wrong. If you know the Country, you know the Region. I'm happy to help you, just help me understand your requiremts. Again, a sample report with sample data would help. Thanks, Evan "jenniferspnc" wrote in message ... Sorry to post another question but I'm still thinking I've missed something, only because I didn't realize the other piece of the puzzle. I think seeing the "spreadsheet" of what exists today is handicapping my design. Please if somebody could help me understand. Right now, we have two different offerings. Within each offering we have the same regions and countries but the difference lies with the levels of support offered (4, one no service, or null value). So I could have Offering 1...then shows APAC....then showing the country Australia has 1st level of support. But on the Offering 2 there is no service. Again I have these tables, Region_t RegionID(PK), Region Country_t CountryID(PK), Country, RegionID(FK) Support SupportID(PK), Support Description, CountryID(FK), RegionID(FK) ---is this right? And how do I incorporate the 2 offerings? Does that start at top above region? Do I include the offering as a FK in the Region table? Sorry I'm lost and really trying to do things the right way. Since things are always added on, I'm preparing for Languages spoken to be thrown my way, just wonder if it would be easy to incorporate later on? Assuming it would be another table, connected to region perhaps? I really appreciate everyone's help. |
#4
|
|||
|
|||
Design Question
"jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
#5
|
|||
|
|||
Design Question
Yes, sorry that's right, I was looking at another tab that had actual support
locations in one area supporting multiple countries and getting it all confused....but that is a separate table that i'm using just to print office locations, I won't be tying that in (there's so much information in this one excel document).... So for this specific one, country is associated with only one region and can have varying level of support based on which offering it appears under..that should make it work. As you stated, yes, one region can have many locations but a location can only be associated with one region. "Evan Keel" wrote: "jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
#6
|
|||
|
|||
Design Question
Ok, I think I understand. Your tables would look like this:
Region_t RegiondID (PK) Country_t CountryID (PK) Country RegionID (FK) Support_t SupportID (PK) SupportDescription CountryOfferings_t CountryID (PK) OfferNumber(PK) (Sequential number) SupportID (FK) This allows for any number of offers and only one Support type per offer. It can be too easy to think in terms of a spreadsheet. As you know, to get the spreadsheet look you would need use a cross-tab query. Do you really need to append "-t" to table names? Hope this helped. Evan "jenniferspnc" wrote in message news Yes, sorry that's right, I was looking at another tab that had actual support locations in one area supporting multiple countries and getting it all confused....but that is a separate table that i'm using just to print office locations, I won't be tying that in (there's so much information in this one excel document).... So for this specific one, country is associated with only one region and can have varying level of support based on which offering it appears under..that should make it work. As you stated, yes, one region can have many locations but a location can only be associated with one region. "Evan Keel" wrote: "jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
#7
|
|||
|
|||
Design Question
Hopefully this is my last post for the day (week), but I did encounter
something. Again, guess it would help if I understood the info I was asked to put into a database but I don't 100%, as I'm not involved in it. So I have country, Brazil, that is in Americas Region; however, they are also considered under Partner. How could i do that or does that change everything? Under offering 1 they get level 1 support in America and level 2 support by partner. Again I apologize, guess I should really look at all the if's...hoping it's easy to adjust in case something else occurs. Thank you, thank you! "Evan Keel" wrote: Ok, I think I understand. Your tables would look like this: Region_t RegiondID (PK) Country_t CountryID (PK) Country RegionID (FK) Support_t SupportID (PK) SupportDescription CountryOfferings_t CountryID (PK) OfferNumber(PK) (Sequential number) SupportID (FK) This allows for any number of offers and only one Support type per offer. It can be too easy to think in terms of a spreadsheet. As you know, to get the spreadsheet look you would need use a cross-tab query. Do you really need to append "-t" to table names? Hope this helped. Evan "jenniferspnc" wrote in message news Yes, sorry that's right, I was looking at another tab that had actual support locations in one area supporting multiple countries and getting it all confused....but that is a separate table that i'm using just to print office locations, I won't be tying that in (there's so much information in this one excel document).... So for this specific one, country is associated with only one region and can have varying level of support based on which offering it appears under..that should make it work. As you stated, yes, one region can have many locations but a location can only be associated with one region. "Evan Keel" wrote: "jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
#8
|
|||
|
|||
Design Question
Okay. Just what is a Region? Is it the Region that is responsible for
providing support for a group of Countries? Is Partner also a support provider? A Country may have Offer 1 support provided by both a Region and a Partner as long as different levels of support are provided by each? How many Partners support a particular offer? For Brazil, can I have Partner provide Level 2 support, Partner 2 provide Level 3 support, and Americas provide Level 1 Support? What other info do want to keep about Partner? Evan "jenniferspnc" wrote in message ... Hopefully this is my last post for the day (week), but I did encounter something. Again, guess it would help if I understood the info I was asked to put into a database but I don't 100%, as I'm not involved in it. So I have country, Brazil, that is in Americas Region; however, they are also considered under Partner. How could i do that or does that change everything? Under offering 1 they get level 1 support in America and level 2 support by partner. Again I apologize, guess I should really look at all the if's...hoping it's easy to adjust in case something else occurs. Thank you, thank you! "Evan Keel" wrote: Ok, I think I understand. Your tables would look like this: Region_t RegiondID (PK) Country_t CountryID (PK) Country RegionID (FK) Support_t SupportID (PK) SupportDescription CountryOfferings_t CountryID (PK) OfferNumber(PK) (Sequential number) SupportID (FK) This allows for any number of offers and only one Support type per offer. It can be too easy to think in terms of a spreadsheet. As you know, to get the spreadsheet look you would need use a cross-tab query. Do you really need to append "-t" to table names? Hope this helped. Evan "jenniferspnc" wrote in message news Yes, sorry that's right, I was looking at another tab that had actual support locations in one area supporting multiple countries and getting it all confused....but that is a separate table that i'm using just to print office locations, I won't be tying that in (there's so much information in this one excel document).... So for this specific one, country is associated with only one region and can have varying level of support based on which offering it appears under..that should make it work. As you stated, yes, one region can have many locations but a location can only be associated with one region. "Evan Keel" wrote: "jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
#9
|
|||
|
|||
Design Question
So it's Partner is another type of Region under Offering.
There are two offerings, 1 and 2. Each offering there are the Regions listed... America, EMEA, APAC, and Partner (which I missed to begin with). The countries are all the same. I'm guessing "Partner" is not really a "region" (but we show it as that) perhaps b/c not all countries could be supported by Partner, but that could grow. A Country may have Offer 1 support provided by both a Region and a Partner as long as different levels of support are provided by each? Brazil could have level 1 support from both America and Partner under offering 1. But under offering 2 they may only get support from Partner and that may be level 2 of support. It's very muddy How many Partners support a particular offer? For Brazil, can I have Partner provide Level 2 support, Partner 2 provide Level 3 support, and Americas provide Level 1 Support? For now it shows only 1 Partner under offering 1; however, I'm seeing that could grow...So perhaps in anticipation of that growing, I could have a Parnters table with the specifics and just notate the word "Partner" as "Level of Support" instead of listing a level. But for now while it's one I would want the actual level. In Offering 2 there are many Partners, so kind of as I said above, I could just notate "Partner" instead of say Level 1 or Level 2 of support. Am I thinking along the right lines in how to handle this? Apologize for the confusion, and thank you for your patience while helping. Can imagine the headache I have "Evan Keel" wrote: Okay. Just what is a Region? Is it the Region that is responsible for providing support for a group of Countries? Is Partner also a support provider? A Country may have Offer 1 support provided by both a Region and a Partner as long as different levels of support are provided by each? How many Partners support a particular offer? For Brazil, can I have Partner provide Level 2 support, Partner 2 provide Level 3 support, and Americas provide Level 1 Support? What other info do want to keep about Partner? Evan "jenniferspnc" wrote in message ... Hopefully this is my last post for the day (week), but I did encounter something. Again, guess it would help if I understood the info I was asked to put into a database but I don't 100%, as I'm not involved in it. So I have country, Brazil, that is in Americas Region; however, they are also considered under Partner. How could i do that or does that change everything? Under offering 1 they get level 1 support in America and level 2 support by partner. Again I apologize, guess I should really look at all the if's...hoping it's easy to adjust in case something else occurs. Thank you, thank you! "Evan Keel" wrote: Ok, I think I understand. Your tables would look like this: Region_t RegiondID (PK) Country_t CountryID (PK) Country RegionID (FK) Support_t SupportID (PK) SupportDescription CountryOfferings_t CountryID (PK) OfferNumber(PK) (Sequential number) SupportID (FK) This allows for any number of offers and only one Support type per offer. It can be too easy to think in terms of a spreadsheet. As you know, to get the spreadsheet look you would need use a cross-tab query. Do you really need to append "-t" to table names? Hope this helped. Evan "jenniferspnc" wrote in message news Yes, sorry that's right, I was looking at another tab that had actual support locations in one area supporting multiple countries and getting it all confused....but that is a separate table that i'm using just to print office locations, I won't be tying that in (there's so much information in this one excel document).... So for this specific one, country is associated with only one region and can have varying level of support based on which offering it appears under..that should make it work. As you stated, yes, one region can have many locations but a location can only be associated with one region. "Evan Keel" wrote: "jenniferspnc" wrote in message ... Sure, thanks for the help. Here's a few lines from an Excel document of how it's displayed now. Offering 1 Offering 2 (region) EMEA, APAC, America EMEA, APAC, America Australia Null, Level 1, Null Null, Null, Null Austria Level 2, Null, Null Level 1, Null, Null Not sure how the formatting appears in the message so I'll explain. As you can see there is a level 1 support for Australia, in APAC, in the 1st offering. There is no level of support currently entered for EMEA or America (probably to be added at a future date, if at all). At the same time Offering 2 has nothing for Australia in any of the Regions. I thought the relationship between Region and Country was 1 to Many. One Region contains many Countrys. A Country belongs to one Region. How can Austrailia have a support level for Regions EMEA and America if it belongs to Region APAC? Evan |
Thread Tools | |
Display Modes | |
|
|