Assignment 1

docx

School

American Military University *

*We aren’t endorsed by this school

Course

222

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by JusticeOxideHawk121

1. Data – anything translated into a form that can be used for movement or processing 2. Database – anything that stores data and also contains information about the relation of said data to each other 3. Database Management System (DBMS) – software that translates a request for store data 4. Database Application Programs – provides a way for data to be used by end users or higher- level applications 5. Data Independence – ability to modify the scheme at one level of the data base without altering another 6. Data Security – protects data from unwanted access or corruption and example would be encryption or requiring a login 7. Database Integrity – overall completeness, accuracy and consistency of data over its entire life 8. Database View – subset of a database and is based on a query that runs on one or more database tables 9. Evolution of relational databases as a tool for information management – a relational database allows the user to organize data, this is very helpful because it allows an automatic sorting instead of you having to look through all the take and extract what you need. 1. What is concurrency control and why does a DBMS need a concurrency control facility? Concurrency control is the management procedure that is required for controlling concurrent execution of the operations that take place on a database. It allows for multiple users to use the database at once. This is especially important in workplace that require several members to access the data and if they have multiple locations. 2. Why is learning about database and its use important to you? Which database is your information stored in (list at least two)? Are they concurrency control databases? I use them for accessing course material and student data for the classes I teach. Understand databases will help me improve other processes as well, the Air Force still does a lot of things the old way and database can help modernized how we collect and use the data we collect. Microsoft Access and Oracle, they are both concurrency-controlled databases. 3. Does the Classroom for this course demonstrate a need for Concurrency Control? Explain. Yes, all of the student and the instructor would need to access course materials possibly at the same time.

References DBMS Concurrency Control - javatpoint . (n.d.). Www.javatpoint.com. https://www.javatpoint.com/dbms-concurrency-control DBMS Data Independence - javatpoint . (n.d.). Www.javatpoint.com. https://www.javatpoint.com/dbms-data-independence IBM. (2019, May 6). Database views . Www.ibm.com. https://www.ibm.com/docs/en/control- desk/7.6.1.2?topic=structure-views IBM. (2021). What is data security? Definition, solutions and how to secure data . Www.ibm.com. https://www.ibm.com/topics/data-security IBM. (2023). Relational Databases Explained | IBM . Www.ibm.com. https://www.ibm.com/topics/relational-databases Shibboleth Authentication Request . (n.d.). Login.ezproxy2.Apus.edu. Retrieved November 14, 2023, from https://learning-oreilly-com.ezproxy2.apus.edu/library/view/relational- database- design/9780128499023/B9780128043998000016/B9780128043998000016.xhtml#st002 0 Vaughan, J. (2019, July). What is Data? - Definition from WhatIs.com . SearchDataManagement. https://www.techtarget.com/searchdatamanagement/definition/data What Is A Database Application? (n.d.). MongoDB. https://www.mongodb.com/basics/database- application What is Data Integrity in Databases? - Definition from Techopedia . (2019). Techopedia.com. https://www.techopedia.com/definition/811/data-integrity-databases

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Assignment 1

Related Documents