Database Systems: Design, Implementation, & Management
11th Edition
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
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
Trending nowThis is a popular solution!
Students have asked these similar questions
Problem statement:
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. Southern Arkansas University (SAU) IT Group has recently approached your company with a view to implementing a database system for SAU, but they are not familiar with the development process. You are required to present an overview of the fact-finding techniques that your company intends to use to support the development of SAU’s database system. With this task in mind, create a 6-page report (Times New Roman, 12 font-size, double space) that describes each fact-finding technique and how the fact-finding techniques will be used throughout (each step of) the development of the database system.
#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
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_forwardAssignment 1: ER Model Arkansas Basketball Conference is an amateur basketball association. It has contacted you to create a database that will meet the expected data requirements for its basketball game management program. The administrator gives you the following description of the group's operating environment. Each city in the county has one team that represents it. The database will maintain information about cities (CityID, Name, and State) and teams (TeamID, Name, and Mascot). Each team has a number of players. Each player belongs to one team. Player information (such as PlayerID, FName, LName, and Position) will be maintained in the database A team has many coaches (e.g., head coach, offensive coaches, defensive coaches etc.). Each coach belongs to one team. The database will store information on coach such as CoachID, Name, Phone, and Title. A team plays many games against other teams during the season. Each game involves two teams. The game information (such as GamelD,…arrow_forwardExplain the five different file structures (Pile, Sequential file, Indexed Sequential file, Indexed file, and hashed file). And analyze the components, attributes, structure, and operations or implementation guidelines of each file organization.arrow_forward
- Database Authorization Table (Personnel under DBA) The following information is stored in two database files for Company X:Vendor Table:- Vendor Number- Vendor Address- Tel NumberPurchase Order Table- PO Number- Vendor Number- Product Number- Quantity- Order DateNote: The company is under a distributed data processing environment and employs the centralized approach for database management. Given this arrangement, master data maintenance (e.g. customer and vendor codes) are under the ownership of the master data management (MDM) team led by the database administrator. Complete the Database Authorization Table for a master data maintenance personnel of Company X.arrow_forwardIdentify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.9. (The file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy is the likely occurrence of data inconsistencies—two different initials have been entered for the teacher named Maria Cordoza.)arrow_forwardThe 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_forward
- Describe 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_forwardLogical level of data abstraction deals with how a record is stored. True or False?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_forwardCite some desired attributes, functionalities, features for a file organization design.arrow_forward1. Distinguish between database transactions and database operations with the use 2. For a transaction in a database, identify FOUR (4) aspects that might affect performance and therefore need to be documented during physical design. 3. How might the use of an index affect different types of database operations?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