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
Concept explainers
Question
thumb_up100%
Chapter 1, Problem 8P
Program Plan Intro
Data redundancy:
- Data redundancy is the presence of repeated data in the storage device. It consists of duplicate data that is additional to the actual data.
- In this, the data related to a folder can be seen in other folders also. 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
Inserting data into a flat-file database is very straightforward and usually amounts to simply tacking
the new data onto the end of the data file. For example, inserting a new megalith record into a colon-
How many records does the file contain? How many fields are there per record?
What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?
If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?
What data redundancies do you detect? How could those redundancies lead to different types of anomalies?
A primary index is created on a
a) non-key, non-ordering attribute of a file
b) non-key, ordering attribute of a file
c) key, non-ordering attribute of a file
d) key, ordering attribute of a file
Chapter 1 Solutions
Database Systems: Design, Implementation, & Management
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A unique secondary index is created on a a) non-key, non-ordering attribute of a file b) non-key, ordering attribute of a file c) key, non-ordering attribute of a file d) key, ordering attribute of a filearrow_forwardanswer question in photo plsarrow_forwardThe following record structure describes a movie file: the title of the film, the director's style, and the budget Assume that the file's primary key is the title of the film. The field type describes the genre of the film, such as drama, science fiction, horror, crime thriller, comedy, etc. Enter a sample set of records into the movie file of your choosing.i) Create a primary ISAM file organisation system based on indexes.ii) Put in place supplementary indexes for the director, type, and cost of production.iii) How may Programming Assignment 3's secondary index-based file organisation be utilised to respond to a question like "Which directors have overseen comedies or dramas that have incurred the highest production costs?arrow_forward
- *C programming Write a ccdel program that takes an item number as a command line argument and deletes that item from the database. All other items should remain in their current positions with their current item numbers. Include proper file locking.arrow_forwardThe optimum file arrangement in which all data records must be processed in a file namedarrow_forwardWhen 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_forward
- File type formats and markers in each file type that are unique. For example header signatures, tail signatures, intermediate markers. Make a detailed presentation of these markers for the file type selected by you. The focus should be how you can use these markers to identify blocks that belong to this filetype. The file type is .AVIarrow_forwardLogical level of data abstraction deals with how a record is stored. True or False?arrow_forwardThe personnel department keeps records of all the employees of a company. The information stored in one of the data files is: employee identification number, last name, first name, middle initial, department, number of years with the company, salary, education (coded as high school, some university or university degree ), and age. The cases are: Select one: a. company employees b. the information saved c. personnel department d. data filesarrow_forward
- The following tables provide a very small portion of the data that will be kept in the database. These data need to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 65. RENTAL RENT_NUM RENT_DATE MEM_NUM 1001 01-MAR-13 103 1002 01-MAR-13 105 1003 02-MAR-13 102 1004 02-MAR-13 110 1005 02-MAR-13 111 1006 02-MAR-13 107 1007 02-MAR-13 104 1008 03-MAR-13 105 1009 03-MAR-13 111 VIDEO VID_NUM VID_INDATE MOVIE_NUM 54321 18-JUN-12 1234 54324 18-JUN-12 1234 54325 18-JUN-12 1234 34341 22-JAN-11 1235 34342 22-JAN-11 1235 34366 02-MAR-13 1236 34367 02-MAR-13 1236 34368 02-MAR-13 1236 34369 02-MAR-13 1236 44392 21-OCT-12 1237 44397 21-OCT-12 1237 59237 14-FEB-13 1237 61388 25-JAN-11 1239 61353 28-JAN-10 1245 61354 28-JAN-10 1245 61367 30-JUL-12 1246 61369 30-JUL-12 1246arrow_forwardA database user manually notes that The file contains two hundred records, each record containing nine fields. Use appropriate relational database terminology to translate that statement.arrow_forwardsubject : computer science Question : Torrent is a file/data distribution system used for sharing data over theinternet. You are required to explain the working of torrents. also write down the role of a database in managing torrents.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
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
C++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology Ptr
Systems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher: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
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning