Explore data modeling methodologies with the goal of understanding how to choose, apply, and interpret appropriate statistical designs and analyses for practical data problems.
How do business managers and their staff find data and information they need for decision-making?
Ask the end-users of the data. But who are they?
And what if the data exists in different versions? Which version is correct?
A data model is the "Corporate Street Directory". It includes data maps and data details in a repository. It is comparable to the city map and details of streets. A data model, therefore:
Depends on business rules and business conditions
Depends on the time requirements, and performance
Depends on the technology used
A data model should be based on an organisation's strategic, tactical and operational business plans, if information systems are to be built that are aligned with the corporate goals.
Most organisations have not, until recently, recognised the importance of data models - which are as vital to the construction of an information system as an architect's plans are for the construction of a house or a skyscraper.
A data model is an essential prerequisite for development of application databases, data warehouses, for internet/intranet systems and for business transformation to take advantage of the Internet and corporate Intranet technologies.
On completion of this workshop the learner will
Have completed exercises which will guide them through the process of data modelling.
Have thought critically about the data requirements and processes of a scenario used in class.
Know the three phases of data modelling and their outcomes.
Have set up Conceptual and Logical models describing the data in the scenario used in class.
Understand the notation of different Entity-Relationship diagrams.