Search results

james that helps... but here is an isssue dept # are not unique ...hence i cannot have them as primary key! can i assign primary key to a combination of two things?

Okay. Maybe I am falling a bit better now So technically this is how I see it: To get to a table with store, dept, and manufacturer This is what I need to do Stores: StoreID (PK) Store Name Departments: DeptID (PK) StoreID Dept Name Manufacturers: MfrID (PK) DeptID MfrName Run a crosstab...

Ah I see. So how would I connect this See what I see it is like a tree Store (store Id and location) has departments (dept no and description) and then each dept has manufacturers. But at the moment I data in two tables: dept and store, and dept and manufacturer The way I thought about is that...

Essentially I am trying to create the table sales as you mentioned above. If I separate the data. How would I connect dept to stores? That info is already in a corresponding table?

James, Thanks for the prompt response. See I didn't design the the two tables. This is how the data was given to me. The dept./store already has all the departments for all the stores listed. Store to dept is one to many relationship. The next table is dept to manufacturer. This one again is...

James there is no direct relationship between manufacturer and store. That is what I m trying to achieve. One table gives me dept and manufacturer info. Other gives me dept and store info. I need to combine them such that: Store, dept, and manufacturer fields What I did so far is made dept...

Hi Need help on an assignment here I have two tables: Table: Department/Manufacturer Sales Info - dept no, primary key - dept name - manufacturer no. - manufacturer name. - sales Table: Department/Store Info - dept no, primary key - dept name - store no. - store location How do I design a...