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