"Database Connectivity Methods"

Performance Appraisal

Database Administrator’s Role

Database Security

business information

 
Any business information system will have two critical components: a computer network and a database system resided on the computer network. Many business related data (such as customer records, business financial data, company’s documents, employees’ records, etc.) are stored in the databases so that they can be shared among different users. Users can query databases to get the data and information they need. In 200 to 300 words, discuss the following:

  1. Why database system is a critical component of business information systems? (Tip: Please provide at least one reason.)
  2. Why IT department of a company needs to backup databases regularly? (Tip: Please provide at least one reason.)

Text File Processing

  • Visual Basic provides libraries that allow data to be read from a text file into a program. Once the data is read from the file, it can be processed in a number ways. Assume you are a developer working for a small retail company. You have been asked to develop a Visual Basic application that reads product information from a file and generates a report. The input file contains many lines of product data: Each line contains product identification, name, price, and quantity. Explain the process you would use to generate the report.
  • A program that requires data from a text file will fail if there is a problem with the text file: file may not be accessible, file may be empty, or there may not be enough system memory to process the file. What would you do in your program to avoid these pitfalls when working with text file in your program?