at this time last year, we have learned the knowledge of database in self-examination. But after all, the exam is too shallow, and a lot of the knowledge just understand a noun. This year to borrow borrowed time to turn over, the original self-taught book on the very good, just when they did not practice so no resonance.
A few days ago The Apprentice asked me to give her the database of the book, she asked a few questions.
1. Triggers, views, stored procedures ... What's the answer to Jane's answer?
2. Why should the E-R model be transformed into a relational model?
3. Function dependency
Take the first question example, which says that triggers provide a way for programmers and data analysts to ensure data integrity. Indeed, if you have not used triggers, it is really hard to put knowledge into your head. Personal refactoring when trying to use a trigger, after using it is really deep experience. When the time is too short or at present can not go to hands-on practice, you have to start from the concept, simply said, either executed, or not executed.
Because recently in review soft Test, also have to look at database knowledge. Look at the database again, feel really very different. Soft test to a large extent let you comb back to learn the knowledge before, reflect on their own learning methods, rather than blindly forward. As if to explain to the disciple at the same time, I also study, also thinking. It seems that we are very powerful, and built a lot of databases, tables, SQL statements and additions and deletions to the more familiar with almost no error. But at the same time, we have to reflect on their own learning methods, can not put the previous knowledge of the net dropped, otherwise learned things can still only be a small piece of a small piece, not even up, after all, can not long.
About the database summary, not much to say, we directly look at the picture bar.
Soft Test (4)--database
