Question

You are a Manger of nurses at Green Apple healthcare and today is your fist day. Your predecessor was preparing nurse rosters manually and keeping them in her office and at every end of the month she was taking two whole days off to finishing all the nurses’ earnings and their next month’s schedule.

Now, it is a good time to prepare your proposal to your boss because the hospital recently purchased a new enterprise system and external design group working with all departments with their needs.

Create a ERD diagram for SQL

Answer 1

An Entity can be a ny object ,person,place or class , in ER diagram an entity is represented using rectagles ,consider an example of an emploee,manager,,organization or department product and any other thing taken as entities in an organization.it is a picture of data strecture,an entity relationship diagra shows entities in a database shows relationship between tables within that database, far a good database design it is essential to have an entity relationship diagram.