Subject laboratory equipment management system
A, the experiment purpose
1. Review the previously studied in the experiments of PB and used knowledge
2. The use of learned knowledge of the equipment management system
Two, equipment management system requirements and brief description:
Is the purpose of our study PB in order to write the database management system, the general database management system including data input, modify, delete, query, print and maintenance, and other functions, to code a simple equipment management system, can complete the daily management of computer room equipment of simple and to the various terms and conditions of the query and statistical functions, the system has certain practical significance, through learning to write the management system, can get a general idea of database management contains the content, for later design writing and large database management system to lay a certain foundation,
Three, the requirement of equipment management system:
1 to set up the following structure of the database and append records (basic experimental data for at least 10 or more)
? Equipment information database (main library)
Serial number: equipment serial number (4) such as: 0001
Equipment number: card number (8), such as: 20021218
Device name: (30) such as microcomputer
Specification: such as: PII500/64 m/g/10...
Units: (2) sets//...
Purchase price: (digital)
Quantity: (digital)
Date of purchase: such as: on December 5, 1998,
State of use: use/not used/scrap
Equipment is located, such as: computer room/accounting computerization/home office
Some other additional students can design the database (such as equipment place unit table)
2, the function description: (menu below)
Routine maintenance information information query statistics
Equipment purchased by number of serial number query equipment according to the local statistical work unit to maintain
Modify equipment information according to the device number query statistics according to time purchase amount
Delete the device information by name query devices by using state statistics
Exit according to the location query equipment
According to the time the query to buy detail
Detail is as follows:
? Equipment purchase: when buying equipment, increase in equipment information table records, fill in the specific items, save,
? Modify equipment information: first of all, according to the conditions query need to modify the equipment, and modify the corresponding item
? Delete the device information: will be deleted from the database without equipment
? According to the requirements of serial number query equipment: input serial number query out the equipment detail
? According to the requirements of equipment number query: input device number query out the equipment detail
? According to the requirements of name lookup equipment: input device name query out the equipment detail
? According to the requirements of local query equipment: input device seat number query out all equipment that
? According to the requirements of query time buying detail: input the start and stop times query out all purchased equipment detail
? Press local statistical equipment number: enter the location number, statistics out the area on the number of devices (such as a room there are a few devices)
? According to the requirements of statistical amount to buy time: input the start and stop times, statistics during the period of purchase amount
? By using a state statistical equipment: such as statistics, how many equipment is scrapped
? Place unit maintenance: increase in unit or remove unused
? Quit, quit this set of system
Four, the reference interface
1, the login window
2, modify user password window
3, new, modified equipment/according to various conditions query window
4, according to various conditions equipment
5, equipment place unit table maintenance
CodePudding user response:
A student?I'm doing it, learn it, the skill is no burden more...
There was a problem Posting on the jar.
CodePudding user response:
Really have so busy?CodePudding user response:
You are too lazy, you lazyCodePudding user response:
Thank you for teaching but will useHelp!
CodePudding user response:
Seems quite simple, do yourself, that is a week will be able to deal with,CodePudding user response:
I haven't learned to 0CodePudding user response:
Lz can really learn myself!CodePudding user response:
Such a simple even for someone?CodePudding user response:
Money can't buy knowledge, only their efforts to learn knowledge, don't waste good youthCodePudding user response:
Ha ha, best according to example yourself write about, or find a ready-made source to learn and pick up pointsCodePudding user response:
Existing a drill equipment management code, if you need can be sent to you, for your reference,Code for free, hehe
CodePudding user response:
The school also learn PB now?CodePudding user response: