Dating website database structure
ER Diagrams are most often used to design or debug relational databases in the fields of software engineering, business information systems, education and research.
Also known as ERDs or ER Models, they use a defined set of symbols such as rectangles, diamonds, ovals and connecting lines to depict the interconnectedness of entities, relationships and their attributes.
Primary key: A candidate key chosen by the database designer to uniquely identify the entity set.
Foreign key: Identifies the relationship between entities.
They mirror grammatical structure, with entities as nouns and relationships as verbs.
Composite: Sub-attributes spring from an attribute. Derived: Attributed is calculated or otherwise derived from another attribute, such as age from a birthdate.
There are many case tools that can help you in drawing this.
3) Use the principles of Database Normalization to fine tune your schema to avoid data redundancies.
How entities act upon each other or are associated with each other. For example, the named student might register for a course.
The two entities would be the student and the course, and the relationship depicted is the act of enrolling, connecting the two entities in that way.
ER diagrams also are often used in conjunction with data flow diagrams (DFDs), which map out the flow of information for processes or systems. Peter Pin-Shan Chen), currently a faculty member at Carnegie-Mellon University in Pittsburgh, is credited with developing ER modeling for database design in the 1970s.