Tel: +1 (713) 570-9633
Email: info@corptechit.com
UI/Web Professional IT Training CenterBuilding World Class IT Professional Online TrainingOwn your future learning new skills online

UI/Web Professional IT Training Center

CorptechIT has fast become one of the most sought after disciplines by companies today

Read More

Building World Class IT Professional Online Training

For the skilled manpower in high end technology courses like SAP, SAP-MM, SAP-WM, SAP-SRM, SAP-PP, SAP-SD, SAP-FICO, SAP-APO, SAP-BW/BI,SAP HANA and ERP domains.

Read More

Own your future learning new skills online

CorptechIT is all the more effective as it is very flexible and convenient and can be undertaken at any time even by working professionals.

Read More

DATA MODELING

CorptechIT provides Online Training by experienced IT professionals. Our faculties dedicated to complete your course as per the schedule given. We record the class from your end to refer the classes once again whenever is required. Data Modeling Online Training being a really important module, we have taken precise steps in teaching a full-fledged Data Modeling Online Training course curriculum that covers all the concepts. Our customer support team and trainers will solve all your queries as and when required. Data Modeling Online Training has got the right training that can fulfill a candidate’s training expectations. We see to that the value and quality of our Data Modeling Online Training will not be compromised at all. We will market your resume in USA, UK, SINGAPORE, NEWZELAND, CANADA, AUSTRALIA, JAPAN, SWEDEN, and SOUTH AFRICA. We clarify your questions during the training even after the course completion. After completion of training in Data Modeling we will help you to assist you to get certified on Data Modeling. We will give you 100% Satisfaction.

Data Modeling Online Training Course Content

Introduction to Logical Data Modeling

  • Definitions
  • Benefits of logical data modeling
  • Data modeling vs. physical database design
  • Roles involved in data modeling
  • Steps in the data modeling process

Entities

  • Identifying entities
  • Validating entities
  • Documenting “instances” of entities
  • Distinguishing entities from attributes
  • Naming entities
  • Starting an Entity/Relationship (E/R) diagram

Relationships

  • Identifying significant relationships
  • Determining the “cardinality” or “degree” of a relationship
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • Determining whether a relationship is optional or mandatory
  • Giving a relationship a name
  • Documenting the relationships in the E/R diagram
  • Walking people through an E/R diagram
  • Resolving Many-to-Many Relationships
  • Real-world examples of many-to-many relationships
  • Why many-to-many relationships are broken down into simpler relationships
  • Identifying “association” or “intersection” entities
  • Documenting the new relationships in the E/R diagram

Attributes and Normalization

  • Defining and categorizing attributes
  • Domains and integrity rules
  • Unique identifiers/primary keys
  • Foreign keys
  • Occurrence population
  • Normalization: validating the placement of each attribute
  • Attribute does not repeat (first normal form)
  • Attribute is dependent on its entire UID (second normal form)
  • Attribute is dependent only on its UID (third normal form)

Subtypes and Supertypes

  • Identifying subtypes: real-world examples of subtypes and supertypes
  • Determining when entities are similar
  • UIDs
  • Attributes
  • One-to-one relationships
  • Creating subtypes and supertypes
  • “Type” entities
  • Using subtypes to apply fourth normal form
  • Establishing the relationships of the sub- and super-entities to other entities
  • Mutually exclusive vs. non-mutually exclusive subtypes
  • “Role” entities to handle complex subtypes

Recursive Relationships

  • Real-world examples of recursive relationships
  • Discovering recursive relationships
  • Determining whether the relationships are optional or mandatory
  • Documenting the new relationships in the E/R diagram
  • Hierarchical vs. Network recursive relationships
  • “Structure” or “Bill of Materials” entities: fifth normal form

Implementing a Relational Database

  • Relational database objects: tables, views, indexes, etc.
  • Mapping logical objects to physical objects

Denormalization

  • Why
  • How
  • Pros/Cons
  • Distributing databases
  • Referential integrity
-->