best database design with shared data and multiple application

Question

I am in an Enterprise environment.

I have to design an HRM database (Human Resource Management).

This database must contain information for each employee (ie. Name, Last Name, Company, etc.).

To this database it must be connected to several applications.

Each of these applications performs different functions and manages other data to associate with the HRM database (ie. courses, activities, vehicles, etc.).

Each application is managed by some users.

Each application must have the possibility to create a new "employee record" in the HRM database.

A general scheme is the following:

General scheme

Q: What is the best database design and software architecture to do this?

I would use Laravel as a framework for each application and PostgreSQL as database.

Okay, can you please update your question to describe exactly what you are looking for in your database design? — Ghayel
– Ghayel, Commented Dec 12, 2015 at 10:09

hiropon · Accepted Answer · 2017-05-17 04:53:30Z

0

Q: What is the best database design and software architecture to do this?

I think database design and software architecture depend on the framework, Laravel. At first, I recommend you to read a document: Laravel 4.2 Laravel Quickstart - Eloquent ORM

database design

ORM, it means tables are abstracted by the framework. To represent data models, you should consider about what is required data models (= table).

To design data models, at first you need to check required real world Requirement ( for example, users table must have id, first_name, last_name.)

After that, please check a kind of ActiveRecord pettern from this article: Active record pattern. Because Laravel is based on Ruby on Rails's activerecord.

FYI

Mapping Objects to Relational Databases: O/R Mapping In Detail

software architecture

TBD

answered May 17, 2017 at 4:53

hiropon

1,8324 gold badges22 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

best database design with shared data and multiple application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related