Design Trade Company Database

[Davi]

I need to design database for Trade Company, use Access 2003or SQL Server 2000?

Access 2003

Northwind Sample Database

Sheet
Product:
1,"Apple Juice",1,1,"24bottles/case",US$18,39,0,10,1
2,"Milk",1,1,"24bottles/case",US$19,17,40,25,0
3,"Tomato Juice",1,2,"24bottles/case",ï¿¥10,13,70,25,0
My Company, the same.

Order:
10248,"VINET",5,1996-7-4 00:00:00,1996-8-1 00:00:00,1996-7-16
00:00:00,3,US$32,"Miss U","G N Rd. 124","Washington","Washington
DC","00000","the United States"
10249,"TOMSP",6,1996-7-5 00:00:00,1996-8-16 00:00:00,1996-7-10
00:00:00,1,US$12,"Miss X","Q N Rd. 543","New York","New York","the United
States",""
10250,"HANAR",4,1996-7-8 00:00:00,1996-8-5 00:00:00,1996-7-12
00:00:00,2,US$66,"Miss Y","G Street 22",,"New York","New York","the United
States"

Order Details:
10248,17,US$14,12,0.00
10248,42,US$10,10,0.00
10248,72,US$35,5,0.00

Supplier:
1,"JJ","Miss C","Purchse Manager","X Street 110","Washington","Washington
DC.","100000","the United States","(000) 000000000",,
2,"KF","Miss H","Purchasing Manager","XF Street
290","Washington","Washington DC.","10000","the United States","(000)
00000000",,
3,"MS","Mr H","Sales Representative","NJ Rd. 23","New York","New
York","10000","the United States","(000) 00000000","(000) 00000000",
MyCompany, have more:"Web URL", "Email"

Customer:
"ALFKI","SC","Miss L","Sales Representative","DC 50","New York","New
York","10000","the United States","(000) 00000000","(000) 00000000"
"ANATR","DN","Miss W","Owner","CD 80","New York","New York","10000","the
United States","(000) 00000000","(000) 00000000"
"ANTON","TS","W","Owner","HT 780","New York","New York","10000","the United
States","(000) 00000000",

Categories:
1,"Drink","Soft Drink, Coffee, Tea, Beer",

Freight Forwarder
3,"Fedex","(000) 00000000"



I need to design database for Trade Company, use Access 2003or SQL Server
2000?
Is it right?
How to do?

 

[Jeff Boyce]

It seems like you might be asking for help with the overall design. These
newsgroups are great for getting help with specific questions, but you may
not find many of the volunteers here with the time to design you a
database...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Chris2]

I need to design database for Trade Company, use Access 2003or SQL Server 2000?

I need to design database for Trade Company, use Access 2003or SQL Server
2000?
Is it right?
How to do?

Davi,

A couple of good books to look at:

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L. Viescas


Sincerely,

Chris O.

 

[Steve]

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Marshall, MVP]

Nothing to say stevie? Or is this your not to sublte way of advertising?

John... Visio MVP

 

[JackShephard]

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications

SPAMLink SNIPPED


SPAMTard, providing unsuspecting victims with a ploy to get cash from
them, when all they wanted was some newbie assistance in a free help
forum.

This forum is not an advertising outlet for you, snake oil boy.