Experience of database principle design (1) In my opinion, the main goal of database course design is to use the database knowledge and technology learned in the course to better develop and design a database application system to meet the requirements of information processing in all walks of life. Through the design of this course, we can consolidate our understanding of the basic principles and theories of database, master the basic methods of designing and developing database application systems, and further improve our ability to comprehensively apply what we have learned.
When our group decided to be a college student employment consulting system, we didn't start the handwriting program. Instead, we will discuss system overview, system objectives, system requirements, business process analysis, data process analysis and data dictionary together. These are all ready, so we will divide them into modules. Everyone has his own module design, and the written code requires that the functions of the corresponding module can be realized and the ideal effect can be obtained. When everyone completes their own division of labor, one will eventually put all these combinations together. We use Html and php to nest with each other. When a system is completed, I will read the program carefully and pay attention to the mystery.
I am responsible for the backup and recovery of the database and the realization of some interfaces. I still remember that when I first came into contact with html, I felt very interested, so I was almost obsessed for a while. However, Php is a new programming language for me. But I think it is really powerful and can develop many large-scale systems. But there are still many things to consider when doing backup and recovery. When I made a mistake, I felt very hit. Thankfully, with the help of my classmates and a lot of reference books, I finished my own module. This is the place where I have gained the most. Moreover, I understand the importance of never giving up when encountering difficulties, I know the importance of teamwork, and I realize that only perseverance can win.
The acquisition of knowledge is endless. As long as you want to learn and act, nothing can overwhelm us. Looking back on the course design for more than a week, I am very pleased. Because I have motivation and courage. Thank you, teacher, for your tireless help, for giving us this opportunity to practice, and for your concern. These beautiful memories and beautiful things will always accompany me.
Experience in database principle design (2) Two weeks passed quickly. I dare not say how much progress I have made and how much knowledge I have learned in these two weeks, but at least I know part of the process of project development. Although I have taken related courses such as database and management information system, I have never experienced the relevant design details personally. This internship certificate provides a good opportunity.
Through this course design, we find that we haven't touched a lot of the knowledge we need. When we went to the library to check the information, we found that what we had learned before was only superficial, and there were many things we didn't know at all. At the same time, we also find that many things we have learned are not understood in place, so we can't apply them flexibly to practice and solve problems well. This requires us to practice a lot, through constant self-study, constantly find problems, think about problems, and then solve them. In this process, we will deeply understand what we have learned and learn a lot of practical things at the same time.
From the reading of various documents to the initial demand analysis, conceptual structure design, logical structure design and physical structure design. I personally experienced the design and development process of the system. Many things are written clearly, seemingly simple and clear. But only when you really need to find a way to design a system will you find the difficulties. I often suddenly find that there is something wrong with my initial design, and then go back to work and constantly improve my ideas in various iterations.
I think I'm not the only one with this problem. In hindsight, I started to do it too rashly, or I didn't know who the system I was going to do was for. Because we didn't do a detailed user survey in advance, we didn't understand the whole business process and didn't know what functions users needed. This is something that designers and developers need to pay special attention to avoid, otherwise it will bring great trouble to the later work, and may even need to be reinvented. Therefore, the future curriculum design should pay special attention to the design of this piece.
According to the demand, what we do is the air ticket reservation system. To tell you the truth, I know nothing about it. I haven't booked a plane ticket, and I don't know how the airline operates. I have tasted the end of blindly starting design, and the result is a four-unlike design scheme, which has no practical use. Without preliminary investigation, it is not enough to start with those requirements in the instructions.
In the process of demand analysis, we look up information on the Internet, go to the library to consult relevant information, combine our own life experience, analyze the existing situation and problems according to the results of feasibility study and the requirements of customers, and adopt the client/server structure to divide the air ticket reservation system into two subsystems: client subsystem and server subsystem. In the past two weeks, I have been constantly modifying, compiling, debugging and running programs and modules. During this period, I encountered many problems: some mistakes were not found when I was debugging because I forgot some specifications of the java language. Through this course design, I am more proficient in debugging and realize the standardization of programming language and that we should have a rigorous attitude when programming. At the same time, if there are a certain amount of comments when writing a program, it will not only increase the readability of the program, but also make me understand the program.
We have studied and applied the sql language, and have a certain understanding of the methods of creating, modifying and deleting the database. We have learned some operations about tables by importing tables, deleting tables and changing tables. To establish a relational database information management system, we must go through the general process of system investigation, demand analysis, conceptual design, logical design, physical design, system debugging, maintenance and system evaluation, so as to lay the foundation for graduation design.
Many things are not as simple as imagined, which involve various entities, attributes, data streams, data processing and so on. Many times, I feel that the design behind me can't continue at all, and I feel that I am limited by all kinds of drawings made in front. When transforming the relational model, some entities can be considered as both entities and attributes. In order to avoid redundancy, we try to deal with it according to attributes.
There is basically no problem in the physical structure design, and some security settings, such as primary key constraints, check constraints, default definitions, etc. , will be added to the physical structure design without achieving security and integrity. In the last part of the index, some columns and foreign keys that are often used in search are indexed, which can obviously speed up the retrieval. Finally, don't forget important security settings, restrict users' access rights, create new users and map them with database users accordingly.
No matter what you do, you should believe in yourself and don't be afraid of encountering difficulties. We need to try everything. After you try something that is difficult at first, you may find that she can't do it herself as you thought before. Without self-confidence, goals and confidence, we can't do things well. When others are confused, you must be firm in your goals. When you graduate from college, you will face the problem of finding a job. From studying this major to working in this field in the future, we need constant study and practice. This practice can give us a wake-up call. We are facing graduation and choosing jobs, and we need these practical experiences. This is the biggest feeling that this course design has given me.
The above is basically the experience of this internship. Design is very difficult, and coding is not easy. It is discovered that the most important thing of a project is not how to realize it, but the requirement analysis and module design before it is realized. It is difficult to innovate, and it is not difficult to realize some popular systems. The difficulty lies in the analysis and accurate positioning of the market. Design is a long and arduous process.
Experience of database principle design (3) The noise of database course design competition is gradually fading away. With a little reluctance to this competition, with the determination to miss the original curriculum design, and with the confidence and fighting spirit accumulated through this curriculum design, I began to write this article, leaving even insignificant but precious traces for myself, looking forward to encouraging you.
First, let me think back to my sophomore summer vacation. Under the guidance of my boss (he suggested that I study ASP(ASP Training) net), I came into contact with Microsoft's net products. At that time, I studied vc and asp, and because the experimental class of windows programming was exposed to VB(VB training), I didn't study him specially. Because I was used to Class and int in c++, I felt that vbsub and var didn't look very satisfied. I am a curious person, and suddenly I saw a man calling ". Net is an ideal and realistic development tool to create the next generation application, and c# is the main language. As I have always liked C language, I became interested in it almost immediately. I started to learn c#, and no language exists in isolation, so data interaction is very important. During the summer vacation, I read an overview of our textbook database system. I remember that when programming in C language, data applied for space in memory, such as using arrays. It consumes a lot of memory space. It's time for the database to come out, so I installed sql server2000. I used to use access when I was studying asp. At that time, I just did what others did, and the theory was not very clear.
What architecture do I want to use when developing, c/s mode? There are many modes, how to choose? I'll go online and search what is the most popular building now. As a result, I found the mvc architecture, and that is you. I decided to use this framework. No, it doesn't matter. Let's learn. Do it! After the preliminary work is done, I will put my summer vacation learning network into practice. At this time, I know more about using ado and net to operate the database. And have a deeper understanding of the stored procedures in the database. After about two weeks' struggle, I finished my database course design-a book management system based on network data sets. In the end, I was honored to win the first prize of the competition and the new technology application award.
Rather than fishing in the forest, it is better to retreat and build a net. The database course design impressed me the most, that is, if you are interested, do it. The difficulty is that you can't hold your head up without courage and perseverance. I have never given up on this database, no matter what difficulties I encountered. Out of thirst for knowledge, out of curiosity about new technologies, out of curiosity about all unknowns. I have finished the design of this database course, but it is only a stop on my learning road. In the next decade, the core technology of net will be xml[ at least that's what Microsoft advertised], and I will continue to learn, including j2ee of jave. i also want to have a try. If the language is the same, just do it! Language is not important. After all, it's just a tool. Using a tool well is not something worth doing. Mainly to understand and study ideas. As the saying goes, there is no end to learning.
In fact, from the learning experience, our knowledge system is still relatively old and traditional. Compared with the rapidly developing IT industry, many situations are no longer applicable, especially when the open source model is gradually approaching developers. Although it is a database course design, because I choose the project from the perspective of practical application value, it also involves some designs outside the database. In a word, the experience of this database design can't be fully expressed in words.