Day 2 Basic Concepts Con't

Day 2 Basic Concepts Con't - Basic Concepts (Part 2)...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Basic Concepts (Part 2) Today's Agenda Alternative DB Models Hierarchical Network Relational Terminology Tables, records, fields, keys, etc 1:1, 1:N and M:N Unary, Binary and N-ary Database Model Logical design or organization of data Reflects basic structure Parent - child Belongs to Ownership May translate into physical file structure Hierarchical Database Model Inverted tree (with single root) Parent - child College Department Instructor Course/Section Student/Reg Staff Staff Network Database Model Multiple inverted trees (with shared branches) College Instructor Section Registration Staff Staff Student Course Department HDM and NDM Weaknesses User must know design Redundant data Does not support odd queries May not grow well Strengths Very strong referential integrity Size (low overhead if redundancy controlled) Speed (for good queries) Relational Database Model...
View Full Document

Page1 / 19

Day 2 Basic Concepts Con't - Basic Concepts (Part 2)...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online