Earthquake Administration Project System Architecture (2)

xiaoxiao2021-03-06  132

Database modeling

Summary: Business Analysis and Database Modeling

Modelor: Harbin University of Technology 01-9 Su Xianhua

Time: 2004-8-10

The establishment of database tables (Summary):

1: Article character table

Table name: 1_WZ

Number text

Note: When the text is empty, it indicates that the necessary text has not been inserted.

2: Table table

Each table corresponds to a table 1:

Table 1:

Table name: 1_bg_1 Credit area, population statistics

Place name land area cultivated land area total population and agricultural total production value local fiscal revenue

The name rules of the table name are as follows:

The first character indicates that the table belongs to the first few projects.

The above information is entered by the user:

*********************************************************** *******************************

Place name: land area: cultivated land area: total population:

Industrial and agricultural output value: local fiscal revenue:

Submit a new record

*********************************************************** *******************************

Table 2: Number of homes, population statistics

Table name: 1_bg_2

City and county name number population countless intensity area Baotou 5755 21053` VII Zone total

The above information is entered by the user:

*********************************************************** *******************************

Market Name: Number of households: population: intensity area:

Submit a new record

*********************************************************** *******************************

Table 3: Seismic casualties are homeless

Table name: 1_bg_3, homeless statistics

The number of deaths in the unit is seriously injured.

The above information is entered by the user:

*********************************************************** *******************************

Unit: Number of deaths: serious injury: Number of slims:

Submit a new record

*********************************************************** *******************************

(1) Household residence area

(2) Population of the account

(3) All destroyed area of ​​all living housing buildings

(4) All serious destruction area of ​​all living housing buildings

(5) Mid-destruction area of ​​all living housing buildings

(6) Number of deaths

Homeless number = {[(3) (4) (5) / 2] / (1)} * (2) --- (6) Table 4: Number of various housing damage surveys and sampling number

Table name: 1_bg_4, number of surveys and sampling rates of various housing in the disaster area

Total structure type Civil brick brick-blended industrial production room

The above information is entered by the user:

*********************************************************** *******************************

There is a house area: civil condition: brick: brick mix:

Industrial production room:

Submit a new record

*********************************************************** *******************************

Table 5: Number of vibration surveys and sampling of various types of houses in the disaster area

Sampling location intensity zone structure type Destroy severe damage medium destruction slight damage Basic Nearby Village III Division Civil 2348 2342 3422 249 23

The above information is entered by the user:

*********************************************************** *******************************

Sampling location: Structure type: destruction: serious damage:

Mild destruction: Basic intact

Submit a new record

*********************************************************** *******************************

Table 6: Different structural housing destruction ratio

Structural type intensity destruction is seriously destroyed medium and destruction slight damage Basic Tortow V34.23 23.2 21.3 4.45 5.24

The above information is calculated by calculating other tables. Of course, you can do not need this table, directly calculate the presence word document

Table 9: Evaluation of Indoor Property Loss in the Disaster Prevention Area

Area name resident public building livestock

Table 10:

The rest of the table details

3: Public support table

1: intensity area

2: Structural type table

3: No rule character table

Example:

Say district destruction level building structure

III degree destroyed the civil

IV area severely destroyed brick structure

V degree area destroyed brick-mixed structure

VI degree mild destroying industrial production room

VII is basically intact

VIII Zone

转载请注明原文地址:https://www.9cbs.com/read-125713.html

New Post(0)