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.

Question

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.

Answer 1

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!

See solution

Check out sample textbook 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.

What is the function and purpose of data grouping when it comes to file organization?

Question 3 Given the file structure shown in Figure, answer Problems a – d. The figure has shown below. Assignment #1 Page 1 of 2 Introduction to Database Systems COMP112 a) How many records does the file contain? How many fields are there per record? b) 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? c) 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? d) What data redundancies do you detect? How could those redundancies lead to anomalies? Question 4 : Refer to the tables in the JustLee Books database, write the following basic statement. Each statement should be tested to ensure its validity. Create a list of each book title stored in the BOOKS table and the category in which each book belongs. Reverse the sequence of the columns so that the category of each book is listed…