WIXLIB

Tutorial in Enterprise Data Modelling by ExampleOrg and People Model Police Model 24CommentAccountCalendarEasily added to Org & PeoplePartyAssetVehicleEventBusiness ActivityOrganisationOrganisationPeoplePersonAnd ends here *****************Step 3. Adapt and incorporate Subject Area Models Fingerprint Recognition - http://www.databaseanswers.org/data models/fingerprint recognition/index.htmForensic Science Labs - http://www.databaseanswers.org/data models/forensic science labs/index.htmGlobal Crime - http://www.databaseanswers.org/data models/global crime/index.htmPolice Departments - http://www.databaseanswers.org/data models/police departments/index.htmPrisons and Prisoners - http://www.databaseanswers.org/data models/prisons and prisoners/index.htmTracking Evidence - http://www.databaseanswers.org/data models/tracking evidence/index.htmStep 4. Review Generic Data MartThis is a Data Mart for Traffic Cops and Tickets :-

Tutorial in Enterprise Data Modelling by ExampleStep 6. Validate the Canonical Data ModelStep 7. Map to the Canonical Data ModelStep 8. Review Source DocumentsStep 9. Create initial Information Catalogue.8. Local Government8.1 LinkThe material in this Chapter appears on this page : http://www.databaseanswers.org/data models/enterprise data model for local government/index.htm8.2 The StepsStep 2. Review the Enterprise Data ModelThis Model is on this page :- 25

Tutorial in Enterprise Data Modelling by Example http://www.databaseanswers.org/data models/enterprise data model for local government/index.htmStep3.Adaptand incorporate Subject Area ModelsWe have also created Data Models for these Subject Areas : Children's Attainments Citizens Citizens and Addresses Services Customers and Services Education Services Housing ServicesStep 4. Review Generic Data MartThis Model needs replacing. 26

Tutorial in Enterprise Data Modelling by Example 27

Tutorial in Enterprise Data Modelling by Example 289. Logistics9.1 LinkThe material in this Chapter appears on this page : http://www.databaseanswers.org/data models/enterprise data model for logistics/index.htm9.2 The StepsThe Steps are as follows :Step 1. Create a Statement of Business ObjectivesStep 2. Review the Enterprise Data ModelStep 3. Adapt and incorporate Subject Area ModelsStep 4. Review Generic Data MartStep 6. Validate the Canonical Data ModelStep 7. Map to the Canonical Data ModelStep 8. Review Source DocumentsStep 9. Create initial Information Catalogue.

Tutorial in Enterprise Data Modelling by Example 29Step 2. Review the Enterprise Data ModelThis Data Model is available on this page : http://www.databaseanswers.org/data models/enterprise data model for logistics/index.htm

Tutorial in Enterprise Data Modelling by ExampleStep 3. Adapt and incorporate Subject Area ModelsStep 4. Review Generic Data MartThis Data Mart has been named according to the style recommended byPragmatic Works where Dimension and Fact Tables are named appropriately. 30

Tutorial in Enterprise Data Modelling by Example 3110.Postal Services10.1 LinkThe material in this Chapter appears on this page : http://www.databaseanswers.org/data models/postal services/index.htm10.2 The Steps.Step 1. Create a Statement of Business ObjectivesOur main sources of information is the TNT Post Web Site.We find that one of the Services they offer is TrackingOur first thought as outsiders who have sent and received post is that the business delivers letters,packages and parcels to an Address for a fee.We decide to call these Things of Interest ‘Deliverables’.We look for some kind of "Business Mission Statement" that can help us to derive a Top-Level viewof the business.We find this statement on the Web Site :"TNT Post is the Royal Mail's number one challenger for business mail of all kinds.Whether we're handling your letters, packets and parcels or successfully managing yourunaddressed doordrop strategy, you'll find we're straight-talking people who get the job done.Our can-do approach and our focus on efficiency make us different, saving you time and money.We provide a high quality, full service concept for all your business mail and distribution needs.Our portfolio is designed to deliver what you want. We are confident that we can meet your postalservice requirements and exceed your expectations, whatever the scale and scope of yourenterprise.”On the Web Ste, we see an option for Customers to register Complaints.We decide to model that as a more general Feedback facility, to include Compliments andSuggestions.At this point, we can say that the Things of Interest are .Distribution Centres (the mail has to be stored somewhere)

Tutorial in Enterprise Data Modelling by Example6.7.8.9.10.11. e Organisation offers Services, which include :1.Deliver items.2.Receive Payments3.Publish Schedules4.Agree Contracts with CustomersAt this point, we can create our first draft of the Top-Level Data Model.We will need to decide what our Subject Areas are going to be.Then we will need to review our first draft with the Review Committee of business users.Finally, we define the Business Data Rules.Now that we have defined the 'Things of Interest' we can establish how they are related.We call these the 'Business Data Rules' and then we review the with our Steering Groupand modify them as required.1. A Customer always signs one or more Contracts for Services.2. Customers can post Deliverables in line with the terms of a Contract.3. The Postal Company provides Services that deliver Deliverables according to theterma of a Contract.Step 4. Identify the Reference DataThe Reference Data is important because it provides the Foundation for all the otherData.

Tutorial in Enterprise Data Modelling by ExampleStep 2. Create the first draft Enterprise Data ModelThis is our first Version :- 33

Tutorial in Enterprise Data Modelling by ExampleThe following day, I reviewed the Web Site in more detail and here is my second Version :- 34

Tutorial in Enterprise Data Modelling by Example 35Step 3 : Incorporate Subject Area ModelsWorking from this second Version, I located some appropriate Subject Area Models in my Library : http://www.databaseanswers.org/data models/subject area data models.htmSubject Areas are : Contracts Customers Customer and Addresses Deliveries (Schedules) Feedback Invoices and Payments Staff Vehicle Maintenance and Tracking

Tutorial in Enterprise Data Modelling by ExampleStep 4. Create a Data MartWe are now in a position where we can create design for the Data Mart :-Step 5. Validate the Canonical Data ModelStep 6. Map to the Canonical Data ModelStep 7. Review Source DocumentsStep 8. Create initial Information Catalogue. 36

Tutorial in Enterprise Data Modelling by Example11.Retail Business11.1 LinkThe material in this Chapter appears on this page : http://www.databaseanswers.org/data models/enterprise data model for retail/index.htm11.2 The Steps.Step 1. Create a Statement of Business ObjectivesThe Specifications are available for review.We start by agreeing a Statement of Business Objectives to establish thescope of the Enterprise Data Model.Once we have agreed the Statement of Business Objectives we can create adraft Top-Level Model with associated Subject Areas, each of which is shown inits own Model.This is an example of a Statement of Business Objectives for a Retailorganization :"Our Business objectives are to offer a wide range of affordable Products.We will control costs to achieve maximum profit potential from a wide range ofaffordable Products which are sourcedon a 'just-in-time' basis tailored to our target market, with specific Customerprofiles.The Enterprise Data Model will establish the data available for a DataWarehouse to meet Business Intelligence requirements."This Data Model is a variation of the Retail Customers Model.The Specifications are available for review.We start by agreeing a Statement of Business Objectives to establish the scopeof the Enterprise Data Model.Once we have agreed the Statement of Business Objectives we can create adraft Top-Level Model with associated Subject Areas, each of which is shown inits own Model.This is an example of a Statement of Business Objectives for a Retailorganization :"Our Business objectives are to offer a wide range of affordable Products. 37

Tutorial in Enterprise Data Modelling by ExampleWe will control costs to achieve maximum profit potential from a wide range ofaffordable Products which are sourced on a 'just-in-time' basis tailored to ourtarget market, with specific Customer profiles.The Enterprise Data Model will establish the data available for a DataWarehouse to meet Business Intelligence requirements."Step 2. Review the Enterprise Data ModelThis EDM is a variation of the Retail Customers Model and appears on this page –ohttp://www.databaseanswers.org/data models/enterprise data model for retail/index.htmStep 3. Review the Subject Area Models Customers Subject Area Customers and Orders In-Store Shopping Online Shopping Order History Products Subject Area Products, Stores and Sales Subject Area Registered Users (with MDM Customer Master Index) 38

Tutorial in Enterprise Data Modelling by Example 39Step 4. Review Generic Data Mart http://www.databaseanswers.org/data models/enterprise data model for retail/retail customers data mart.htmStep 6. Validate the Canonical Data ModelStep 7. Map to the Canonical Data ModelStep 8. Review Source Documents

Tutorial in Enterprise Data Modelling by Example 40Step 9. Create initial Information Catalogue12. Travel and Transport12.1 LinkThe material for this Chapter has been taken from this page on our Web Site which covers travel byTrains, Boats and Planes: http://www.databaseanswers.org/data models/trains and boats and planes/index.htmAdditional material for specific modes of Travel appears on this page : http://www.databaseanswers.org/data models/top ten data models transport and travel.htm12.2 The Steps.There are three sections in this Chapter : Air Travelo http://www.databaseanswers.org/data models/enterprise data model for air travel/index.htmShippingo http://www.databaseanswers.org/data models/container shipping/index.htmTrain Travelo http://www.databaseanswers.org/data models/train ticketing systems/index.htmThe Steps are as follows :Step 1. Create a Statement of Business Objectives

Tutorial in Enterprise Data Modelling by ExampleStep 2. Review the Enterprise Data ModelThis shows the current state of our Third-Normal Form Data Model :- 41

Tutorial in Enterprise Data Modelling by Example 4212.2.1 Air TravelStep 3. Adapt and incorporate Subject Area Models3.1 Subject Area for Air TravelThis Model appears on this page for an Enterprise Data Model for Air Travel : http://www.databaseanswers.org/data models/enterprise data model for air travel/index.htm

Tutorial in Enterprise Data Modelling by Example3.1.1 Detailed Subject Area for Air TravelWe have also created Data Models for these Subject Areas : Aircraft Maintenance Airline Operations Airline Reservations Airport Management Passengers Online BookingsStep 4. Review Generic Data MartStep 6. Validate the Canonical Data ModelStep 7. Map to the Canonical Data ModelStep 8. Review Source DocumentsStep 9. Create initial Information Catalogue. 43

Tutorial in Enterprise Data Modelling by Example 4412.2.2 ShippingYou can download our short Discussion Paper on Enterprise Data Modelling for Container Shipping http://www.databaseanswers.org/data models/container shipping/Discussion Paper on Enterprise Data Model.pdfStep 3. Review the Subject Area Models for Shipping12.2.2.1 Top-Level Model for ShippingThis Model appears on this page for the Top-Level Data Model for Container Shipping : http://www.databaseanswers.org/data models/container shipping/index.htm1.2.2.2.2 Subject Area Models for ShippingContainers http://www.databaseanswers.org/data models/container shipping/subject area for containers.htm Data Mart –ohttp://www.databaseanswers.org/data models/container shipping/data mart.htm

Tutorial in Enterprise Data Modelling by Example 4512.2.3 Train TravelStep 3. Adapt and incorporate Subject Area Models3.1 Subject Area for Train Travel Public Transporto http://www.databaseanswers.org/data models/public transport/index.htmData Mart for Public Transport :o http://www.databaseanswers.org/data models/public transport/public transport data mart.htmRailway Reservations –o http://www.databaseanswers.org/data models/railway reservations/index.htmTrain Systems :o http://www.databaseanswers.org/data models/train system map/index.htmTrain Ticketing Systems :o http://www.databaseanswers.org/data models/train ticketing systems/index.htm13. Wine13.1 LinkThe material in this Chapter appears on this page : http://www.databaseanswers.org/data models/enterprise data model for wine/index.htm13.2 The StepsStep 2. Review the Enterprise Data Model

Tutorial in Enterprise Data Modelling by ExampleStep 3. Review Subject Area ModelsWe have created Data Models for these Subject Areas :These Models have been combined in the Enterprise Data Model. Wine Cellars Wine Food and Merchants Wine Food and Pairings Wine ListsLink to Wine Cellars Data Model : http://www.databaseanswers.org/data models/wine cellars/index.htm 46

Tutorial in Enterprise Data Modelling by ExampleWine, Food and Merchants : http://www.databaseanswers.org/data models/wine food and merchants/index.htm 47

Tutorial in Enterprise Data Modelling by ExampleWine, Food and Pairings : http://www.databaseanswers.org/data models/wine food and pairings/index.htm 48

Tutorial in Enterprise Data Modelling by ExampleWine Lists : http://www.databaseanswers.org/data models/wine lists/index.htmStep 4. Review Generic Data MartStep 5. Validate the Canonical Data ModelStep 6. Map to the Canonical Data ModelStep 7. Review Source DocumentsStep 8. Create initial Information Catalogue 49

Tutorial in Enterprise Data Modelling by Example 50Appendix A. Cloud MigrationThis Approach to Enterprise Data Modelling can provide avery powerful technique for migrating to a Data Architecture that incorporates Cloud features.This page shows the appropriate Data Architecture : http://www.databaseanswers.org/reference data architecture.htmThe Enterprise Data Model (EDM) is used for the Data Warehouse and Data Marts.The Master and Reference Data will be in the Clouds And will form the foundation and will becompliant with the EDM.

Tutorial in Enterprise Data Modelling by Example 18 Step 2. Review the Enterprise Data Model After we have agreed the Statement of Business Objectives with the business we can review our Enterprise Data Model. This will establish the data available f