The Database

The Database
MySQL database goes well with CMS like WordPress, Drupal and Joomla
We can also use MS Sql as the database for development.
Evolution of the database
  • 2000s: NoSQL and NewSQL
  • 1990s: object-oriented
  • 1980s: on the desktop, dBase lightweight and easy
  • 1970s: SQL DBMS, relational DBMS, Cody’s concept
  • 1960s: navigational DBMS

In the relational model, records are “linked” using virtual keys not stored in the database but defined as needed between the data contained in the records.

004_Relational_key_SVG.png

Design and modelling

003_process_of_database_design_v2

Collage of five types of database models

05_Database_models.jpg

[Source: Wikipedia]