hi to all.. i am new here and i need help on normalization. i came up with an EERD and derived the following entities from below
i do know some stuff about normalization but this monster table has me all confused...i derived all the attributes(in first normal form...i think??) from an EERD i designed from a given situation...
i would really appreaciate all the help i can get.. thanks
------------------------------------------------------------------------------------
EMPLOYEE
EMP_ID F_NAME L_NAME TEL SEX
CSM_BRANCH_LOCATION D_IC_NO
MANAGER
EMP_ID MAN_ID CSM_BRANCH_LOCATION
OPERATION EXECUTIVE
EMP_ID OPS_ID CSM_BRANCH_LOCATION
SERVICE ENGINEER
EMP_ID ENGR_ID CSM_BRANCH_LOCATION
DEPENDANTS
D_IC_NO D_NAME SEX RELATION
SERVICE REQUEST
SERVICE_REQUEST_ID DATE PROBLEM OPS_ID
C_IC_NO
CSM BRANCH
CSM_BRANCH_LOCATION TELEPHONE
NO_OF_EMPLOYEE
SPARES
S_NAME/ MODEL PRICE QUANTITY
S/W SPARE
VERSION_NO ACTIVATION_KEY
H/W SPARE
SERIAL _NO WARRANTY
CUSTOMER
C_IC_NO ADDRESS NAME TEL
MEMBER
MEMBER_ID NAME MEM_JOIN MEM_EXP
VENDORS
VENDOR_ID TEL ADDRESS
OPS_ALLOT_ENGR RELATIONSHIP
OPS_ID SRQ_NO ENG_ID
ENGR_SRQ RELATION
ENG_ID SRQ_NO NO_OF_HOURS
-----------------------------------------------------------------------------------