Question: What is the importance of using a database system within an organization, especially one created with an entity relationship diagram? What benefits would an organization
What is the importance of using a database system within an organization, especially one created with an entity relationship diagram? What benefits would an organization see from the database?
I am confused on which one it would be because they are so similar. Could use some help
1. A database maintains information about various types of objects, events, people, and places. A database management system (DBMS) creates, reads, updates, and deletes data in a database while controlling access and security. A DBMS provides methodologies for creating, updating, storing, and retrieving data in a database. In addition, a DBMS provides facilities for controlling data access and security, allowing data sharing, and enforcing data integrity. The relational database model allows users to create, read, update, and delete data in a relational database.
An entity relationship diagram is important to the creation of a database system because it manages the relationships between entities in a database. An ERD shows the logical structure of a database by containing components of data and their attributes and providing the relationship between them. Overall, an ERD is important to a database system because it is the design of how a database will function.
Many business managers are familiar with Excel and other spreadsheet programs they can use to store business data. Spreadsheets are excellent for supporting some data analysis, they offer a wide range of functionality in terms of security, accessibility, and flexibility and can rarely scale to support business growth. From a business perspective, relational databases offer many advantages over using a text document or a spreadsheet, including increased flexibility, increased scalability and performance, reduced information redundancy, increased information integrity (quality), and increased information security.
2. A database maintains information about various types of objects, events, people, and places. A database management system (DBMS) creates, reads, updates, and deletes data in a database while controlling access and security. A DBMS provides methodologies for creating, updating, storing, and retrieving data in a database. In addition, a DBMS provides facilities for controlling data access and security, allowing data sharing, and enforcing data integrity. The relational database model allows users to create, read, update, and delete data in a relational database.
An entity relationship diagram is important to the creation of a database system because it manages the relationships between entities in a database. An ERD shows the logical structure of a database by containing components of data and their attributes and providing the relationship between them. Overall, an ERD is important to a database system because it is the design of how a database will function.
Many business managers are familiar with Excel and other spreadsheet programs they can use to store business data. Although spreadsheets are excellent for supporting some data analysis, they offer limited functionality in terms of security, accessibility, and flexibility and can rarely scale to support business growth. From a business perspective, relational databases offer many advantages over using a text document or a spreadsheet, including increased flexibility, increased scalability and performance, reduced information redundancy, increased information integrity (quality), and increased information security.
3. A database maintains information about various types of objects, events, people, and places. A database management system (DBMS) creates, reads, updates, and deletes data in a database while controlling access and security. A DBMS provides methodologies for creating, updating, storing, and retrieving data in a database. In addition, there are other programs that provides facilities for controlling data access and security, allowing data sharing, and enforcing data integrity. The relational database model allows users to create, read, update, and delete data in a relational database.
An entity relationship diagram is important to the creation of a database system because it manages the relationships between entities in a database. An ERD shows the logical structure of a database by containing components of data and their attributes and providing the relationship between them. Overall, an ERD is important to a database system because it is the design of how a database will function.
Many business managers are familiar with Excel and other spreadsheet programs they can use to store business data. Although spreadsheets are excellent for supporting some data analysis, they offer limited functionality in terms of security, accessibility, and flexibility and can rarely scale to support business growth. From a business perspective, relational databases offer many advantages over using a text document or a spreadsheet, including increased flexibility, increased scalability and performance, reduced information redundancy, increased information integrity (quality), and increased information security.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
