(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
06 May Bath
27 May London
09 Jun Bath
30 Jun London
14 Jul Bath
28 Jul London
11 Aug Bath
26 Aug London
08 Sep Bath
23 Sep London
06 Oct Bath
21 Oct London
03 Nov Bath
18 Nov London
01 Dec Bath
16 Dec London
05 Jan Bath
13 Jan London
02 Feb Bath
02 Feb Bath
02 Feb Bath
10 Feb London
10 Feb London
10 Feb London
View Other Courses in Same Category

Module 1: Introduction to Modelling Business Requirements

  • Overview of Database Modelling Process
  • Data Modelling Concepts
  • Lab: Examining External Information
Skills
  • Describe the process of modelling business requirements.
  • Summarize the process of modelling a baseline database model.
  • Summarize data modelling concepts.
Top

Module 2: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1

  • Verbalizing Data Use Cases
  • Formalizing Fact Types
  • Lab: Analyzing External Information and Creating a Conceptual Model—CSDP Step 1
Skills
  • Complete CSDP step 1.
  • Verbalize data use cases.
  • Formalize fact types.
  • Create a conceptual model.
Top

Module 3: Drawing a Conceptual Model and Entering Sample Data—CSDP Step 2

  • Drawing Fact Types
  • Applying a Population Check
  • Applying CSDP Step 2
  • Lab: Drawing Fact Types and Applying Population Checks
Skills
  • Apply CSDP step 2.
  • Draw fact types.
  • Apply population checks.
Top

Module 4: Trimming the Conceptual Schema-CSDP Step 3

  • Implementing Primitive Entity Types
  • Implementing Derived Fact Types
  • Applying CSDP Step 3
  • Lab: Implementing Primitive Entity Types and Derived Fact Types—CSDP Step 3
Skills
  • Check for entity types that should be combined and note any arithmetic derivations.
  • Implement primitive entity types.
  • Implement derived fact types.
  • Apply CSDP step 3.
Top

Module 5: Adding Uniqueness Constraints and Checking Arity of Fact Types-CSDP Step 4

  • Implementing Uniqueness Constraints
  • Implementing Nested Object Types
  • Checking Fact Arity
  • Applying CSDP Step 4
  • Lab: Adding Uniqueness Constraints, and Checking Arity of Fact Types
Skills
  • Apply CSDP step 4.
  • Implement uniqueness constraints.
  • Implement nested object types.
  • Identify fact arity.
Top

Module 6: Adding Mandatory Role Constraints and Checking For Logical Derivations-CSDP Step 5

  • Implementing Mandatory Constraints
  • Implementing a Primary Reference Scheme
  • Checking for Logically Derivable Fact Types
  • Applying CSDP Step 5
  • Lab: Adding Mandatory Role Constraints, and Checking for Logical Derivations
Skills
  • Complete CSDP step 5.
  • Implement mandatory role constraints.
  • Implement a primary reference scheme.
  • Avoid modelling logically derivable fact types.
Top

Module 7: Adding Value and Set Constraints, and Creating Entity Subtypes-CSDP Step 6

  • Implementing Value Constraints
  • Implementing Set Constraints
  • Implementing Entity Subtypes
  • Applying CSDP Step 6
  • Lab: Adding Value Constraints, Set Constraints, and Entity Subtypes
Skills
  • Complete CSDP step 6.
  • Implement value constraints.
  • Implement set constraints.
  • Implement entity subtypes.
Top

Module 8: Adding Frequency and Ring Constraints-CSDP Step 7

  • Implementing Frequency Constraints
  • Implementing Ring Constraints
  • Applying CSDP Step 7
  • Lab: Implementing Frequency and Ring Constraints
Skills
  • Complete CSDP step 7.
  • Implement frequency constraints.
  • Implement ring constraints.
Top

Module 9: Generating a Relational Logical Model

  • Understanding Relational Logical Models
  • Understanding Normalization
  • Generating a Relational Logical Model
  • Lab: Generating a Relational Logical Model
Skills
  • Generate a relational logical model.
  • Describe a relational logical model.
  • Describe normalization.
Top

Module 10: Completing the Baseline Model

  • Refining Conceptual and Logical Models
  • Documenting Conceptual and Logical Models
  • Lab: Completing the Baseline Model
Skills
  • Complete a baseline model.
  • Refine conceptual and logical models.
  • Document conceptual and logical models.
Top

Module 11: Generating and Reverse Engineering Physical Schema

  • Forward Engineering
  • Reverse Engineering
  • Lab: Forward and Reverse Engineering Physical Schema
Skills
  • Transfer a database model to and from SQL Server 2000.
  • Generate a database from a relational logical model.
  • Update a database from a modified relational logical model.
  • Reverse engineer a database into a relational logical model.
Top
.

Exams:

  • There are no exams directly associated with this course

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1050
(€1491) 		£ 674.00
(€957) 		- No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008