Assalamualaikum,
1. Define the fundamental concepts of the relational database model
 |
| Database Icon |
A database is a collection of information that is organized so that it can easily be accessed, managed and updated. In one view, databases can be classified according to types of content : bibliographic, full-text, numeric and images. There are three types of model for organizing information in a database including the hierarchical database model, network database model and the most prevalent-the relational database model.
 |
| The Relational Database Model |
Relational database :
- a collection of data items organized as a set of formally-described tables from which data can be assessed or reassembled in many different ways without having to reorganize the database tables. The best example of situation for this relational database model is at the hospital. Patients in and out endless. This can be tiresome whenever the doctor or staff on duty need to check on the patients. Hence, with the use of this Relational Database model, these patient's data can be accessed at anytime without having difficulties to reorganize the database tables.
2. Evaluate the advantages of the Relational Database Model
3. Define a database management system and its relationship to a website
Database Management System (DBMS) is a program that lets one or more computer users create and access data in a database. It manages user requests and requests from other program so that users and other programs are free from having to understand where the data is physically located on storage media and in a multi-user system, who else may also be accessing the data.
There is a very close relationship between Database Management System (DBMS) and a website. The website provides the user-interface to send requests to DBMS and to receive processed results from DBMS. The DBMS processes the requests and returns the results to the website and also controls and manages the database. The website programmer should have the complete knowledge about DBMS and databases used in it, and then he can easily develop the website. For instance, Wikipedia is a website that provides all the conveniences of answer to every question asked by its user. As far as we know, this website can be edited by its users. Its user will sent information and website programmer will received it. The DBMS processes the requests and returns the results to the website and also controls and manages the database.
4. Explain why an organization would want to integrate its database
Integrated databases help organizations get more value from from their diverse data sources by making data management process available as portable services that applications throughout the enterprise can use on demand. Beside that, an organization can reduce information redundancy. Duplication of information frequently happens when too many users access the information and that's why an organization need to integrate its database.
2. Evaluate the advantages of the Relational Database Model
- Structural independence : in the Relational model, changes in the structure do not affect the data access
- Design implementation : the Relational model achieves both data independence and structural independence
- Conceptual simplicity : we have seen that both the Hierarchical and Network models are conceptually simple, but Relational model is simpler than both of those two
- Increase flexibility : who access the database will able to get the information based on their users of database
- Reduced information redundancy : to reduce duplication of information
- Increase information security : to maintain information integrity using password, access levels and access control
Database Management System (DBMS) is a program that lets one or more computer users create and access data in a database. It manages user requests and requests from other program so that users and other programs are free from having to understand where the data is physically located on storage media and in a multi-user system, who else may also be accessing the data.
There is a very close relationship between Database Management System (DBMS) and a website. The website provides the user-interface to send requests to DBMS and to receive processed results from DBMS. The DBMS processes the requests and returns the results to the website and also controls and manages the database. The website programmer should have the complete knowledge about DBMS and databases used in it, and then he can easily develop the website. For instance, Wikipedia is a website that provides all the conveniences of answer to every question asked by its user. As far as we know, this website can be edited by its users. Its user will sent information and website programmer will received it. The DBMS processes the requests and returns the results to the website and also controls and manages the database.
4. Explain why an organization would want to integrate its database
Integrated databases help organizations get more value from from their diverse data sources by making data management process available as portable services that applications throughout the enterprise can use on demand. Beside that, an organization can reduce information redundancy. Duplication of information frequently happens when too many users access the information and that's why an organization need to integrate its database.
No comments:
Post a Comment