Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
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
What is the function and purpose of data grouping when it comes to file organization?
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.
Data Normalisation
Normalisation is the process of organizing data in a database. This includes creating tables and
establishing relationships between those tables according to rules designed both to protect the data
and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Source: [Online] https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description [Accessed on: 8 March 2020]
For an industry of your choice, obtain a business document (preferably a form).
Using the form obtained:
1.1 Upload the form obtained and give a brief background explanation of the business logic for
which the form was designed.
1.2 Normalise the data contained within the form to the 3rd Normal Form.
Chapter 1 Solutions
Database Systems: Design, Implementation, & Management
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. 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_forwardQuestion 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…arrow_forwardHow do data dictionaries assist in enforcing data integrity constraints?arrow_forward
- Assignment 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_forwardDistinguish between a relation and a traditional file in the simplest terms possible.arrow_forwardDatabase 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_forward
- Part A - Database design case study In this part, you need to provide a short description of the application/website for which you will be designing the database (The overview of your own/chosen case study that is related to the assignment topic), outline the basic functions that your database needs to support, identify the data requirements, and business rules.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_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
arrow_back_ios
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