Monday, May 11, 2009

Finals Question #1

Finals Question#1

For those who are working, interview your IT in-charge and ask him/her to describe the computer database systems used in the company. Write your answer in 1-2 paragraphs. Further, ask also the benefits and/or disadvantages derived from these database systems.

For those who are not working, research one company in the net who is using computerized database systems. Describe the use and/or nature of these systems and describe too the benefits/disadvantages from these systems. Include your reference.


The US based firm "Cisco Systems", a world leader of internet solutions for the web, has recently awarded a special certificate for the Tunisian computer networking "3S ", for Standard, Sharing, Software.

Database objects has two benefits over other storage approaches: it provides higher performance management of objects.


Database advantages include the following:

  • shared data;
  • centralized control;
  • disadvantages of redundancy control;
  • improved data integrity;
  • improved data security, and database systems; and,
  • flexible conceptual design.

Disadvantages are as follows:

  • a complex conceptual design process;
  • the need for multiple external databases;
  • the need to hire database-related employees;
  • high DBMS acquisition costs;
  • a more complex programmer environment;
  • potentially catastrophic program failures;
  • a longer running time for individual applications; and,
  • highly dependent DBMS operations.


In this company Relational databases are by far the most useful type commonly available, and this training module focusses largely on them, after looking briefly at flat file text databases.A rational database is a database that groups data using common attributes found in the data set. The resulting "clumps" of organized data are much easier for people to understand.
For example, a data set containing all the real estate transactions in a town can be grouped by the year the transaction occurred; or it can be grouped by the sale price of the transaction; or it can be grouped by the buyer's last name; and so on.Such a grouping uses the Relational model(a technical term for this Schema). Hence such a database is called a "relational database."The software used to do this grouping is called a rational database management system. The term "relational database" often refers to this type of software.Relational databases are currently the predominate choice in storing financial records, manufacturing and logistical information, personnel data and much more.


Debbie Ann T. Templonuevo
www.ask.com

No comments:

Post a Comment