COMPLETE MYSQL DATABASE PROJECT WITH TRIGGERS AND RELATION SHIPS REFERENTIAL INTEGRITY
182 بار بازدید -
2 سال پیش
-
source codepdf
source code
pdf
https://drive.google.com/file/d/1gdHR...
sql
https://drive.google.com/file/d/1xJCk...
Things to remember when working Database Programming
1. you can never update the row on 'after insert'
2.you can never update the row on 'after update'
3. you can never update the row on 'after delete'
4. you can never use the incoming value to update another table on 'before insert'
5. trigger does not return any thing
6. procedure does not return any thing
7. trigger can never pass parameter
8. you can never write function expression within computed column
9. computed column can never be computed again
10. primary key column can never be computed column
11. you can never insert data on child table unless the data exist on mother table
12. deletion on mother table is impossible because the data is used by the child
13. primary key can combine multiple columns named 'composite key'
14. you can never write trigger within procedure
15. database achieves functional requirements more than 70%
16. you can never perform arithmetic operation when the row is null
https://drive.google.com/file/d/1gdHR...
sql
https://drive.google.com/file/d/1xJCk...
Things to remember when working Database Programming
1. you can never update the row on 'after insert'
2.you can never update the row on 'after update'
3. you can never update the row on 'after delete'
4. you can never use the incoming value to update another table on 'before insert'
5. trigger does not return any thing
6. procedure does not return any thing
7. trigger can never pass parameter
8. you can never write function expression within computed column
9. computed column can never be computed again
10. primary key column can never be computed column
11. you can never insert data on child table unless the data exist on mother table
12. deletion on mother table is impossible because the data is used by the child
13. primary key can combine multiple columns named 'composite key'
14. you can never write trigger within procedure
15. database achieves functional requirements more than 70%
16. you can never perform arithmetic operation when the row is null
2 سال پیش
در تاریخ 1401/01/06 منتشر شده
است.
182
بـار بازدید شده