RE: How do I handle this??

I also have another question. This is my basic database design and I want to
see if I am taking the right approach.

1. Projects Table: Main table, contains start date, end date, projmgr, etc.
- details about project (key: projectid)

2. Project Ranking: Project Ranking in 6 categories and total rank score
(key: projectid)

3. Project Resources: Which resources are assigned to this project (key:
projectid)

4. Project Updates: Weekly update for each project (key: projectid)

5. Project Issues: Issues for each project and details like date, owner, etc
(key: projectid)

6. Employees: A list of all employees who work on the company and could be
the resources assigned to a project. (key: employee id)

Let me have it!!! How badly designed is this database??? I also don't know
how to relate the tables.... Please help!


"mauricio" wrote:

I have a "projects" database. I need a UpdateStatus field on my table so the
users can enter weekly updates on their projects. I need to be able to keep
these updates for 52 weeks. I also need to timestamp their entries. Not every
project will have an update everyweek.

I created a table like this. (I already have a Projects Table, with all
other details about the project, ProjectID is the key for that table)

ProjectID update1 update2.............update52

Is this the best design for this?? If it is, how do I get the timestamp for
each entry?
.

Relevant Pages

  • Re: auto-updates
    ... any train of logic that could lead to the overall design of ... alert, I right-click, tell the system to install updates, and go about ... because of your status with Fedora Project... ... the proper thing is to file an RFE in bugzilla. ...
    (Fedora)
  • Re: "No objects need to be updated"
    ... As Jeff pointed out, Name AutoCorrect is designed to do this, but it doesn't work. ... Some of the other "updates" from design view can be useful. ... For example, whatever you enter as the Description of the field in table design, Access uses for the StatusBarText property in a text box. ... If you change the Description later, Access 2003/2007 offers to find the text boxes bound to this field, and update the StatusBarText for you. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: auto-updates
    ... any train of logic that could lead to the overall design of ... packagekit without assuming they were deliberately attempting ... alert, I right-click, tell the system to install updates, and go about ... I don't care what the download speed is, ...
    (Fedora)
Loading