Above you see the atomic building blocks of the ER-Diagram:

  • Entity
  • Attribute
  • Relation
  • Carninalities (Crow’s feet notation) one, zero-or-one, zero-or-many, one-or-many, many.

From Requrements to Deployment

Model inspired by Jukić et al.

ER-Diagram

This ER-Diagram is inspired by some of the tables in his sample database

 

Database Implementation

Here are Ben Forta’s tables in PhpMyAdmin “design viewW.

During implementation you will create the tables and structure.

Note that you have to design the data as integers, numbers, etc.:

  • cust_id = int(11)
  • cust_name = char(50)

The customers table in ER-diagram form.

Normalizing

 

In the diagram the cardinalities have to be normalized. Here are a few solutions to typical problems.

 

TIP: From ER-diagram to HTML form

Look at the attributes. Create an input for each field. Then use the INSERT keyword.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enable Notifications OK No thanks

We use cookies - more information

Multimusen.dk will set a few cookies from Doubleclick, Google and the Social Media plugins they ay set some cookies. Some of my pages use APIs - such as YouTube, LinkedIn, Google Fonts, Google Maps, Mapbox, Spotify, Jetpack, Twitter, Facebook &c.. Such plugins may set the odd cookie.

Close