featherhorse
Thread Starter
- Joined
- Jun 19, 2005
- Messages
- 111
Hello. I am trying to build a database. I had a class on Access 2003 almost 2 years ago and when I replaced my computer, it has Access 2007 and I find they are totally different and I have read tutorials, helps, etc. until I am so confused, I don't know what I am doing. I attend a local community college and cannot get anyone there to even help. I know once I get started, I will probably be ok, but I cannot get my table normalization/relationships to work. I understand the one-to-many, many-to-many, etc. and I know what primary keys are and foreign keys are, I just cannot bring it all together to work. My husband has a small home based business and I was using it to set up a database for one of my classes
(Systems Analysis and Design). I am getting behind in my class because I have been trying Hfor 3 weeks now to get this database up and I cannot move on with my project until I am
done with it. I am running out of time and desperately need some help, please. There are so many variables to his business. I'm not sure what information you need about how the business works, but here are the tables I have set up:
Licensee Table
Company Name (primary key)
First contact
First contacts title
Second contact
Second contacts title
Department
Office Phone
Cell Phone
Fax Number
Email address
Address
Address 2
City
State
Region
Zip/postal code
Country
Product type
Contract Table
Contract Number (primary key)
Company Name (foreign key)
Beginning date
Ending date
Royalties %
Flat fee
Adv against Royalties
Image Name (foreign key)
Product type
Notes
Follow-up Table
Company Name (primary key)
Image Name (foreign key)
Portfolio Number (foreign key)
Follow-up date
Images Table
Image Name (primary key)
Category
Size
Original Artwork Price
Portfolio Table
Portfolio Number (primary key)
Portfolio Type
Company (foreign key)
Image Name (foreign key)
Date Sent
Hi-Res CD Table
Hi-Res CD Number (primary key)
Contract Number (foreign key)
Company (foreign key)
Image Name (foreign key)
Date Sent
Thank you soooooooo much!!!!
(Systems Analysis and Design). I am getting behind in my class because I have been trying Hfor 3 weeks now to get this database up and I cannot move on with my project until I am
done with it. I am running out of time and desperately need some help, please. There are so many variables to his business. I'm not sure what information you need about how the business works, but here are the tables I have set up:
Licensee Table
Company Name (primary key)
First contact
First contacts title
Second contact
Second contacts title
Department
Office Phone
Cell Phone
Fax Number
Email address
Address
Address 2
City
State
Region
Zip/postal code
Country
Product type
Contract Table
Contract Number (primary key)
Company Name (foreign key)
Beginning date
Ending date
Royalties %
Flat fee
Adv against Royalties
Image Name (foreign key)
Product type
Notes
Follow-up Table
Company Name (primary key)
Image Name (foreign key)
Portfolio Number (foreign key)
Follow-up date
Images Table
Image Name (primary key)
Category
Size
Original Artwork Price
Portfolio Table
Portfolio Number (primary key)
Portfolio Type
Company (foreign key)
Image Name (foreign key)
Date Sent
Hi-Res CD Table
Hi-Res CD Number (primary key)
Contract Number (foreign key)
Company (foreign key)
Image Name (foreign key)
Date Sent
Thank you soooooooo much!!!!