Nội dung chính Show
Recommended textbook solutionsComputer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Engineering Electromagnetics8th EditionJohn Buck, William Hayt 483 solutions Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions Recommended textbook solutionsIntroduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Fundamentals of Python: First Programs2nd EditionKenneth Lambert 419 solutions -Examine JC Consulting (JCC), the company used for many of the examples throughout the text -Define basic database terminology -Describe database management systems (DBMSs) -Explain the advantages and key factors for a healthy relational database system -Prepare for a career in database administration -Review Pitt Fitness, a company used in a case that appears at the end of each module -Review Sports Physical Therapy, a company used in another case that appears at the end of each module Upgrade to remove ads Only SGD 41.99/year How do you want to study today?
Terms in this set (31)What is redundancy? Redundancy is the duplication of data or the storing of the same data in more than one place. What problems are associated with redundancy? Redundancy can cause inconsistencies in the data, leading to missing information, and poor decision making from the data. Besides redundancy, what other problems are associated with the nondatabase approach to processing data? In a non-database, data is often partitioned into several disjointed systems, with each system having its own collection of files. This makes it harder to find all of the information needed. In a non-database, data stored could be incorrect via the various files. Without databases we could also lose referential integrity and overall security. What is an entity? An entity is a person, place, object, event, or idea for which you want to store and process data. What is an attribute? An attribute is a characteristic or property of an entity; also called a field or column. What is a relationship? A relationship is an association between entities. What is a one-to-many relationship? A one-to-many relationship is a relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity, and each occurrence of the second entity is related to only one occurrence of the first entity What is a database? A structure that can store information about multiple types of entities, the attributes of these entities, and the relationships among the entities. What is an E-R diagram? A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate. What is a DBMS? DMBS stands for database management system and is a program, or a collection of programs, through which users interact with a database. DBMSs let you create forms and reports quickly and easily, as well as obtain answers to questions about the data stored in a database. What is database design? The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users. What is a form? A screen object you use to maintain, view, and print data from a database. What is an integrity constraint? A rule that must be followed by data in a database. How does consistency result from controlling redundancy? By reducing the duplication of the same data, the chance of there being a discrepancy between the files is also reduced. This keeps the information on each file more consistent. What is security? The prevention of unauthorized access to a database. What is data independence? Data independence is the property that lets you change the structure of a database without requiring you to change the programs that access the database. An attribute is a characteristic or property of an entity. If person is an entity, would the same attributes be used to describe a person in different databases that store medical, student, and fitness club data? Why or why not? If a person is an entity, then yes you could store medical, student, and fitness club data as attributes of that person. These characteristics could also be used to describe many entities/people. If a database is not maintained or if incorrect data is entered into the database, serious problems can occur. What problems could occur if a student database is not maintained? If a student database is not maintained the student may lose records of past courses, dorm assignments, or loss of meal options. How is file size a disadvantage in a database environment? To support all the complex functions that it provides to users, a DBMS must be a large program that occupies a great deal of disk space as well as a substantial amount of internal memory. In addition, because all the data that the database manages for you is stored in one file, the database file requires a large amount of disk space and internal memory. How does a DBMS provide security? DBA can assign passwords to personnel to gain access to the data in the database. Further, a DBMS lets you assign users to groups, with some groups permitted to view and update data in the database and other groups permitted only to view certain data in the database Why might recovery of data be more difficult in a database environment? Recovery of data from a database environment is more difficult because a database is more complex and recovery after failure is more complicated than the recovery of a single file. Many entities are tied to files in a database, unlike a single file. Why can a failure in a database environment be more serious than an error in a nondatabase environment? In a database environment there may be many users, so a failure could disrupt the system for many users. In a nondatabase environment, the failure would only effect the individual user. What are some specific inputs that may result in big data? Some specific inputs that may result in big data are data produced by every digital process, system, sensor, mobile device, and social media exchanges. This includes information about customers, transactions, and suppliers. How can the complexity of a DBMS be a disadvantage? The complexity of a DBMS is a disadvantage because users of the DBMS must master many of the features of the system in order to take full advantage of it. In the design and implementation of a new system, many decisions have to be made; it is possible to make incorrect choices, which may ultimately ruin the whole project. Why is data independence desirable? Data independence is the property that lets you change the structure of a database without requiring you to change the programs that access the database. Data independence is desirable because without it the user would have to do a great amount of work to input the data into the database's structure. When does a database have integrity? A database has integrity when all of the integrity constraints have been met. What is a DBA? A DBA is a database administration and is the individual or group that is responsible for a database What kinds of responsibilities does a DBA have in a database environment? Assigning passwords to authorized personnel, structuring data to be beneficial to the organization and not just a group, and limiting exposure of data based on the user's clearance level. What is meant by the sharing of data? Databases allow multiple users to access the same information, i.e. share information with each other. How can you get more information from the same amount of data by using a database approach instead of a nondatabase approach? In a nondatabase approach, it can be difficult, to obtain the desired information from data spread across several disjointed systems. If the data is stored in a single database, the information becomes available, and obtaining it is quick and easy How do you create a one-to-many relationship in a database system? In a one-to-many relationship entities and attributes are represented. A line connecting the entities represents the relationship. The one part of the relationship does not have an arrow on its end of the line, and the many part of the relationship is indicated by a single-headed arrow pointing at the entities. Recommended textbook solutionsIntroduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 720 solutions Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions Operating System Concepts9th EditionAbraham Silberschatz, Greg Gagne, Peter B. Galvin 489 solutions Introduction to the Theory of Computation3rd EditionMichael Sipser 389 solutions Sets with similar termsDatabase management Ch233 terms ryo_matsuda9 DSS Chapter 668 terms lindsay_le_van CMIS 351 Lesson 6 Study Questions18 terms leslie505 IT 214 Chapter #155 terms lindsay_beckett Other sets by this creatorFIN 330 Exam 168 terms emily_renee19 Operations Management Final Exam107 terms emily_renee19 Econ 306 Final WKU84 terms emily_renee19 MGT 314 Exam 369 terms emily_renee19 Other Quizlet setsBRIT LIT QUESTIONS PERIOD 522 terms makayla_ross9 PHYSICS QUIZ 115 terms dramirezmunoz Head, Face and Neck Soft Tissue Injuries27 terms smithcd06 Physiology HW 118 terms osander10 Related questionsQUESTION When will Google Analytics end a default session? 15 answers QUESTION What's the best way to improve the machine learning algorithm's ability to recognize Ethiopian meals? 2 answers QUESTION The default sort order of a query result is ascending by the first column in the Order by clause. 2 answers QUESTION In the query design view, use what to format a column: 2 answers What data means duplication of data?Duplication of data is called data redundancy. When the same data is duplicated in multiple files of a database?Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many businesses. What is data redundancy quizlet?---Data Redundancy, is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. What is data duplication in database with example?Data duplication means that a data source has multiple records, usually with different syntaxes for the same object. This problem has been recognized as extremely important to many organizations, due to the size and complexity of today's database systems. Is the duplication of data or the storing of the same data in more than one place?Redundancy is the duplication of data or the storing of the same data in more than one place.
What is the duplication of data or the storage of the same data in multiple places multiple choice question?Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many businesses.
What database term is defined as the duplication of data or the storing of the same data in more than one place in a data file?Data redundancy refers to the practice of keeping data in two or more places within a database or data storage system. Data redundancy ensures an organization can provide continued operations or services in the event something happens to its data -- for example, in the case of data corruption or data loss.
What occurs when the same data is duplicated in multiple files of a database?Data redundancy occurs when the same piece of data is duplicated unnecessarily in multiple places in a database.
|