Database Systems: Design, Implementation, Management, Loose-leaf Version
12th Edition
ISBN: 9781305866799
Author: Coronel, Carlos; Morris, Steven
Publisher: Course Technology
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 5P
Program Plan Intro
Data redundancy:
- Data redundancy is presence of repeated data in the storage device. It consists of duplicate data that is additional to the actual data.
- In this case, the data related to a folder can be seen in other folders. For example, file related to science folder can be seen in mathematics or social.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Distinguish between data definition commands, data manipulation commands, and data control commands, and use them appropriately.
#1 - Specify all the relationships among the records of the database shown in Figure 1.2. Please refer to the below image.
The Database Approach is the preferred method in today's business environment for database structure. Identify three reasons why this method is preferred over the File Approach.
Chapter 1 Solutions
Database Systems: Design, Implementation, Management, Loose-leaf Version
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Prob. 5RQCh. 1 - Prob. 6RQCh. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - Prob. 9RQCh. 1 - Prob. 10RQ
Ch. 1 - Prob. 11RQCh. 1 - Prob. 12RQCh. 1 - Prob. 13RQCh. 1 - What are some basic database functions that a...Ch. 1 - Prob. 15RQCh. 1 - Prob. 16RQCh. 1 - Prob. 17RQCh. 1 - Prob. 1PCh. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Prob. 5PCh. 1 - Prob. 6PCh. 1 - Prob. 7PCh. 1 - Prob. 8PCh. 1 - Prob. 9PCh. 1 - Prob. 10PCh. 1 - Using your schools student information system,...
Knowledge Booster
Similar questions
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forwardHow do data dictionaries assist in enforcing data integrity constraints?arrow_forwardI understand the purpose of a database, which is to make data record-keeping easier for any company. And I'm aware of the hardware requirements. The concept of programming the rules and structure of a database is the area in which I am most confused. A database, in my mind, is a chart (or many charts) containing fields that are used to hold records. Then, of course, those records in one chart interweave with those in other charts, necessitating the creation of chart linkages. The concept of developing a framework for the data to fit into is where I get stuck. Are we creating metaphysical venues to store data, or are we just recording relationships between data saved on a variety of platforms?arrow_forward
- The Database Technique is the preferred approach in the business sector nowadays when it comes to database construction. Take into account the following three justifications for why this approach is better than the File Approach:arrow_forwardDescribe the concept of data fragmentation in a distributed database. What are the different types of data fragmentation strategies, and when is each strategy appropriate?arrow_forwardExplain the concept of user-defined data types (UDTs) in database systems. How can UDTs be used to represent complex data structures, and what are the benefits of using them?arrow_forward
- what is the definition of data independence? a) It is the principal that there are specific database requirement for every database system. b) it is the principal that requires database program to use an application programming interference. c) it is the principal that the database design process can be either informal or structured. d) It is the principal that the physical design of a table never affects the result of a queryarrow_forwardQuestions: p/s : the first column first row (highlighted) is 1 a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7. b) How many different data sources are likely to be used by the file you examined in problem a? c) Given your findings in Problems a and b, how would a relational database environment help eliminate the data redundancy problems? d) Given your answer to Problem c, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend? e) Given your answers to problem d, show the table contents for each table. f) Identify the types of relationships (1:1, 1:M, or M:N) between the tables you defined in problems d and e. g) Create a relational schema for Problem f.arrow_forwardDo database designers need to be aware of any specific technique that, when used in certain situations, has the potential to have a significant impact on a database's performance?arrow_forward
- When you use the word "metadata," what precisely do you mean by that? The following is an explanation of what metadata is in the context of a data set: When may it be advantageous to make use of the metadata that has been taken from a result set?arrow_forwardExplain the concept of data binding in the context of database applications. How does it differ from front-end data binding?arrow_forwardDo database designers need to be aware of any particular technique that, when used in certain situations, has the potential to have a significant impact on a database's performance?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning