FIT1004 Lecture Notes - Lecture 10: Cardinality, Database Design
Lecture 10 Conceptual Database Design
Database Life Cycle
Entity Relationship Modelling
● used for database design
● components
○ Entities - things we record
○ Attributes - properties of entities
○ Relationships - the connections between the entities
● encapsulates the meaning of the data
● Aids in documenting information requirements
ER Modeling: Weak vs Strong
Weak Enitity - the entity existence depends on the presence of another entity
Strong Entity - not a weak entity
Types of attributes
● simple
○ cannot be subdivided
○ age, sex
● Composite
○ can be subdivided into additional attributes