Database design of computer room reconfiguration

The design of the database is the first thing in this phase, and the result of the requirement analysis relative to the design of the database is to start with the ER diagram of the conceptual design of the database, and the summary of the database in the previous time is also useful in this stage. Overall, about the design of the database, in the machine room reconfiguration, I separated the user, students and system three entities, and for these three entities, according to their attributes and relations analysis, divided nine table. In this database design in the process, altogether drew three separate ER diagram, finally consolidated them, formed this total ER diagram, but about the user's classification: The general user, the administrator and the operator, did not list in the ER diagram, but uses the user type field instead. It has been a long time since not so seriously drawing, if there are any flaws, welcome everyone enthusiastically pointed out, not very grateful.

Database design of computer room reconfiguration