symbol
April 15
Until/very
Be ready on April 20th.
April 2 1 to
May 10, the investigation process is good.
May 1 1
Until/very
Recruitment began on May 30th, and the production was good.
May 3 1
Until/very
June 10 was well modified.
Teachers' overall evaluation of the implementation of the progress plan
symbol
date month year
This table is one of the bases for evaluating students' usual grades.
catalogue
The first chapter is a mistake! Bookmark is not defined.
1) the first section studies the tens of thousands of books in the history library.
2) Each book has its title, book number, author (translator), publishing house, pricing and content introduction.
3) The library card records the borrower's name, work unit, address, contact number, etc.
4) Borrow books with a library card. You can borrow up to 5 books at a time, and the longest borrowing period is 60 days.
Second section ...
1) Registration of books borrowed and returned by the library. That is to establish a ledger for readers. With this account book, the staff can easily grasp which books readers have borrowed and how long they have borrowed them.
2) Write a book return notice. The library limits the maximum borrowing time of books to 60 days, and reminds overdue readers to urge them to return books as soon as possible to speed up the circulation of books.
3) Provide a quick book query function to facilitate readers to insert the books they need as soon as possible.
4) All functions provided by the system should be simple, intuitive and practical.
third segment ...
1) Book borrowing. Register readers with library cards, including library card number, book number and borrowing date.
2) Return of books. Register in the right place, depending on the library card number and book number.
3) Prepare the book return notice. Print a book borrowing reminder notice for readers who have borrowed books for more than 60 days, including library card number, reader's name, telephone number, book number, name, author, publishing house, borrowing date and other information.
4) Handle and return the library card. This system only supports two processes of issuing (handling) and recovering (returning) library cards.
5) Booking warehousing forecast waste. The warehousing registration of newly purchased books and the scrapping registration of old books. New books are put into storage in two different situations: first, the newly purchased books have been registered before, and this time they belong to supplementary inventory;
Secondly, the library has not been registered before.
chapter two ...
Code:
/* Library Management System Database
Create database tsgl
During the primary election
(
Name = library management,
filename = 'D:\data\tsgl.mdf '，
size = 10，
Maxsize = unlimited,
File growth = 10%
)
log in
(
Name = library management,
filename = 'D:\data\tsgl.ldf '，
Size = 2,
Maxsize = unlimited,
File growth = 2%
)
*/
/* Book Lending Registration Form
Using tsgl
go to
Create table jszdjb
(
jszbh char(8)，
tsbh char(8)，
Jyrq date and time,
Ghrq date and time
)
*/
/* Book Type Table
Using tsgl
go to
Create table tslx
(
Tslb character (8)
)
*/
/* Library card issuance grade table
Using tsgl
go to
Create a table reader
(
jszbh char(8)，
dzxm char(8)，
gzdw char(30)、
dhhm char( 1 1)，
jtzz char(20)，
Bzrq date and time,
Tzrq date and time
)
*/
/* Book Rating Table
Using tsgl
go to
Create table tsdj
(
tsbh char(8)，
TSMC charger (30),
zz char(8)，
cbs char(30)，
Tslb charger (8),
Tsjg money,
kcsl int，
zksl int
)
*/
/* Reader information
Using tsgl
go to
Create a table reader
(
jszbh char(8)，
The gender character (2) defaults to "male",
snum char( 10)
)
*/
/* Information for male readers.
Using tsgl
go to
Create view rsex
be like
Select *
From readermes
Where readermes.sex =' male'
*/
/*
Create trigger insert_r
On the reader
Used to insert
be like
begin
declare @jszbh char(8)，
select @jszbh count(*)，
Join from an inserted reader
on reader.jszbh = inserted.jszbh
end
*/
abstract
Any social organization and enterprise company will produce a lot of data in the process of development. The organization, storage, analysis and statistics of these data are conducive to improving the development and efficiency of enterprises. The organization and storage of these data is not only the data model, but also the task of database application system development.
The development process of database application system generally includes six stages: feasibility study, requirement analysis, system design, program coding, program debugging and system maintenance. According to the complexity of the database application system, the above steps may not be strictly followed, but feasibility study, demand analysis, system design, program coding and program debugging are essential.
This course has designed and produced a simple book management system, which has realized some functions of book management and borrowing, but there is still a big gap with the actual system. First, the application situation is simple and idealized, which is difficult to reflect the practical problems that may be encountered in practical work; Secondly, the handling of possible errors in user operations is not considered, but in fact such error handlers may account for a large part of the application system. If this system has some problems in requirements analysis and program soundness, in order to solve these imperfections, it is necessary to gradually deepen and accumulate experience in further study in the future, which is not only to improve.
refer to
[1] Sashixuan, Susan Wang, Introduction to Database System, Higher Education Press, 3rd Edition, 2000-2.
[2] Zhu Rulong "SQL Server 2000 Database Application System Development Technology" Beijing: Machinery Industry Press, 2007- 1
[3] Zhu Rulong's "Experimental Guidance of SQL Server 2000 Database Application System Development Technology" Beijing: Machinery Industry Press.
[4] Huang Tieyun "Management Information System" Beijing: Higher Education Press, 2005-3 Third Edition.
[5] Wei Yongji "SQL SERVER 2000 Application Development" Beijing: Machinery Industry Press, 2007-2.
[8] Wang Yiping "Database Application Technology" Beijing: People's Posts and Telecommunications Publishing House, 2005- 12.