The topic of my course design of database system principle is XingBin.net book sales system. The reasons for choosing this topic are: this system is very common in real life, and it is easy to get its design requirements; At the same time, it is not in the reference topic provided by the teacher, which can not only reflect innovation, but also avoid the design similarity with other students.

The book sales system can provide bookstores with integrated solutions including book cataloging, purchase and return, sales and financial statements. At the same time, it also provides membership discount function, online membership system in BS mode and so on.

Second, the business needs

Book retail purchase: after the customer has bought the book, the cashier checks out. For members of the bookstore, you can provide corresponding discounts. Enter the number of books to be purchased, calculate the total amount, and users can choose to use cash or membership card to settle accounts. And provide the serial number of the sales receipt as the sales document. For members, the corresponding points should be calculated.

Book retail return: customers return the books they bought. Books and sales receipts are required as proof of purchase. The system queries the database for data verification and returns books that meet the requirements.

Cataloging of new books: Bookstores catalog new books here after purchasing them from publishing houses. Only catalogued books can be sold.

Book search: You can use ISBN, title and publishing house to find cataloged books.

Book modification: modify the basic information, retail price and minimum discount price of cataloged books.

Book purchase: replenish cataloged books and deal with the difference in amount.

Book return: return cataloged books and handle the difference in amount.

Publishing house management: adding, deleting and modifying publishing houses. At the same time, check the information of the publishing house.

Member addition: add new members, and register basic information, validity period, designated member groups, etc.

Member search: provides a composite query of member number, ID number and member name.

Member Delete: Delete an existing member.

Member information modification: modify the basic information of members.

Member recharge: recharge the member's virtual account.

Loss reporting and special handling: adjust the member status between normal, loss reporting and special handling. You can also retrieve the member's password.

Member group management: add, delete and list member groups. You can set the name, discount and integral conversion of the member group.

System Settings: Add, delete and modify system operators, and set their control rights to the corresponding operators.

Password modification: modify the password of the current system operator.

Data management: provide backup and recovery of system database.

Report processing: provide reports such as book sales list, book purchase list, member list, publishing house list and sales list.

Third, the design objectives

The user characteristics of the software are users with basic Windows operating level, and the user's operating habits should be taken into account when designing, so multiple shortcut keys should be defined and the interface should be as friendly as possible.

For the Web interface, it should be as simple as possible to facilitate users to log in and query.

Fourth, the business environment.

Server configuration

Operating system: Microsoft Windows Server 2003 or other server versions are recommended.

Database server: Microsoft SQL Server 2000 Enterprise Edition

Web server: IIS 6 or higher

. Net platform:. Net framework edition.

Client configuration

Operating system: Microsoft Windows 2000 or higher is recommended.

Database client: Microsoft SQL Server 2000 client.

. Net platform:. Net framework edition.

Input devices: keyboard, mouse and barcode scanner.

Verb (abbreviation of verb) demonstration example

Overall functional block diagram

Book sale

Book and publishing house management

Member management

Report management

Online Bookstore in Browser Mode

user management

Book sales system

Ending of intransitive verbs

The database course design was successfully completed this time. Because I consulted some books in advance during the summer vacation and made similar designs before, I didn't encounter great difficulties.

In the course design of C language, I completed the program of educational administration information management system, from which I learned the underlying structure of data storage. But this kind of data is limited. In today's information age, we must use the database server to solve the problem of data storage. And how to combine the program with the database server is the focus of my design this time.

Because I have done some development with C++ before, in order to learn more programming languages while learning the database, I boldly used it. Net as a development tool and C# as a programming language to program this time. At first I thought it was not much different from C++, but later I found it was still different. Because there is a good foundation of C language, it is easy to convert between them.

But I still checked some information when I connected to the database. The connection of the database does not use the traditional ADO, nor does it use the SqlCommand automatically generated by DataGrid, but is completely completed by SqlConnection. All SQL commands are spelled by hand using SqlCommand, so the programming is more flexible.

In order to understand the work of the database, I boldly used multiple stored procedures and triggers. Through them, the development part of the program can be simplified, and a complete transaction can be formed at the database side, thus realizing the ACDI characteristics of the transaction. So as to realize the concurrent operation of multiple clients.

Through this course design, I have a further understanding of the working principle of database and the connection method between program and database. I am also familiar with the design process of software engineering and learn to use the specifications of software engineering to demand myself. At the same time, I also learned C# language and exercised my ability in an all-round way.

Here, I would also like to thank my database teacher-Yang Maolin. At the same time, I would like to thank my friends who care about my program and give me help and advice. thank you