medical store management system project with schema diagram

An object with conceptual existence (e.g., a course, a job, a position)Įntities can be classified based on their strength.

An object with physical existence (e.g., a lecturer, a student, a car).

Each dependent has a name, birthdate and relationship with the employee.Īn entity is an object in the real world with an independent existence that can be differentiated from other objects.

We want to keep track of the dependents for each employee.

We also need to know the direct supervisor of each employee. We need to record the start date of the employee in each project. An employee is assigned to one department but can join in several projects.

Each employee has a name, identification number, address, salary and birthdate.

A department controls a number of projects, each of which has a unique name, a unique number and a budget.

Each department has a unique identification, a name, location of the office and a particular employee who manages the department.

There are several departments in the company.

This database contains information about employees, departments and projects. Ba (entity) teaches (relationship) the Database Systems course (entity).įor the rest of this chapter, we will use a sample database called the COMPANY database to illustrate the concepts of the ER model.

Here is an example of how these two concepts might be combined in an ER data model: Prof. Relationships, defined as the associations or interactions between entities.Entities , defined as tables that hold specific information (data).ER models are readily translated to relations. ER models, also called an ER schema, are represented by ER diagrams.

It is well suited to data modelling for use with databases because it is fairly abstract and is easy to discuss and explain. The entity relationship (ER) data model has existed for over 35 years.

Chapter 8 The Entity Relationship Data Model

Medical store management system project with schema diagram