EBK USING MIS
10th Edition
ISBN: 9780134658919
Author: KROENKE
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5.8, Problem 5.4ARQ
Explanation of Solution
A database contains all the necessary information that is required for processing the business.
- The database is not useful for the business user since the contents that are present in them are structured in an unorganized way.
- The data stored in the database is present in the raw form and hence database is not ideal for the users.
Four elements of database application:
The four elements of database applications that are listed below:
- Forms
- Reports
- Queries
- Application Programs.
Purpose of the elements of database application:
The purpose of the each element is described below:
Forms:
The data present in the database can be viewed, inserted, updated and deleted using the elements.
Let us consider the example:
- Consider the student mark that needs to updates in the database.
- The form can be used to enter the marks scored by the user and the mark entered by the user can be viewed by the user through forms.
- Consider the mark that is entered by the user needs to be corrected and it can be updated through forms.
- Any student record that is not required can be deleted through forms.
Reports:
The data that are stored in the database are represented in the structural format by performing sorting, grouping, filtering and through other data manipulation process.
Let us consider the example:
A student record whose score can be viewed from highest to lowest order by using the sorting operation.
Queries:
The data values can be retrieved based on the search made by the user.
Let us consider the example:
A student whose score is greater than “90” can be viewed using the query given by the user.
Application Programs:
Application programs are used to provide security to the data, maintaining the consistency of the data and to process special purpose.
Let us consider the example:
The student data can be corrected only by the teacher who enters it the data is secured in such a way no student cannot modify the data present in the database...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
using r language The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute a 95% bootstrap t confidence interval estimates for the correlation statistics
using r language The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute a 95% bootstrap t confidence interval estimates for the correlation statistics
using r langauge
The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute and compare the three 95% bootstrap confidence interval estimates for the correlation statistics.
Chapter 5 Solutions
EBK USING MIS
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQCh. 5.3 - Prob. 2SAQ
Ch. 5.3 - Prob. 3SAQCh. 5.3 - Prob. 4SAQCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5.1ARQCh. 5.8 - Prob. 5.2ARQCh. 5.8 - Prob. 5.3ARQCh. 5.8 - Prob. 5.4ARQCh. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQCh. 5.8 - Prob. 5.7ARQCh. 5.8 - Prob. 5.8ARQCh. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Study Figure 5-28 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
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
- What is the number of derangements of size k from the set {1,2,...n} to the set {1,2,...n} so that f(x) != x exactly k times with 1 <= k <= narrow_forwardTrace a State Space Tree introduced in the Chapter 5.1 using algorithms depth_first_search (page 205), checknode (page 207), and expand (page 210). Assume that State Space Tree is a two-level full binary tree (root is level 0). Node #2 (according to notation used in the Figure 5.1, page 204) is non-promising. Count the number of steps performed by each of those three algorithms. Consider execution of instructions like "visit node" or execution of "promising function" as one step, "write a solution" as an exit call. Note: no need to print or a draw a whole tree. Just provide three numbers as an answerarrow_forwardParking Tickets Table St ID L_Name ☐ F_Name Phone_No St_Lic Lic_No Ticket# Date Code Fine 38249 38249 82453 Green 82453 Green 82453 Green Brown Thomas 111-7804 FL BRY 123 15634 10/17/06 2 $25 Brown Thomas 111-7804 FL BRY 123 16017 11/13/06 1 $15 Sally 391-1689 AL TRE 141 14987 10/05/06 3 $100 Sally 391-1689 AL Sally 391-1689 AL TRE 141 TRE 141 16293 11/18/06 1 $15 17892 12/13/06 2 $25 The functional dependencies are: St_ID → L_Name, F_Name, Phone_No, St_Lic, Lic_No St_Lic → Lic_No Code → Fine St_ID, Ticket # → Date 1. In what normal form is the relation?| 2. Convert PARKING TICKET to a set of 3NF relations.arrow_forward
- In excel, What does sorting mean? In excel, What does filtering mean? What are three advantages of converting a range in Excel to a table and List the steps involved in creating a table in Excel if you were using the range A7:G34arrow_forwardConvert the relation Parking Tables to a set of 3NF relations.arrow_forwardPlease original work What is the importance of understanding both DSS models and OLAP in modern business analytics. Reflect on how the combination of these tools can enhance decision-making processes in organizations. Please cite in text references and add weblinksarrow_forward
- Please original work Talk about the role of Decision Support Systems (DSS) in business analytics. What are the major types of models used in DSS: optimization, simulation, forecasting, heuristic, and descriptive models. Talk about the relevance of these models in supporting business decisions. Please cite in text references and add weblinksarrow_forwardPlease original work What are two DSS models (e.g., optimization and forecasting). What are each model’s purpose, advantages, and limitations in the context of business analytics. Talk about some examples of how each model can be applied in real-world business scenarios, particularly in operations, marketing, or finance. Please cite in text references and add weblinksarrow_forwardPlease original work What is Online Analytical Processing (OLAP) and describe its role in DSS. Talk about how OLAP supports multidimensional analysis and decision-making in businesses. Compare how OLAP differs from traditional DSS models in terms of data processing and output. Please cite in text references and weblinksarrow_forward
- Please original work Describe the key steps involved in the modeling process: problem definition, data collection, model formulation, validation, implementation, and refinement. Talk about why each step is critical to ensuring the accuracy and reliability of the model. What are some real-world business example of a problem, and describe how the modeling process could be applied to address it using DSS. Please cite in text references and add weblinksarrow_forwardYou will be using the "usdata" package's "county" data # for this assignment. # You will need to run:# install.packages("usdata")# once to install this library - do not include the# install.packages command in your submission# as it can cause gradescope to fail ## ## ## ## ## DO NOT MODIFY BELOW ## ## ## ## ## library(usdata)county<-as.data.frame(county)county<-county[,1:14]county<-county[rowSums(is.na(county))==0,]# The set.seed command will ensure your results are consistent# each time you run the "source" commandset.seed(311)## ## ## ## ## DO NOT MODIFY ABOVE ## ## ## ## ## # Treating the "county" dataset as the population of US counties# create the dataframe "my.SRS" that represents a simple# random sample of n=250 individual counties from all counties in the US. my.SRS <- NA # Treating the "county" dataset as the population of US counties# create the dataframe "my.Stratified" that represents a stratified# sample of individual counties from all counties in…arrow_forwardPlease answer two JAVA OOP problems.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher: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
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
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
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning