1. Define the term, database, and explain how a database interacts with data and information.
A database is an organized collection of data for one or more purposes, usually in digital form.
The term "database" refers both to the way its users view it, and to the logical and physical materialization of its data, content, in files, computer memory, and computer data storage
2. Describe file maintenance techniques (adding records, modifying records, deleting records) and validation techniques.
3. Discuss the terms character, field, record, and file
Character is a unit of information that roughly corresponds to a grapheme, grapheme-like unit, or symbol, such as in an alphabet or syllabary in the written form of a natural language.
The elements of records are usually called fields or members.
A record is a value that contains other values, typically in fixed number and sequence and typically indexed by names.
A computer file is a block of arbitrary information, or resource for storing information, which is available to a computer program and is usually based on some kind of durable storage.
4. Discuss the functions common to most database management systems: data dictionary, file retrieval and maintenance, data security, and backup and recovery.
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.
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.
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.
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
9. Identify database design guidelines and discuss the responsibilities of database analysts and administrators.
10. Discuss techniques to prevent unauthorized computer access and use
No comments:
Post a Comment