chapter 7: Storing Organization Information-Database

chapter 7: Storing Organization Information-Database 

QUESTIONS:

1. Define the fundamental concepts of the relational database model. 
2.  Evaluate the advantages of the relational database model 
3.  Define a database management system and its relationship  to a website. 
4. Explain why an organization would want to integrate its database.

  

    

ANSWERS:

Number 1:

 A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.

In example: computerized library system, automated teller machines  
                  (ATM) and flight reservation systems.

besides that,it is shows how the internal organization can affect how quickly and flexibly you can extract information from this database.

This software are gathered all of the information in one central database..


Number 2:

• Increase flexibility - who access the database will able get the information based on their users of database.
• Increase scalability and performance- which is to looked at the performance of organization. Scalability is how well the systems can adapt to increase demand. Meanwhile, performance is base on the how quickly systems performs during transaction.
• Reduced information redundancy- which is to reduce duplication of information.
• Increase information integrity(quality)-measure quality of  information.
• Increase information security- which is to maintain information integrity using password, access levels and access control.

 
 Number 3: 

Database Management System(DBSM) is how the software can interact within users and application programs. How the DBMS manipulate the data information through database. The example is online shopping.How the owner want to fulfill the customer demand with the information for the warehouse data. Besides that, organization can measure their performance using the website. Which is how many visitors every day reach to the website,

 

Number 4:

 

the organization should integrates the database because to ensure there no duplication of information. Means, no need  difference people key in the same database information. it is also increase flexibility because difference users with difference purpose can using one database according to their purpose.

The organization increase their performances and quality of database.