1. define the fundamental concept of the relational database model ?
A relational database is a collection of data items organized as a set of formally described tables from which data can be accessed easily. A relational database is created using the relational model. The software used in a relational database is called a relational database management system (RDBMS). A relational database is the predominant choice in storing data, over other models like the hierarchical database model or the network model.
2. evaluate the advantages of the relational database model?
Database advantages from a business perspective include increase flexibility, increase scalability and performance, reduce information redundancy, increase information integrity (quality) and increase information security.
increase flexibility
Can manipulated the information or present in many way and in the different shape.
-have only one physical view:
physical view- deals with the physical storage of information on a storage device.
-have multiple logical views:
logical view- focuses on how users logically access information.
increase scalability and performance
A database must scale to meet increased demand, while maintaining acceptable performance levels.
-scalability
refers to how well a system can adapt to increased demands.
-performance
measures how quickly a system performs a certain process or transaction.
reduce information redundancy
Databases reduce information redundancy
-redundancy
the duplication of information or storing the same information in multiple places.
Inconsistency is one of the primary problems with redundant information.
increase information integrity (quality)
Information Integrity is a measure of the quality of information. Within a database environment integrity constraints are rules that help ensure the quality of information.
-relational integrity constraint
rule that enforces basic and fundamental information based constraints.
-business critical integrity constraint
rule that enforce business rules vital to an organization's success and often required more insight and knowledge than relational integrity constraint.
increase information security
Information is an organizational asset and must be protected. Database offer several security features including password, access level and access control.
-password
provides authentication of the user.
-access level
determines who has access to the different types of information.
-access control
determines types of user access, such as read- only access.
3. define a database management system and its relationship to a website?
Database management systems (DBMS) is a software through which users and application programs interact with a database.
Data driven websites an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.
4. explain why an organization would want to integrate its database?
Data integration refers to the organization's inventory of data and information assets as well as the tools, strategies and philosophies by which fragmented data assets are aligned to support business goals. The company want to integrate its database because they will connect, communicate, dealing and having relation with its customer everyday. Everyday its customers will open the webpage and search anything appear on the page. Therefore, if the product still available or not available the supplier must inform the customer immediately. Publish the information on the web page to make the customer realize that the product exist or not in the market. Then, when the customer got information they will not too disappointed and not waiting too long. Customers satisfy, the business relationship between sellers and customers will be effective and launch smoothly.
No comments:
Post a Comment