Home / Stem Page 14

Information Systems - 61

For example: DEPARTMENT MSK TENK MONHOC one many Belong MSSV MSK STUDENTS HOT NOW much MSMH TENMH LT TH much Register Many-to-many relationship (nn) is converted into 2 consecutive numbers: 0,n/1,n and 0,n/1,n 16 MSK TENK FACULTY 1,1 1,n MSSV MSK STUDENTS HOT NOW 1.1 MONHOC MSMH TENMH LT TH 0,n DK ...

System Commands and Functions Used in Triggers

ON Ngan AFTER Delete AS BEGIN select * from inserted select * from deleted END Test result of Trigger_DeleteNganh trigger when Delete action is executed: Inserted table has no data and deleted table contains deleted records. Figure 5.2. Results of performing the Delete action Example 3: Create ...

Home Reference Doccument