Identifying Attributes › Identifying the Attributes of Each Entity › Grouping the Attributes

Grouping the Attributes

You can identify the attributes associated with an entity by examining the following materials:

• List of business functions
• List of business rules
• List of data elements that you compiled during systems analysis

Attributes for entities

As you determine the attributes that are associated with a particular entity, you should list the attributes, as shown below:

 OFFICE                                   JOB     

       OFFICE CODE                             JOB ID
       OFFICE ADDRESS                          JOB TITLE
       OFFICE SPEED DIAL                       JOB DESCRIPTION
       OFFICE AREA CODE                        REQUIREMENTS
       OFFICE PHONE                            MAX SALARY
                                               MIN SALARY
 DEPARTMENT                                    NUMBER OF POSITIONS
                                               NUMBER OPEN
       DEPT ID                                 SALARY GRADE
       DEPT NAME
       DEPT HEAD ID

 SKILL                                    PROJECT 

       SKILL CODE                              PROJECT CODE
       SKILL NAME                              PROJECT LEADER
       SKILL DESCRIPTION                       PROJECT DESCRIPTION
                                               EST START DATE
                                               ACT START DATE
                                               EST END DATE
                                               ACT END DATE

 EMPLOYEE                                 HEALTH INS PLAN 

       EMP ID                                  HEALTH PLAN CODE
       EMP NAME                                INSCO NAME
       SS NUMBER                               INSCO ADDRESS
       EMP ADDRESS                             INSCO PHONE
       EMP HOME PHONE                          PLAN DESCRIPTION
       DATE OF BIRTH                           GROUP NUMBER
       DATE OF HIRE
       DATE OF TERMINATION
       STATUS

 COVERAGE                                 LIFE INS PLAN 

       HEALTH PLAN CODE                        LIFE PLAN CODE
       COVERAGE TYPE                           INSCO NAME
       COVERAGE DESCRIPTION                    INSCO ADDRESS
       SELECTION DATE                          INSCO PHONE
       TERMINATION DATE                        PLAN DESCRIPTION

 DENTAL CLAIM                            HOSPITAL CLAIM

       DENTAL CLAIM ID                         HOSPITAL CLAIM ID
       EMP ID                                  DATE OF CLAIM
       COVERAGE TYPE                           EMP ID
       DATE OF CLAIM                           COVERAGE TYPE
       PATIENT NAME                            PATIENT NAME
       RELATION TO EMPLOYEE                    RELATION TO EMPLOYEE
       PATIENT SEX                             PATIENT SEX
       PATIENT DATE OF BIRTH                   PATIENT DATE OF BIRTH
       PATIENT ADDRESS                         PATIENT ADDRESS
       NUMBER OF DENTAL PROCEDURES             DIAGNOSIS
       TOTAL CHARGES                           TOTAL CHARGES
       DENTIST LICENSE NUMBER                  HOSPITAL NAME
       DENTIST NAME                            HOSPITAL ADDRESS
       DENTIST ADDRESS                         ADMIT DATE
       PROCEDURE ID                            DISCHARGE DATE
       PROCEDURE DESCRIPTION
       PROCEDURE FEE
       SERVICE DATE

 NON-HOSPITAL CLAIM 

       NON-HOSPITAL CLAIM ID
       DATE OF CLAIM
       EMP ID
       COVERAGE TYPE
       PATIENT NAME
       RELATION TO EMPLOYEE
       PATIENT SEX
       PATIENT DATE OF BIRTH
       PATIENT ADDRESS
       NUMBER OF PROCEDURES
       TOTAL CHARGES
       DIAGNOSIS
       PHYSICIAN ID
       PHYSICIAN NAME
       PHYSICIAN ADDRESS
       PROCEDURE ID
       PROCEDURE DESCRIPTION
       PROCEDURE FEE
       SERVICE DATE