CIS131-DFERREYRA-U1D1-11072011

CIS131-DFERREYRA-U1D1-11072011 - CIS 131 DATABASE I Unit 1...

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

View Full Document Right Arrow Icon
CIS 131 DATABASE I Unit 1 – Day 1- Homework Prepared By: Daniel E. Ferreyra Date: 11/7/2011
Background image of page 1

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

View Full DocumentRight Arrow Icon
TABLE OF CONTENTS
Background image of page 2
Review Questions Chapter 1: 1. Define each of the following: a) Data : Raw facts, that is, facts that have not yet been processed to reveal their meaning to the end user. b) Field : A character or group of characters (alphabetic or numeric) that defines a characteristic of a person, place, or thing. For example, a person’s Social Security number, address, phone number, and bank balance all constitute fields. c) Record : A collection of related (logically connected) fields. d) File : A named collection of related records. 2. What is data redundancy, and which characteristics of the file system can lead to it? Data redundancy is a condition that exists when data environment contains redundant (unnecessarily duplicated) data. 3. What is data independence, and why is it lacking in file systems? Data independence is a condition that exists when data access is unaffected by changes in the physical data storage characteristics without affecting the application program’s ability to access data. It lacks in the file systems because it makes the file system extremely cumbersome from point of view of a programmer and database manager. 4. What is a DBMS, and what are its functions? Is a collection of programs that manages the database structure and controls access to the data stored in the database. It helps manage the cabinet’s contents. 5. What is structural independence, and why is it important? Data characteristics that exists when changes in the database schema do not affect data access. Structural independence is important because when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. 6.
Background image of page 3

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

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

This note was uploaded on 11/24/2011 for the course CIS 131 taught by Professor Davidwood during the Fall '10 term at ECPI College of Technology.

Page1 / 8

CIS131-DFERREYRA-U1D1-11072011 - CIS 131 DATABASE I Unit 1...

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

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