A unit to develop a worker medical management information system, including; Reservation, registration, query and printing, etc, when the worker to make an appointment to fill out the job number, name, gender, units, marital status, age, make an appointment to check time and phone number, and report information including reporting unit name, name, unit, the inspection time, reporting time and test results, test results contains a number of check items, each item information including the project code, project name, as a result, the minimum reference and reference to draw the entity relationship diagram (1), (2) according to the entity relationship diagram given the corresponding relationship model, my answer below, "the worker physical examination management system" can be used as an entity? If you can relationship model of how to write it? If you can't that should use what entities?

CodePudding user response:

Check the item that the entity's primary key should not be "project code", should add a primary key "check the item number,"

CodePudding user response:

Should be the worker to make an appointment a medical, physical examination as an entity, and then physical examination to generate report,