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
Chapter 1, Problem 9P
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 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.
Which of the studied data structures in this course would be the most appropriate choice for
the following tasks? And Why?
a. An Exam Center needs to maintain a database of 3000 students' IDs who registered in a
professional certification course. The goal is to find rapidly whether or not a given ID is in
the database. Hence, the speed of response is very important; efficient use of memory is
not important. No ordering information is required among the identification numbers.
It is recommended that the following be covered in every training session for a new user of the school database:
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
- Which of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why?  a) A training institute needs to maintain a database of 2000 identification numbers of trainees who received an ICDL certification. The goal is to find rapidly whether or not a given ID is in the database. Ordering information among the identification numbers is not important; speed of response is very important; efficient use of memory is also important, but not as important as speed of response.  b) A large fixed content of data needs to be maintained. It is sorted and the admin needs to search for and retrieve existing items, but no new/existing items will be inserted/deleted. You may assume that the data can fit inside the memory of the computer.  c) A transposition table is a cache of previously seen positions in a game tree generated by a computer game playing program. If a position recurs via a different sequence of moves, the value of the position is…arrow_forwardWhich of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? a) A training institute needs to maintain a database of 2000 identification numbers of trainees who received an ICDL certification. The goal is to find rapidly whether or not a given ID is in the database. Ordering information among the identification numbers is not important; speed of response is very important; efficient use of memory is also important, but not as important as speed of response.  b) A large fixed content of data needs to be maintained. It is sorted and the admin needs to search for and retrieve existing items, but no new/existing items will be inserted/deleted. You may assume that the data can fit inside the memory of the computer. To be submitted through Turnitin. Maximum allowed similarity is 15%.arrow_forwardA database at a college is required to support the following requirements. Complete the information-level designfor this set of requirements. Use your own experience to determine any constraints you need that are not statedin the problem. Represent the answer in DBDL.a. For a department, store its number and name.b. For an advisor, store his or her number and name and the number of the department to which he or she isassigned.c. For a course, store its code and description (for example, MTH110 or Algebra).d. For a student, store his or her number and name. For each course the student has taken, store thecourse code, course description, and grade received. In addition, store the number and name of thestudent’s advisor. Assume that an advisor may advise any number of students but that each studenthas just one advisor.arrow_forward
- Design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. 1) Tables: Fields (keys in yellow, foreign keys in blue) Account: id (number), customer (number), balance (number), limit (number), status (short text, maximum length 10) Customer: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), address (short text, maximum length 40), zip code (short text, input mask 00000-0000), email (short text, maximum length 30), agent (number), birthday (short date format, mm/dd/yyyy) Agent: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), email (short text, maximum length 30), phone (short text with 000-000-0000 input mask), location (number) Location: id (number), code (number), name (short text, maximum length 20), address (short text,…arrow_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_forwardBizMic Multiples BizMic Multiples is an IT company that manages the Gauteng Province database system. In the past, they built a system that stores and accesses records of all the SA citizens in Gauteng Province in a direct access table. A direct access table involves the creation of a big array and uses phone numbers as an index in the array. As time goes on and the population continues to grow, it has now become very difficult to access a record from the traditional method. The system has now become very slow due to a large amount of records stored in it. The BizMic Multiples IT Company has consulted with an auditing firm who recommended a system that uses an array that stores pointers to records corresponding to a given record. This system, known as Hash Data Structures or simply Hash Table, is intended to improve on the existing system. As the lead IT intern at BizMic Multiples, your unit (you and your team members) is saddled with the responsibility of overseeing the success of the…arrow_forward
- Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…arrow_forwardDistinguish among data definition commands, data manipulation commands, and data control commands.arrow_forwardExplain the key differences between a stored procedure and a user-defined function in the context of database functions.arrow_forward
- 33. A relational database developer refers to a record as a. a criteria b. a relation c. a tuple d. an attributearrow_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_forward1. Create an EER diagram to show the following information about a university database:  Professors have an SSN, a name, an age, a rank, and a research specialty.  Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget.  . Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.).  . Each project is managed by one professor (known as the project’s principalinvestigator).  . Each project is worked on by one or more professors (known as the project’s co-investigators).  . Professors can manage and/or work on multiple projects.  . Each project is worked on by one or more graduate students (known as the project’sresearch assistants).  . When graduate students work on a project, a professor must supervise their work onthe project. Graduate students can work on multiple projects, in which case they willhave a (potentially different) supervisor for each one.  . Departments have a department number, a department…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning