1 / 14

Data Modeling Basics

Data Modeling Basics. GENERAL PROGRESSION. DEVELOP BASIC MODEL ENHANCE BASIC MODEL REFINE THE MODEL VALIDATE THE MODEL . DATA ANALYSIS. "WHAT THERE IS“ WHAT INFORMATION IS REQUIRED BY THE BUSINESS. ACTIVITY ANALYSIS. "WHAT IS DONE“ WHAT ACTIVITIES MAKE UP THE BUSINESS. ENTITY TYPES.

Samuel
Download Presentation

Data Modeling Basics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Modeling Basics

  2. GENERAL PROGRESSION • DEVELOP BASIC MODEL • ENHANCE BASIC MODEL • REFINE THE MODEL • VALIDATE THE MODEL

  3. DATA ANALYSIS "WHAT THERE IS“ • WHAT INFORMATION IS REQUIRED BY THE BUSINESS

  4. ACTIVITY ANALYSIS "WHAT IS DONE“ • WHAT ACTIVITIES MAKE UP THE BUSINESS

  5. ENTITY TYPES • TYPES OF THINGS THE BUSINESS NEEDS TO OPERATE • A COLLECTION OF OBJECTS WITH A COMMON DEFINITION AND LIKE CHARACTERISTICS • NAMES OF ENTITY TYPES ARE ALWAYS SINGULAR NOUNS: • EMPLOYEE • PRODUCT • SHIPMENT • CUSTOMER LOCATION • CAR

  6. ENTITY • AN ENTITY IS A FUNDAMENTAL THING OF RELEVANCE TO THE ENTERPRISE ABOUT WHICH DATA MAY BE KEPT • AN ENTITY IS A SINGLE OCCURRENCE OF AN ENTITY TYPE • ENTITY TYPE: • EMPLOYEE • ENTITY: • MARY JOHNSON • JACK ALLEN • GENE SMITH

  7. RELATIONSHIPS • ASSOCIATIONS BETWEEN ENTITY TYPES • A REASON OF RELEVANCE TO THE ENTERPRISE FOR ASSOCIATING ENTITIES FROM ONE OR TWO ENTITY TYPES • ENTITY TYPE #1: EMPLOYEE • ENTITY TYPE #2: FACTORY • RELATIONSHIP: works in • EMPLOYEE works in FACTORY • FACTORY receives work of EMPLOYEE

  8. ATTRIBUTES • FACTS ABOUT ENTITIES THAT • ARE USEFUL TO THE BUSINESS • CHARACTERISTICS OF AN ENTITY TYPE THAT ARE IMPORTANT TO THE BUSINESS • ENTITY TYPE: EMPLOYEE • ATTRIBUTES: • NAME • ADDRESS • BIRTHDATE • SERVICE DATE • SALARY

  9. ELEMENTS OF AN ERD (ENTITY RELATIONSHIP DIAGRAM) • ENTITY TYPE • RELATIONSHIPS • ATTRIBUTE

  10. ELEMENTS OF AN ERD • ENTITY TYPE • A FUNDAMENTAL THING OF RELEVANCE TO THE ENTERPRISE ABOUT WHICH FACTS CAN BE KEPT AND WHICH IS INVOLVED IN RELATIONSHIPS WITH OTHER ENTITY TYPES. • RELATIONSHIPS • AN ASSOCIATION OF INTEREST BETWEEN ENTITY TYPES; THE RATIONALE FOR ASSOCIATING ENTITIES OF DIFFERENT TYPES. • ATTRIBUTE • A CHARACTERISTIC OF AN ENTITY TYPE. INDIVIDUAL DETAILS ASSIGNED TO EACH ENTITY.

  11. ENTITY TYPES NAMES • USER SUPPLIES TO ANALYST • USER TERMS • CLEAR AND CONCISE • DO NOT ABBREVIATE • SINGULAR • UNIQUE • ALIAS

  12. FINDING ENTITY TYPES • INTERVIEWS • BUSINESS DOCUMENTS • FILES

  13. RELATIONSHIP • AN ASSOCIATION BETWEEN ENTITY TYPES ENTITY _____ BUSINESS ______ ENTITY TYPE REASON TYPE PATRON -------- RENTS -------- TAPE

More Related