(a)(i) What is data model? (ii)State three types of data model (b)(i) List three approaches to data modeling. (ii) Explain any one approach listed in1(b)(i)
Explanation
1(a)(i) Data model is the organization of data elements and standard on how the data elements relate to one another OR Data model is the representation of the data structures that are required by the database. OR Data model is the representation of a real world situation about which data is to be collected. OR Data model is the structure and organization of data in database. OR Data model is the diagram showing inter-relationships between data elements and how they are stored. (ii) Types of data model - Flat model - Hierarchical model - Network model - Relational model - Object-oriented model - Entity relationship model - Document model - Entity relationship model - Document model - Entity-attribute-value model - Star schema - Object relational model - Inverted file model - Multi dimensional model - Semi structured model - Context model - Associative model - NoSQL model (b)(i) Approaches to data modelling - Conceptual data model -Enterprise data model - Logical data model - Physical data model (ii) Conceptual data model - Identifies objects, concept, entities and relationships between them. - Represents the first /initial stage/base in the development of the design of data and data storage. - Is the most abstract form/highest level/summary level of data modeling. Enterprise data model - Creates a graphical model/view of all data used in an organization/company/enterprise. Logical data model - Describes the data in details as much as possible without regard to hoe they will be physically implemented in the database. Physical database model -Is a representation of data/tables (Table Names, Primary key, Foreign keys, Column/Fied Name and Data types) in a DBMS.