基于项目的公司的数据库设计 [英] Database design for a project based company

问题描述

嗨

i是编程和数据库的新手。

i必须为一家为其他公司提供人力服务的公司开发数据库。

场景是该公司按月或按小时计算工资单将员工发送给任何客户公司。我必须保留这个项目的记录。



请建议如何设计数据库和网络表格的解决方案。

i不要求现在详细解答..概述会很好。



问候

解决方案

基本上你需要首先学习数据库设计。



数据库架构设计的最佳实践（初学者） [ ^ ]



关系数据库设计：最佳实践入门 [ ^ ]



十大常见数据库设计错误 [ ^ ]



然后你需要了解客户的要求。

我很确定要求清单比你在问题中说的要长得多。



当然，你需要知道如何创建数据库查询。

SQL教程 [ ^ ]

hi
i am new to programming and databases.
i have to develop a database for a company which provides manpower services to other companies.
the scenario is that this company sends employees to any client company on monthly OR hourly based payroll. i have to keep record of this project.

please advice a solution how to design the database and web forms.
i don't require a detailed answer for now.. an overview will be fine.

regards

解决方案

Basically you need to learn database design first.

Best Practices for Database Schema Design (Beginners)[^]

Relational Database Design: A Best Practices Primer[^]

Ten Common Database Design Mistakes[^]

Then you need to understand the customer requirements.
I am pretty sure that the requirement list is much longer than you have stated in the question.

And of course you need to know how to create queries to the database.
SQL Tutorial[^]

这篇关于基于项目的公司的数据库设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！