BISM1201 Lecture Notes - Lecture 9: Cardinality, Netflix, Information System
Document Summary
Overall database logical development process (done by business analysts) Entity-relationship-diagram: first the development of conceptual model. Identify entities and relationships (done by engaging all parties involved in the project) With that information, the ba creates the conceptual model via discussions with all stakeholders. The conceptual model is the abstracted form of the logical model it shows all the entities at high level, without the detailed structure of attributes and the data types of the attributes: example: An owner can have 0, 1 or many claims (1 to 0 or 1 to many) A claim can relate to only 1 vehicle (1 to 1 and only 1) A claim can have 1 or more drivers (1 to 1 or many) A driver can have 0, 1 or many claims (1 to 0 or 1 to many) Create the conceptual model (abstracted form of the logical model) Cardinality means number involved (0, 1 or many: conceptual model with relationships, cardinalities and modalities: