DSD Teacher aid system driving Project DSD VER

DSD Teacher aid system driving Project - DSD - VER - 02 TEST_TYPE_TBL B TEST_ CODE_FLD(PK) TEST_TYPE_FLD TESTS_TBL D TESTS_SNUM_FLD(PK) TEST_ CODE_FLD(FK) TEST_DATE_FLD TEST_HOUR_FLD Xxx_Tbl B D A PK FK PFK STUDENTS_TBL STUDENTS_ID_FLD(PK) STD_FNAME_FLD STD_LNAME_FLD STD_ADD_FLD STD_BD_FLD PRICES _CODE_FLD(FK) LESSON_NUM_FLD GREEN_FORM_FLD EXPIRE_G_DATE_FLD THEORY_FLD EXPIRE_T_DATE_FLD FEE_PAY_FLD A Legend STD_TESTS_TBL Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M TESTS_SNUM_FLD(FPK) STUDENTS_ID_FLD(FPK) TEST_ CODE_FLD(FK) TEST_NUM_IN_FLD TEST_NUM_OUT_FLD B B PRICES_TBL Data Structures Diagram B PRICES _CODE_FLD(PK) PRICE_FLD D INCOME_TBL INCOME_SNUM_FLD (PK) INCOME_ CODE_FLD (FPK) STUDENTS_ID_FLD(FK) INCOME_DATE_FLD INCOME_AMOUNT_FLD SCEDUAL_TBL D DATE_FLD (PK) HOUR_FLD (PK) STUDENTS_ID_FLD(FPK) SCEDUAL_CODE_FLD LESSON_NUM_FLD Based on: Teacher aid system driving Project - ERD - VER - 02 INCOME_TYPE_TBL B INCOME_ CODE_FLD(PK) INCOME_TYPE_FLD SCEDUAL_TYPE_TBL B SCEDUAL_CODE_FLD(PK) SCEDUAL_TYPE_FLD

DSD Teacher aid system driving Project - DSD - VER - 02 1 TEST_TYPE_TBL B 2 TEST_ CODE_FLD(PK) TEST_TYPE_FLD 2 D TESTS_TBL TESTS_SNUM_FLD(PK) TEST_ CODE_FLD(FK) TEST_DATE_FLD TEST_HOUR_FLD 3 Xxx_Tbl B D A PK FK PFK STUDENTS_TBL STUDENTS_ID_FLD(PK) STD_FNAME_FLD STD_LNAME_FLD STD_ADD_FLD STD_BD_FLD PRICES _CODE_FLD(FK) LESSON_NUM_FLD GREEN_FORM_FLD EXPIRE_G_DATE_FLD THEORY_FLD EXPIRE_T_DATE_FLD FEE_PAY_FLD A Legend STD_TESTS_TBL Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M TESTS_SNUM_FLD(FPK) STUDENTS_ID_FLD(FPK) TEST_ CODE_FLD(FK) TEST_NUM_IN_FLD TEST_NUM_OUT_FLD B B 1 PRICES_TBL Data Structures Diagram B PRICES _CODE_FLD(PK) 3 3 PRICE_FLD D INCOME_TBL INCOME_SNUM_FLD (PK) INCOME_ CODE_FLD (FPK) STUDENTS_ID_FLD(FPK) INCOME_DATE_FLD INCOME_AMOUNT_FLD SCEDUAL_TBL D DATE_FLD (PK) HOUR_FLD (PK) STUDENTS_ID_FLD(FPK) SCEDUAL_CODE_FLD LESSON_NUM_FLD Based on: Teacher aid system driving Project - ERD - VER - 02 1 INCOME_TYPE_TBL B INCOME_ CODE_FLD(PK) INCOME_TYPE_FLD 1 SCEDUAL_TYPE_TBL B SCEDUAL_CODE_FLD(PK) SCEDUAL_TYPE_FLD