ICT321 SAQ with Answers final version

ICT321 SAQ with - ICT321 DATABASE SYSTEMS MODELLING DESIGN ANSWERS TO SELF-ASSESSMENT QUESTIONS CHAPTER 1 i Define the terms data and information

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

View Full Document Right Arrow Icon
1 ICT321 DATABASE SYSTEMS MODELLING & DESIGN ANSWERS TO SELF-ASSESSMENT QUESTIONS CHAPTER 1 i) Define the terms data and information . Explain how the two terms differ. Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information. ii) What problem can occur when a database is processed by more than one user? When a database is processed by more than one user, there is a chance that one user’s work may interfere with the work of another user. This problem is discussed in detail in Chapter Nine: Managing Multiuser Databases. iii) Explain the components shown in Figure 1-15 of the prescribed text. Figure 1-15 shows the components in a database system as created by Microsoft Access. The components are: Users – The people who interact with database applications created in MS Access. Database applications – These consist of Data Entry Forms, Reports and Queries that are used by the users as their means of interacting with the database. Microsoft Access – Access actually contains several components (see RQ 1-15 below) that are hidden from the user to simplify the user’s experience when using Access. Database – Each MS Access database application is typically run against one MS Access created and maintained database. iv) Name and explain the four categories of database applications. The four categories of database applications are: Client/Server applications – Client software on the user’s computer connects over a network to a database on a database server. E-Commerce Web-based applications – The user uses a Web browser (such as MS Internet Explorer or NetScape Navigator, which has now evolved into Mozilla Firefox) as a client to connect to a database on a database server. Reporting applications - The user uses a Web browser (such as MS Internet Explorer or NetScape Navigator, which has now evolved into Mozilla Firefox) as a client to connect to a Web Portal or similar Web site, which then connects to a database on a database server. XML Web Services applications – The user uses a Web browser (such as MS Internet Explorer or NetScape Navigator, which has now evolved into Mozilla
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Firefox) as a client to connect to Web pages that connect to XML-based XML Web service servers, which then connect to databases on a database servers. v) Why is a database considered to be self-describing? A database is considered to be self-describing because it contains a description of itself – such as what tables are in the database, which columns are in each table and what kind of data is stored in each column. In other words, it contains Metadata, i.e. data about data.
Background image of page 2
Image of page 3
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 / 15

ICT321 SAQ with - ICT321 DATABASE SYSTEMS MODELLING DESIGN ANSWERS TO SELF-ASSESSMENT QUESTIONS CHAPTER 1 i Define the terms data and information

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