Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
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
Identify 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.)
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.
A 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.
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. 3PCh. 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
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
- Please help solvearrow_forwardwhat 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_forwardWhat is the significance of declaring that the granularity of data has been established?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 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
- 1. 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_forwardProduce the 3NF for the following: Scenario 1 This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file) You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the IN of the data OrderDate 10/20/2010 10/20/2010 10/20/2010 10/21/2010 10/21/2010 10/23/2010 10/21/2010 10/23/2010 10/23/2010 OrderNum 21608 PartNum AT94 DR93 NumOrdered 11 1 Description QuotedPrice $21.95 $495.00 $399.99 $329.95 S595 00 $794.95 $150.00 $495.00 00 0621S Iron 21610 Gas Range 21610 21613 DW11 Washer KL62 Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill 21614 21617 ктоз 21617 CDS2 4. 21619 DR93 1. 21523 KV29arrow_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
- Subject: DatabaseQuestion: Draw an ERD based on the given infoarrow_forwardCase Problem 1 The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center. Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type…arrow_forward#1 - Specify all the relationships among the records of the database shown in Figure 1.2. Please refer to the below image.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:9781305971776Author:Ralph Stair, George ReynoldsPublisher: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
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
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:9781305971776
Author:Ralph Stair, George Reynolds
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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr