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: luvmymelody@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar