7 2 Homework.docx IT- 510 7-2 Homework Activity IT- 510 1. What is a DBMS? Briefly d
- From Economics, General Economics
- Termpaper
- Rating : 3
- Grade : B
- Questions : 0
- Solutions : 15269
- Blog : 0
- Earned : $2452.10
7 2 Homework.docx IT- 510 7-2 Homework Activity IT- 510 1. What is a DBMS? Briefly describe the components of a DBMS. a. Database Management System is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data. b. DBMS components consist of: Users: A query language allows users to specify a task without specifying how the task will be accomplished Database Administrators: responsible for DBMS management and support. The main concern is data security and integrity, preventing unauthorized access, providing backup and recovery, audit trails, maintaining database usage, and supporting user needs. Related Information Systems: Can support several related information systems that provide input to, and require specific data from, the DBMS Data Manipulation Language: Controls database operations, including storing, retrieving, updating, and deleting data Schema: including all descriptions of all field, table, and relationships Subschema: a view of the database used by one or more systems or users. It protects individuals from accessing information that they are not permitted to retrieve. Physical Data Repository: The data dictionary transformed into a physical data repository which also contains the schema and subschemas. It might be centralized or distribute at several locations. It could be managed by one DBMS or several systems c. Describe a primary key, candidate key, secondary key, foreign key, and a combination key. Use
[Solved] 7 2 Homework.docx IT- 510 7-2 Homework Activity IT- 510 1. What is a DBMS? Briefly d
- This solution is not purchased yet.
- Submitted On 03 Oct, 2022 12:54:22
- Termpaper
- Rating : 3
- Grade : B
- Questions : 0
- Solutions : 15269
- Blog : 0
- Earned : $2452.10