Data room charging system-Database Design Specification

Source: Internet
Author: User

GB8567--88

Database Design Specification



1 Introduction

High-quality databases play an important role in big data processing programs or systems. Therefore, there are many requirements and regulations for database design. First, the database must have good maintainability and flexibility, and the database algorithm logic must also be optimized, so that resources can be effectively used and data processing time can be shortened.

1.1 Writing Purpose

As there are more and more computers and more computer data are generated, the original storage methods cannot meet the needs of data storage. Therefore, databases are used to store various records. In addition, databases can save a lot of resources, such as manpower, time, and space.

The intended readers of the Database Design Manual are designers and developers.

1.2 Background

Database Name: change_sys

System name: Data room Charging System

System Project Task Author: Professor mi Xinjiang

User: all teachers and students of Langfang Normal University

The computing station (center) for installing the software and the database: Library Reading Room, school data room

1.3 Glossary

The data dictionary uses the following format:

01. database design materials

02. Stored SQL Program

03. User Permissions

04. User Name

05. User statistics

06. Column Default Value

07. Integrity of constraints

08. permissions granted to users and Roles

 

1.4 references

List related references:

Requirement design specification-Xu lingbo

Summary design specification-Xu lingbo

1.5 selected Database Management System

SQL sever20008

1.6 database security and confidentiality

The login database has a Windows identity and SQL sever identity authentication. Generally, the SQL sever identity authentication is selected, and its login has a password verification, so the security can be ensured.

1.7 database backup and recovery

The Database supports data backup and data recovery.

2. Detailed Database Design

Note: This section describes how database design meets user needs in the real world. It is an entity-level design.

2.1 requirement analysis 2.1.1 system function Diagram

System Functions

Average user

Operator

Administrator

Query balance

View Machine Records

Query recharge records

Query computer statistics

Change Password

Exit

Register

 

Recharge

 

Card return

 

Checkout

 

 

Add basic data

 

 

 

2.1.2 system flowchart

 

2.2 Database concept design 2.2.1 database E-R Design

 

2.2.2 description of E-R Design Drawing

Database E-R entity table

Entity name

Entity description

Administrator

With the highest administrative permissions, You can query the work records of all users. The administrator sets basic data and bills the computer bills every week.

Operator

Register the operator on the machine to manage the machine records of general users.

Average user

Swipe the card to go to and from the machine, query machine records, and view statistics.

Work records

Record user's machine records

Bill

Records users' On-machine consumption records

2.3 database Logic Design

 

 

 

Average user

Operator

Administrator

Basicdata

Basic data table

 

 

Cancelcar

Card return table

 

 

Checkday

Daily checkout table

 

 

Checkweek

Weekly checkout table

 

 

Line-info

Computer record table

 

 

Onwork-info

Instructor on duty Worksheet

 

 

Recharge-info

Recharge record table

 

 

Student-info

Student Information Registration Form

 

 

User-info

User information table

Worklog-info

Work log table

 

 

2.4 Physical Structure Design

Basicdata table:

Canclecard table:

Checkweek table:

Line-info table:

Onwork-info table:


Recharge-info table:

Student-info table ::

Checkday table:

 

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.