ICT321_StudyGuide_Jul10 - ICT321 Database Systems Modelling...

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

View Full Document Right Arrow Icon
ICT321 Database Systems: Modelling and Design Study Guide (5CU)
Background image of page 1

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

View Full Document Right Arrow Icon
Course Development Team Head of Programme : Mr V V Moorthy Course Developer(s) : BOEY Yoke Ling Production : Educational Technology & Production Team Curriculum Administration Team Copyright © SIM University, 2010 All rights reserved. No part of this material may be reproduced in any form or by any means without permission in writing from the Educational Technology & Production, SIM University. Educational Technology & Production SIM University 535A Clementi Road Singapore 599490
Background image of page 2
CONTENTS SECTION 1: COURSE GUIDE 1.1 Introduction ..................................................................................................... 1 1.2 Course Description and Aims ....................................................................... 2 1.3 Learning Outcomes ........................................................................................ 3 1.4 Overall Assessment ........................................................................................ 4 1.5 Learning Materials .......................................................................................... 5 1.6 Course Schedule for 5 CU Print Courses .................................................... 6 SECTION 2 : STUDY UNITS Chapter 1 : Introduction to IMC·················································································SU-1 Characteristics of Databases Components of a Database System The Database Chapter 2 : Introduction to SQL·················································································SU-6 SQL background SQL SELECT/FROM/WHERE Framework Querying Two or More Tables Chapter 3 : The Relational Model and Normalization··········································SU-11 Background Relational Model Terminology Normal Forms Chapter 4 : Database Design Using Normalization ··············································SU-17 Designing Updatable Databases Designing read only Databases Common Design Problems Chapter 5 : Data Modelling With The Entity Relationship Model······················SU-21 The purpose of a Data Model The Entity-Relationship Model The Data Modeling Process Chapter 6 Transforming Data Models into Database Designs ····························SU-25 First Steps in Transforming a Data Model into a Database Design Create Relationships between Tables Design for Minimum Cardinality
Background image of page 3

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

View Full Document Right Arrow Icon
ICT321 Database Systems: Modelling and Design COURSE GUIDE
Background image of page 4
ICT321 DATABASE SYSTEMS: MODELLING AND DESIGN COURSE GUIDE SIM UNIVERSITY 1 Section 1: Course Guide
Background image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 10

ICT321_StudyGuide_Jul10 - ICT321 Database Systems Modelling...

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

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