Attribute star principle

The functional structure of the front desk is shown in Figure 2:

Front desk functional structure

The background function structure is shown in Figure 3:

Background function module

2. 1.4 system database design

This system uses Access database named db_wygl, which contains 8 tables.

Registration information table tb_zhuce

Website announcement table tb _ announcement

Resident parking information table tb_homePark

Family arrears information table tb_qianfei

Owner complaint information table tb_tousu

Equipment maintenance information table tb _ Hu Wei

System news information table tb_xinwe

Registration information table tb_zhuce

Family information table tb_zhuhu

E-R diagram corresponding to each table

The registration information entity is shown in Figure 4.

Fig. 4 E-R diagram of registered information entity

The entity diagram of website announcement information is shown in Figure 5:

Figure 5 Website Announcement Information Entity E-R

7 parking information entity schematic diagram as shown in figure 6:

Fig. 6 E-R diagram of parking information entity

The entity diagram of arrears information is shown in Figure 7:

-R graph

Figure 7 E-R diagram of arrears information entity

The entity diagram of complaint information is shown in Figure 8.

Figure 8 Complaint Information Entity Figure 8 E-R

The maintenance information entity diagram is shown in Figure 9;

Fig. 9 E-R diagram of maintenance information entity

The entity diagram of news information is as shown in figure 10:

Figure 10 E-R diagram of news information entity

The entity diagram of family information is shown in figure 1 1.

Figure 1 1 E-R diagram of family information entity

2.2 Logical model analysis and design of registration information table

2.2. 1 Registration Information Form: tb_zhuce

Primary key: username name

Table 2. 1 Registration Information Table

Description of whether the column name data type width is empty.

The name text 10 has no user name.

Pwd text 20No no user password.

Gender Text 5 No user gender

Date/Time of Birth No date of birth.

Age Text 5 No Age

Hunyin text 10 has no marital status.

Card text 20 has no ID number.

Telephone text 10 is a telephone.

Shicheng Text 10 is a city.

Address text 20 is the home address.

The email text 20 is an email address.

Wu Zhi text 10 is the work type.

Zhu Bei's remarks have no remarks.

2. 1 Registration Information Form

2.2.2 Family Information Table tb_zhuhu

Primary Key: RoomNo. Fang Hao

Table 2.2 Registration Information Table

Description of whether the column name data type width is empty.

The name text 10 has no cell name.

Lyname text 20No has no building name.

Lydy text 20No no building unit

Fang Hao Wen Zi 10 No room number

Room type text 10 is the room type.

Jzmj text 10 has no building area.

Property right status of cqstata text 20No

FWBeiZhu remarks Yes House remarks

Usage of systata text 10

Zfname text 20 No house name

Qrtime date/time has no move-out time.

Zfname text 20Yes residential name

ID text 20 has no ID number

The working text 20 is the unit of work.

Lxtel text 10 has no contact number.

Address text 20 No contact address

2.2.3 system news information table tb_xinwen

Primary key: news title

Table 2.3 System News Information Table

Description of whether the column name data type width is empty.

The headline text 20 has no news headlines.

Neirong's remarks have no news content.

Release Date/Time No release time.

Faburen Text 10 has no publisher.

Xinwenleibie Text 10 yes news category

Popularity index 50 unpopularity index

Zhu Bei's comments have no status.

2.2.4 Equipment Maintenance Information Table tb _ Hu Wei

Primary key: maintenance equipment number id

Table 2.4 Equipment Maintenance Information Table

Description of whether the column name data type width is empty.

Id text 20 No equipment maintenance number

Nname text 10 has no household name.

Time Date/Time has no start date

Time period/time 10 has no end date.

Personnel text 10 No handler

Fei Yong Text 50 No service charge.

Stata text is stateless

Zhu Bei's comments are comments.

There is no maintenance content in the remarks of Neirong.

2.2.5 Owner Complaint Information Table tb_tousu

Primary key: complaint number id

Table 2.5 Owner Complaint Information Table

Description of whether the column name data type width is empty.

Id text 20 No complaint number

Person text 10 No complaints are household names.

Time Date/Time No Complaint Date

Neirong's remarks are complaints.

Zhuangtai Text 10 has no complaint status.

2.2.6 Household Arrears Information Table tb_qianfei

Primary key: the name of the defaulting family

Table 2.6 Household Arrears Information Table

Description of whether the column name data type width is empty.

Name text 10 No account name in arrears.

Address text 20 Home address without arrears

Lei Biwen 10 has no arrears type.

Time Date/Time No Arrears Start Time

Etime Date/Time No Arrears End Time

Qian Feiwen 10o amount owed

Stata text 10 has no arrears status.

Personnel text 10 No handler

2.2.7 Household Parking Information Table tb_homePark

Primary key: license plate number ID

Table 2.7 Household Parking Information Table

Description of whether the column name data type width is empty.

Id text 10 has no license plate number.

PlaceID text 10 has no parking number.

Leased house text 10 has no owner

Address text 20 No parking space

The start date/time has no start time.

End Date Date/Time has no end time.

PlaceSum text 10 no parking management fee.

Personnel text 10 No handler

No parking fee for processing text 10.

Memo notes are notes.

2.2.8 Website Announcement Table tb _ Announcement

Primary key: announcement number ID

Table 2.8 Website Announcement Information Table

Description of whether the column name data type width is empty.

Id automatic numbering without announcement number

Title text 20 has no announcement title

Content remarks have no announcement content.

Date, Date and Time No Announcement Release Time

Name text 10 has no publisher.