如何为时间表应用程序创建数据库(所有表)? [英] How to create a database (all tables) for the Timesheet application?

问题描述

[ ]大家好，

我被要求设计一个时间表应用程序，其中包含有关在特定日期完成的任务，每天的工作时间以及项目和一天中完成的项目类型的信息.此信息必须至少保存2周，并要保留40名员工.第一步是设计数据库，我不确定所有表都必须放入其中！我是一个初学者，如果有人可以帮助我设计数据库(SQL语言)以及在可能的情况下维护信息的逻辑，我将非常高兴.
谢谢！!!!!!!

[]Hi All,

I have been asked to design a timesheet application which has information about tasks done on a particular day, the hours in per day and also the project and the type of projects worked on for a day. This information must be maintained for atleast 2 weeks and for 40 employees. The first step is to design the database and I''m not sure of what all tables must go in!! I''m a beginner and I would be very happy if anyone could help me on how to design the database (in SQL) and if possible on the logic to maintain the information.

Thanks a ton !!!!!!!

推荐答案

看看Stack Overflow上的该线程，这可能有助于您了解可能的数据库表

http://stackoverflow.com/questions/3282403/database-schema-for-time [ ^ ]

在asp.net上有一个示例应用程序

http://www.asp.net/downloads/starter-kits/time-tracker [ ^ ]

您将需要做一些研究:)

Have a look at this thread on Stack Overflow, this might help you understand possible database tables

http://stackoverflow.com/questions/3282403/database-schema-for-timesheet[^]

There''s an example application on asp.net

http://www.asp.net/downloads/starter-kits/time-tracker[^]

You''re going to have to do a bit of research :)

如果不确定如何设计数据库，您应该回去找主管并寻求帮助. (在大多数情况下)他很乐意为您提供帮助.毕竟他是负责申请的人.

If you are not sure of how to design the database, you should rather go back to your supervisor and ask for help. (In most of the cases) He would be happy to assist you. after all he is the one who is responsible for application.

这篇关于如何为时间表应用程序创建数据库(所有表)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！