Week 2.0 (Wednesday)

Week 2.0 (Wednesday) - 7/17/2009 1 SIT103 SIT103...

Info iconThis preview shows pages 1–3. 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
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 6

Week 2.0 (Wednesday) - 7/17/2009 1 SIT103 SIT103...

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

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