Conceptual Design+ Logical + normalisation

Conceptual design

The basic fundamentals for conceptual design is to collect data for modelling and to represent that.
The way to collected data is represented is in the way of an ER model it is a way of modelling that uses a top down approach, meaning that it identifies entities and gives attributes to them. ER model stands for Entity Relationship.
In an Entity Relationship model there are six things that make it up:
· Entity types
· Entity
· Weak entity types
· Strong entity types
· Attributes
· Relationship

Entity types would be if you compared them to the real world as objects.
Entity is an object or concept which has no other similarities meaning one of a kind. Weak entity type is an entity type that is only there if it is dependent on some other entity type. Strong entity type is an entity type that can exist and is not needed for some other entity type. Attributes are the properties of the entity. And finally a relationship is an asso...