Homework_01-ver02

Homework_01-ver02 - Spring 2010: ISAM 5331.01 / ACCT...

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

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331.01 / ACCT 5333.01 Homework Assignment 01 1. What is a Database Management System (DBMS), and what are its functions? - Database Management System (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database. - Its functions are: o Data Dictionary Management o Data Storage Management o o Security Management o Multiuser Access Control o o Data Integrity Management o Structured Query Language (SQL) o Database Communication Interfaces 2. Explain the difference between data and information: - Data are raw facts o Unprocessed o Lacks context o Meaning is not revealed to end user - Information is the result of processing raw data to reveal its meaning o Processed/Transformed data o Context is applied to data o Facilitates decision making 3. What is structural independence, and why is it important? - Access to a file is not dependent on its structure - It’s important because: changes to the structure do not require changes to the program(s) that access the file.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Spring 2010: ISAM 5331.01 / ACCT 5333.01 4. List and describe the different types of databases. Databases are typically classified through the following categories: - Number of Users o Single Desktop o Multiuser Workgroup Enterprise - Data Location o Centralized o Distributed - Data Usage o Operational (Transactional or Production) o Data Warehouse Databases can also be classified to reflect the degree to which the data are structured: - Unstructured Data o Exists in their original (raw) state
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.

Page1 / 5

Homework_01-ver02 - Spring 2010: ISAM 5331.01 / ACCT...

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