Are you sure you want to tell me the opposite?

The word can't be used without learning. Therefore, to achieve the opposite, we must have a profound understanding of the relationship between learning and application, or at least understand how to spread and sublimate what we have learned.

I writeArticleI did not attack our education, but I found that after we received such education for a few years, it seemed that we had no idea about the opposite.

Yesterday, a university student in Australia asked me a database question on MSN (the Australian university has been in school for a month now, not in the United States. I am studying it now). I said that this is their job. I gave a scenario, called drawing an ergraph and designing the table structure of the database.

I will describe the scenario. Based on a hospital, a patient can call the receptionist, make an appointment for a diagnosis, determine the doctor, time, and so on, and register a copy of the materials, the material is the patient's personal information. The scenario is like this. The ERTU still draws entities, attributes, and links. The design table structure is based on the ERTU.

At that time, I was dumpfounded when I saw this scene. I thought it was really troublesome. What should I do? bt is really a foreigner, so it's hard for students to come up with such a question, no wonder my classmate asked me. Then we did the research on MSN, and we didn't get it out for more than ten minutes. At that time, I suddenly remembered that the course design of database in my sophomore year was based on the student course selection system. I compared it with this scenario.

Hospitals are schools -- receptionists are course selection systems -- patients are students -- doctors are teachers. This comparison is really appropriate for a large public hospital, because doctors in large hospitals are waiting for patients to go, rather than the type of private doctors going to the patient's home to see a doctor (private doctors can be compared to family teachers ...). I remember very clearly that when we designed this course selection system, we, more specifically, designed several tables for us:
1. Student table, primary key student ID, that is, id. The attribute is the student information.
2. In the instructor table, the primary key instructor number, that is, id. The attribute is the instructor information.
3. Curriculum, primary key course number, that is, ID, foreign key instructor ID, attribute is class time, classroom, etc.
4. In the course selection table, the primary key is the student ID and course Id, the attribute is the test score, and whether the student ID is passed.
In this way, the table is clearly designed. I remember it was 3nf, but I still cannot remember it clearly. In this case, the system corresponding to the hospital should be like this:
1. Patient table, primary key patient id, attribute is registration information
2. Doctor table, primary key doctor Id, attribute is Doctor Information
3. Diagnosis schedule table. The primary key is ID, the foreign key doctor ID, and the attribute is the visiting time and department location.
4. In the appointment Table, the primary key is the patient id plus the diagnosis schedule ID, and the attribute is the diagnosis result and prescription.
Although the third diagnosis arrangement is not as smooth as the course said, it is a little far-fetched, but after repeated comparisons, I think this is really understandable, the two systems are very similar.

I told my classmates what I thought. He also agreed to do so, but he didn't know if he would agree to submit his homework to the teacher...

Speaking of this, I would like to mention that when I first studied databases, the examples in the book were schools, departments, teachers, and students, or bosses and employees. When I waited for homework and exams, still in school, department, teacher, student ...... After learning the exam, I really learned what I used. Then we remembered it in our mind: Oh, when we saw this situation, we designed the table and how we did it. It would be dumb to change the style.

On the other hand, I think we have been studying in college for four years and almost all of them are low-performing. Why? First, the class has escaped to bed; second, the teacher knows that you are not good at learning, so no one is willing to teach well; third, the teacher does not necessarily want to teach well; fourth, if optics are not used in practice, how can we put it together? Fifth, haha, is there another fifth? I don't know...
In addition, to a large extent, I really think that university textbooks are not as good as textbooks in the middle school era. I think this is also normal. I use one set of Middle School Textbooks nationwide, how many generations have they been honed. college textbooks are used in almost one university, and printing errors are everywhere. It is not normal to make the textbooks properly.

Let me take a look at the future and exercise well. I hope that my thinking will not become rigid and that will not be good.