Re: [MS_AccessPros] Normalization of a table

 

Hi Jim,

I wouldn't think you need to pull any fields out but some considerations:

- you have several date fields. These could be in a separate, related table of milestones but in your case I think simpler is better

- If a task might be for more than one department you could create a junction table of TaskID/DeptID

- The same is true if a task be of more than one type

- You might be able to get rid of the MonthlyGoal and only use the YearGoal. If YearGoal isn't null I would assume MonthlyGoal would be Yes/true

Overall, I think it looks good. Since there isn't an employeeID field I assume this is for your use.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, December 21, 2017 12:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Normalization of a table

 

Hello All,

I am normalizing a table so that I can move it to SQL. I wanted the table to normalized before I import it into the SSMS. But I have a question about some fields that I am not sure I should move out of the main table.

The table is tblTasks. it is the main table that holds the information of the tasks and projects. the fields are below. Could I get some instructions on which ones I should move off?

Thank You

Jim Wagner

TaskID    AutoNumber

TaskDate    Date/Time

Rank    Either A, B, or C

TaskType    Number data type with the field being linked to tblTaskType table

TaskTitle    the title of the Task. high level description

TaskDescription Long Text data type. long description

TaskName    short/text linked to tblTaskNames table that usually is the name of the database working on

Accomplishments Yes/No data type. it is to help me run a report of my yearly accomplishments for the year

ForResume    To run a report to add projects to my resume

MonthlyGoal    Yes/NO data type If it a Yearly goal, it would be the Year of the goal

StatusType    Short Text data type. it is the status of the task like in process or completed or on hold

Department    the department the work is being done for.

DueDate    The date the task is due

CompletedDate    the date the task was completed

ColorOfRecord    a way of relating a color to the task. Used in another form to colorize a task.

YearGoal    the year the goal is referred to. Not all task is a goal record. Related to MonthlyGoal field

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___