Chapter 7. Multiple Tables: Where to Put the Data, Relationships Among Tables, and Creating a Database

  1. Joseph Schulman M.D., M.S.

Published Online: 11 JAN 2008

DOI: 10.1002/9780470757451.ch7

Book Title

Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis

Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis

Additional Information

How to Cite

Schulman, J. (2008) Multiple Tables: Where to Put the Data, Relationships Among Tables, and Creating a Database, in Managing Your Patients' Data in the Neonatal and Pediatric ICU: An Introduction to Databases and Statistical Analysis, Blackwell Publishing Ltd, Oxford, UK. doi: 10.1002/9780470757451.ch7

Author Information

  1. Division of Newborn Medicine, Weill Medical College of Cornell University, New York-Presbyterian Hospital, New York, New York, 10021

Publication History

  1. Published Online: 11 JAN 2008
  2. Published Print: 1 JAN 2006

ISBN Information

Print ISBN: 9780727918703

Online ISBN: 9780470757451

SEARCH

CHAPTER TOOLS

Get PDF (388K)

Keywords:

  • relationships;
  • efficiently;
  • medications;
  • maternal complications;
  • infants

Summary

The prelims comprise:

  • Multiple tables store data effciently and accurately

  • Lossless decomposition

  • Guiding questions for a multitable system

  • Data modeling: overview

  • Relational databases and languages

  • Database design approaches

  • Table relationship types

  • Primary key

  • Foreign key

  • The eNICU relationship diagram

  • Justifiable deviations

Get PDF (388K)