huge database with 800 customers / 3.500 products

heynem

Hi everybody,
unfortunaly I am a starter with mysql, so pls. make your answers not
too complicated :-))
I need for a webshopproject all customers with all products in one
file. I have already both informations in two different ones. Pls.
find below the relevant info.
product
ProductID|pricegroup|
customer
knr|pricegroup|%calc|price

It is possible that one product is related to 800 customers with
800 different prices. In my thinking the new DB should look like
pricefile
ProductID|knr|pricegroup|%calc|price

Thank you advance for any help on this....

cheers
Michael

Jul 20 '05 #1

Subscribe Reply

1106

CryingClinton

1. table product

product_id, product_description fields...

2. table customer

customer_id, customer_detail fields...

3. table product_customer

product_id, customer_id, price, remark...

hope this would be helpful
Cheers,
ccton
--
www.vicdir.com
"heynem" <m.*****@noesse.de> ????
news:c2**************************@posting.google.c om...

Hi everybody,
unfortunaly I am a starter with mysql, so pls. make your answers not
too complicated :-))
I need for a webshopproject all customers with all products in one
file. I have already both informations in two different ones. Pls.
find below the relevant info.
product
ProductID|pricegroup|
customer
knr|pricegroup|%calc|price

It is possible that one product is related to 800 customers with
800 different prices. In my thinking the new DB should look like
pricefile
ProductID|knr|pricegroup|%calc|price

Thank you advance for any help on this....

cheers
Michael

Jul 20 '05 #2

Similar topics

346

database market share 2003

by: rkusenet | last post by:

http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.

DB2 Database

How to select only customers that ordered 2 specific products?

by: JohnA | last post by:

Dear all, I'm trying to compose a query, but I don't know how to express the statement. I have 4 tables: Customers, Orders, Order Details and Products. Each customer has many orders and each...

Microsoft Access / VBA

Distributing Jet database engine

by: PeterH | last post by:

I have an application written in VB.Net that opens an Access database (ie a Microsoft Jet 4 database mdb file). It does not use Access forms or reports, so there is no need for users to have...

Microsoft Access / VBA

Rqst for Inventory Database Best Practices

by: DeepDiver | last post by:

I am developing an inventory database in SQL Server. I realize there are many commercial (as well as some non-commercial) inventory offerings, but my client has specific requirements that would...

Microsoft SQL Server

Where do I put my Database relations... at DATABASE level or in PROGRAM LEVEL?

by: mesut | last post by:

Mybe it's a stupid question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like...

ASP.NET

Northwind database extra SQL needs

by: soalvajavab1 | last post by:

I have asked for the following questions and I need your advises. Utilizing the Northwind database suppied with SQL Server, create SQL to solve each of the exercises listed. 1. I want to...

Microsoft SQL Server

Database Normalization and Table Structures

by: MMcCarthy | last post by:

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...

Microsoft Access / VBA

Stock Management Database

by: asmusdk | last post by:

I am working on creating a stock management database for a small company. The company receives the merchandise from a handful of suppliers and stocks it before it is sent to the customers –...

Microsoft Access / VBA

Help...Best way to create a sales and invoice database

by: firefighter17103 | last post by:

Hi All, I am new to MS Access 07, & do not know any VB, on a new business adventure. I am running Office07 on Vista Home Premium. Basically what I would like to do is create a database that I...

Microsoft Access / VBA

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp