Above you see the atomic building blocks of the ER-Diagram:
- Carninalities (Crow’s feet notation) one, zero-or-one, zero-or-many, one-or-many, many.
From Requrements to Deployment
This ER-Diagram is inspired by some of the tables in his sample database
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.
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.