QUIZ 8

Quiz 8 - Database Management

1. Define the term, database, and explain how a database interacts with data
and information.

Answer: A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). 

2. Describe file maintenance techniques (adding records, modifying records,

deleting records) and validation techniques.

3. Discuss the terms character, field, record, and file

Answer:

• The Character class wraps a value of the primitive type char in an object. An object of type Character contains a single field whose type is char.

• A Field provides information about, and dynamic access to, a single field of a class or an interface. The reflected field may be a class (static) field or an instance field. ``A Field permits widening conversions to occur during a get or set access operation, but throws an IllegalArgumentException if a narrowing conversion would occur. 

4. Discuss the functions common to most database management systems:

data dictionary, file retrieval and maintenance, data security, and backup

and recovery.

Answer: The Database Library is built on a Data Dictionary, which provides a complete description of record layouts and indexes of the database, for validation and efficient data access.

The file organizer functions allow you to create folders based on information contained inside the file and outside the file system it is stored in, and move / copy the file to these folders.

5. Differentiate between a file processing approach and the database

approach.

Answer: File processing approach - each department or area within an organization has its own set of data files.

Database Approach -Many programs and users share the data in a database. Reduces data redundancy, improves data integrity, shares data, permits easier access, and reduces development time.

6. Describe characteristics of relational, object-oriented, and

multidimensional databases.

Answer: Relational Database - is a database that stores data in tables that consist of rows and columns. Each row has a primary key and each column has a unique name.

Object - oriented database (OODB) - stores data in objects. An object is an item that contains data, as well as the actions that read or process the data.

Multidimensional database - stores data in dimensions and can store more than two dimensions of data.

7. Explain how to access Web databases.

Answer:

You can use Access 2010 and Access Services, a new component of SharePoint, to build web database applications. This helps you:

• Secure and manage access to your data

• Share data throughout an organization, or over the Internet

 Note    A user account is required to use a web database. Anonymous access is not supported.

• Create database applications that don't require Access to use

8. Define the term, computer security risks, and briefly describe the types

of cybercrime perpetrators: hacker, cracker, script kiddie, corporate spy, unethical employee, cyberextortionist, and cyberterrorist.

9. Identify database design guidelines and discuss the responsibilities of

database analysts and administrators.

10. Discuss techniques to prevent unauthorized computer access and use