This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 7/17/2009 1 SIT103 SIT103 Introduction to Introduction to Database Design Database Design Database Design Database Design Data Models - The foundation to good database design Week 2 lecture 1 What are data models? What are data models? y Simple (and usually graphical) representation of real-world data structures y Tools for facilitating interactions among Tools for facilitating interactions among the Designers Application programmers End users 2 T2-2009 Why is it important? Why is it important? y It is the foundation of good database design y Different users have different views and requirements of the data y Data models organize data for different users 3 T2-2009 7/17/2009 2 The building blocks The building blocks y Entities Anything about which data is to be collected E.g. employees, rooms, sales transactions y Attributes Characteristics of the entity E.g. name, age, manufacturer number y Relationships 1:M, M:N or 1:1 4 T2-2009 Indirectly but important: Indirectly but important: business rules business rules y What are they?...
View Full Document
This note was uploaded on 09/27/2009 for the course SEB 323 - S taught by Professor Professor during the Three '09 term at Deakin.
- Three '09