Week 11.0 (Wednesday)

Week 11.0 - 1 Database Design Database Design The bigger picture of database systems Session 11 Checkpoint Checkpoint So far what we covered have

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

Unformatted text preview: 9/23/2009 1 Database Design Database Design The bigger picture of database systems Session 11 Checkpoint Checkpoint So far, what we covered have been technical ER diagrams Normalization SQL DB transaction and concurrency control What else? 11-2 What else? The bigger picture of DB technology DBLC, DB design and administration 9/23/2009 2 The big picture The big picture A successful DB design is an integral component of the information system The information system (IS) is developed within a framework call System Development Life Cycle SDLC manages changing needs of IS DB is part of IS and thus is subject to frequent 11-3 DB is part of IS and thus is subject to frequent changes Managing changes in DB Managing changes in DB DBLC is the management of change in DB What we want to know How to conduct evaluation and revision What are the strategies in DBLC 11-4 9/23/2009 3 The information system The information system A place for data collection, storage and retrieval Consists of people, hardware, software, applications, DBMS and procedures Maintained via SDLC System analysis and design (MSC228) To support decision making 11-5 To support decision making Conceptual view Conceptual view 11-6 9/23/2009 4 System development life cycle System development life cycle (SDLC) (SDLC) The development and maintenance of IS The bigger framework within which DBLC exists Divided into 5 phases Planning...
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 / 16

Week 11.0 - 1 Database Design Database Design The bigger picture of database systems Session 11 Checkpoint Checkpoint So far what we covered have

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

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