Home Semantic Web Semantic Web Methodology Cloud Computing Relational Database Design Introduction to ORACLE Cyber Security ORACLE Performance and Tuning Why Intervise? Contact

Relational Database Design

Course Description This two-day course illustrates how-to take user requirements into a functional database design at the logical and physcial layers.

Participants will learn to design optimal relational schemata for real world applications. The course uniquely covers complex data modelling extensions to the rules for normalization.

The duration of the course is two days (16 hours).

Student Learning Objectives/Outcomes

Upon completion of this course the student will:
  • Analyze user requirements into a generalized Entity-Relationship Diagram.
  • Understand and incorporate complex modelling issues including subentities, recursive entities, dependent entities and inheritance.
  • Expand Entity-Relationship Diagrams to handle all relationships including Many-to-Many.
  • Incorporate optional attributes.
  • Incorporate of plural attributes.
  • Develop a generalized schema from Entity-Relationship Diagrams.
  • Expand a schema to handle referential integrity.
  • Perform normalization checks.
  • Define physical structures for generalized processing.
  • Take complex user(s) requirements and create a complete fully functional data model including tables definitions and referential integrity.
Required Textbooks and Materials
Participants will receive course materials and a laboratory book.
Contact Information:

Scott Streit (301) 596-2550 (sstreit@intervise.com)

Scott Streit is the Chief Technology Officer of Intervise and a professor at Villanova. Mr. Streit performed a variety of functions for ORACLE including methodology development and performance tuning.

Course Pre-requisites, Co-requisites, and/or Other Restrictions

This two-day course is intended for database administrators, applications developers, systems analysts and data analysts planning to develop and/or support enterprise data. Introductory database experience is very helpful.

Course Content

Referential Integrity
Lecture 1 Overview of Logical Database Design
Lecture 2 Requirements Gathering
Lecture 3 Data Modelling
Lecture 4 Detailing E-R Diagrams
Lecture 5 E-R Diagrams to Tables
Lecture 6
Lecture 7 Normalization
Lecture 8 Physical Storage
Lecture 9 Implementation Using SQL
Lecture 10 In-Depth Workshop and Conclusion
www.intervise.com    Phone: (240) 599-9300