How do you feel after learning the database? The following is the "Summary of Database Course Work" compiled by me for you. You are welcome to read it, for your reference only, and I hope it will help you. Summary of database course work (1)

Evaluation of the software and implementation technology used in the experiment process and summary of some problems encountered in the experiment process:

This experiment was completed on the platform of windows operating system, and database table building, triggering, deleting and inserting were applied; Powerdesigner realizes the transformation of conceptual model and physical model of database; GUI graphical user interface, jdbc and other technologies in java language. The task assigned by the teacher was well completed within the specified time. Although many problems were encountered during the experiment, the problems were finally solved through mutual discussion with peers, borrowing materials and consulting teachers. Generally speaking, programming techniques such as sensory database, powerdesigner and java language object-oriented are flexible and easy to understand. The short two-week course design made me interested in programming techniques such as java language, and more importantly, enhanced my self-confidence in learning.

Analysis and evaluation of the allocation time of software development guided by the teacher during the two-week course design

In the first stage: 21xx.1.2-21xx.1.6

The topic we did was "Small Catering Management System". According to the teacher's arrangement, we first designed the system requirements and system functions. After determining what functions we should have in the small catering management system, we exported the physical model (ER diagram) of the database by powerdesigner, and further used the powerful functions of powerdesigner to generate the physical model diagram and database from the ER diagram, thus completing the database design stage. In the next few days, we mainly focus on the debugging of the application and the writing of the course design report.

Personal responsibility

1. Discuss and analyze the demand analysis part of the project (small catering management system) with the team members, and * * * complete the design of the demand part.

2. Find the required information through the Internet, books, etc.

3. Write the database part (including the creation of database, table, trigger, index, stored procedure, etc.) and complete the design transformation part of ER diagram and physical model diagram.

Experience and lessons

When the experiment was demonstrated to the teacher, I felt that I had done a good job, and I was praised and praised by the teacher. Unexpectedly, a series of questions put forward by the teacher after reading our demonstration made us dumbfounded for a while. After listening to the teacher's explanation, I found that the system we made was simply a waste product, and no manufacturer was willing to use our things, even if they were given away for free. Compared with the actual Food and Beverage Management System, the biggest deficiency of our system lies in the following two aspects:

1. When customers order food, they don't take into account the problem of bin between storekeepers and households, and set relevant passwords, which leads to disorganized and disorganized ordering, which is inconvenient for hotel management and will seriously lead to the loss of the store.

2. Lack of the design of the performance appraisal link for staff.

Through this lesson, I believe that in the future study and practice, I will definitely treat every link in the experiment more seriously, especially the basic stage at the beginning. The process of learning and growing up is just like building a high-rise building. It is very important to lay a good foundation, because it is related to the stability and safety of the whole floor. I firmly believe that in the process of long-term study in the future, I will pay more attention to cultivating rigorous thinking, paying attention to details, trying to make a good start in everything, being down-to-earth, step by step, and being neither arrogant nor impetuous.

Experience:

It's the first time for me to come into contact with such a large project. Through this course design, I deeply realized the importance of cooperation and practice.

First, during the experiment, I learned and operated on the computer at the same time, only to find that I didn't know too much, and my former self was too small, so I need to keep growing in my study. At the same time, I deeply realized that I need to work hard to improve my hands-on operation.

Second, I remember that teachers and seniors always taught us to learn to cooperate with others, and told us that it is particularly important to cooperate when we get out of society. Before that, I was a little disapproving and believed in myself too much. Through this two-week course design, I firmly believe in the words of teachers and seniors. Without the help of my peers, this experiment can't be completed by myself in two weeks. During the experiment, we work together, urge each other and discuss. Finally, I finished the task well and learned a lot from it. I firmly believe that I will pay more attention to cooperation and mutual assistance with others in the process of future study and growth. Summary of database course work (2)

I made two relatively large projects with my boss, and I designed the main body of the database. The first feeling is a failure; The second one is being used now. Although I have summarized the lessons of the first one, I still feel a little sorry. Write down some experiences in this process here for future reference. If there is a chance to design the database again in the future-there are still some expectations and new experiences, which are all added here.

1. Try to use data redundancy

With the sharp increase of disk capacity, this will not cause any problems. Of course, redundancy belongs to redundancy, and the association of data can't be messed up.

If the knowledge learned in the undergraduate database course is directly taken, there will be big problems in practice. A database structure that meets the three-level paradigm will make you face a large number of linked table queries, and a large number of database accesses will be used in the application, which is cumbersome and slows down the running speed of the program.

2. Try not to use the varchar(max) type

This is mainly because when using the dynamic and soft code generator to automatically generate code, if the maximum length of varchar is specified as max, it cannot generate this maximum length when automatically generating code, and it needs to be manually added.

now I feel that using a varchar(1111) is enough.

3. Use reserved fields

Database tables (especially dynamic tables). After you have designed all the fields, add a few remarks fields and reserved fields.

I didn't think it was meaningful to do this before, because it was meaningless to reserve column names of fields. This will be confusing when used in the program. But now I think it is necessary, very necessary, even if I need to know exactly what the meaningless fields reserved before mean now when I use them. However, it is still not used in my second database, which is also a pity.

personally, it is enough to use note1, note2, r1(r stands for reserve), r2, r3, two remarks fields and three reserved fields. If there are more, it will be difficult to remember which field specifically means what, and it will be easy to get dizzy. Just use varchar(211) for all types.

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 this course design, we can consolidate our understanding of the basic principles and theories of database, master the basic methods of database application system design and development, 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 a handwritten program. Instead, we will discuss the system overview, system objectives, system requirements, business process analysis, data process analysis and data dictionary together. When all these are ready, we will divide the modules. Everyone has their own module design, and the written code requires that the function of the corresponding module can be realized and the ideal effect can be obtained. When everyone completes their own division of labor, one person will finally put all these combinations together. We use html and php nested 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 restore of the database and the implementation 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 programming language that I just came into contact with. However, 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 restore. 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 where I gain 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.

There is no end to the acquisition of knowledge. As long as you want to learn, as long as you act, nothing will overwhelm us. Looking back on the course design for more than a week, I am very pleased. Because I have the motivation and courage. Thank you, teacher, for your tireless help, thank you for giving us this opportunity to practice, and thank you for your concern. These beautiful memories and beautiful things will always be with me.

I recommend it carefully.