POS database design help

[ghardwick]

I'm going to start off by saying that I'm not going to pretend that I have any idea what I am doing, but I'm determined to figure it out. Essentially I want to take point of sale data that I receive from several national retailers and aggregate it using PowerPivot and publish it to SharePoint. I'm thinking I'll beta test it in Access before having IT replicate in SQL. I've found the database design below that I think would work. I'm just having trouble making sense of much beyond the POS sources at the bottom. I've been watching youtube videos to help knock down the learning curve, but I need some direct consultation. Any suggestions on how I figure this out? I'm trying to build out the tables but I'm hung up on what some of the column entries are referring to. For example, what is POS_Source_System_ID..?

[June7]

I think that would be the IDs of the 3 sources at the bottom of the diagram. The Description field is info about each of those sources. The Source_X_POS_ID field in each Source table would have matching value in POS_Source_System_ID field. Another guess as to what the different sources might be - 3 retailers?

But I could be really wrong because on second look, that doesn't make sense in the Product_Cross_References linking. The 3 Source_ID fields look more like just a unique ID in each table.

Might want to look for another diagram.

Has been discussed in several threads. Search forum for "point of sale" - here's one https://www.accessforums.net/databas...ler-49178.html