如何为计费系统或库存系统建立数据库 [英] How to make database for billing system or inventory system

问题描述

我想建立一个商店计费系统或库存系统，我对数据库设计感到非常困惑，因为我已经在Access中制作了3张表
1.客户
2.订购
3.产品
请指导我.....
我不是C#的豹子，因此我不想管理更多表.尝试了解:-(

I want to make a shop billing system or inventory system I am to much puzzled for database design i have made 3 tables in Access
1. Customer
2. Order
3. Product
please guide me .....
I am not leopard of C# therefore i dont want more table to manage. try to understand:-(

推荐答案

您可能会发现以下链接很有帮助
免费数据模型库 [

You might find the below link helpful
Library of Free Data Models[^]

您的数据库设计将完全基于客户的要求.您应该与他们交谈，以了解他们想要从系统中获得什么.我要说的是，您将需要更多的桌子-除非您仅允许客户下订单并拥有一种产品.这意味着您将需要将客户映射到订单以及将订单映射到产品的中间表.

据我所知，您的问题与C#无关，而与数据库的逻辑结构有关.

Your database design will be based entirely on the requirements of your client. You should be talking to them to find out what they want from the system. I will say that you are going to need more tables than that - unless you only allow a customer to place one order, and have one product. This means that you will need intermediate tables that map customers to orders, and orders to products.

As far as I can see, your question has very little to do with C#, and much more to do with the logical structuring of the database.

这篇关于如何为计费系统或库存系统建立数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！