ICT321_StudyUnits_Jul10 - ICT321 Database Systems:...

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 UNITS 1-6
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
ICT321 STUDY NOTES CHAPTERS 1-6 SIM UNIVERSITY SU-1 CHAPTER 1 INTRODUCTION Unit Learning Objectives 1. to be able to understand database processing concepts 2. to be aware of some database applications 3. to recognise what knowledge is needed to work as a database application developer or database administrator Prerequisite Knowledge Nil Reading Prescribed Text : Chapter 1 Pages 50 – 54 are optional reading Learning Summary Following is a summary of the main points covered in Chapter 1. It is estimated that the student will spend about 1.5 hr covering this chapter, including trying out some review and project questions given at the end of the chapter. Self-assessment questions are included at suitable junctures in the notes below to test understanding of the contents covered. It is advisable to spend about 30 – 45 mins to go through these notes and attempt the questions, then check the text and / or other sources for the accuracy and completeness of your answers.
Background image of page 3

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

View Full DocumentRight Arrow Icon
CHAPTERS 1-6 ICT321 STUDY NOTES SU-2 SIM UNIVERSITY 1.1 Characteristics of Databases A Database stores data in tables, in rows and columns o Each row has data about a particular instance of the data, eg Student table has rows, each containing data about a particular student o Each column contains characteristics of each of the instances, eg columns in Student table stores Student Id, Student Name, etc Data relationships exist among rows of data in related tables Data vs Information o Data are recorded facts or figures o Information is data presented in a meaningful context Self-Assessment Question: i) Define the terms data and information . Explain how the two terms differ. Database Applications range from simple single-user applications to complex multi-user applications, e-Commerce and Data Mining applications Self-Assessment Question: ii) What problem can occur when a database is processed by more than one user? 1.2 Components of a Database System Users enter data to a database through online screens and data entry applications Data is stored in an organised manner in a Database Information is retrieved from a database through queries and reports Self-Assessment Question: iii) Explain the components shown in Figure 1-15 of the prescribed text. Computer applications are programs that enable users to input data into a database, process it according to business rules and retrieve information from the database in a meaningful form Structured Query Language or SQL is one of the standard programming languages used for retrieval of data from a database
Background image of page 4
ICT321 STUDY NOTES CHAPTERS 1-6 SIM UNIVERSITY SU-3 A Database Management System or DBMS is a suite of programs that creates, administers and allow user applications to access the database DBMS are usually written by software companies and licensed for use by other companies or users o Examples of DBMSs are Microsoft (MS) Access, Microsoft (MS) SQL
Background image of page 5

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

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

This note was uploaded on 09/06/2010 for the course IT ICT321 taught by Professor Tan during the Spring '10 term at Singapore Institute of Management.

Page1 / 31

ICT321_StudyUnits_Jul10 - ICT321 Database Systems:...

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