EBK USING MIS
EBK USING MIS
10th Edition
ISBN: 8220103633635
Author: KROENKE
Publisher: YUZU
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
Chapter AE, Problem AE1.2

Explanation of Solution

a.

  • Mention a query as a manager of Denver plant to know the amount of time employees are spending on special project:

    To know the amount of time employees are spending on special project can be answered directly by the Denver Sum query which is accurate, relevant and sufficient. The answer to amount of time employees are spending on special project can also be answered by the Plant Sum query for Denver and the other two plants.

  • Mention a query as a manager of Reno plant to find the amount of time employees are spending on special projects:

    There is not a single query that answers the amount of time employees are spending on special project directly; however, Plant sum query can answer this question. Plant sum query is accurate and sufficient but adds extra information as it calculates the total hours for Denver and Chicago plants also.

  • Mention a query to know how much time employees are spending on Quota Computation project:

    The total amount of time employees are working on Quota computation project can be calculated using Sorted Query 1. These query lists the total hours worked by employees in quota computation project in Chicago project which can be manually added to find the total hours spend on quota computation project by Chicago plant employees. Here the data is sufficient but needs manipulation to produce relevant result and hence accuracy is questionable. The data is sufficient as there is information in the query that is not really needed.

  • Mention a query to find the number of hours worked by employees in the quota computation project in all three plants:

    To find the number of hours worked by employees in the quota computation project in all three plants cannot be answered directly by any query...

Explanation of Solution

b.

Mention the conclusion that can be drawn by this exercise:

It can be said that one can create queries to answer questions quickly and easily but queries need to be formulated ...

Explanation of Solution

c.

Mention the advantages and disadvantages of databases as compared to spreadsheet:

  • It can be inferred that queries in databases are easy to use and can be constructed to produce specific answers...

Blurred answer
Students have asked these similar questions
I need help creating the network diagram and then revising it for the modified activity times.
Activity No. Activity Time (weeks) Immediate Predecessors 1 Requirements collection 3 2 Requirements structuring 4 1 3 Process analysis 3 2 4 Data analysis 3 2 5 Logical design 50 3,4 6 Physical design 5 5 7 Implementation 6 6 c. Using the information from part b, prepare a network diagram. Identify the critical path.
Given the following Extended-BNF grammar of the basic mathematical expressions:  Show the derivation steps for the expression: ( 2 + 3 ) * 6 – 20 / ( 3 + 1 ) Draw the parsing tree of this expression. SEE IMAGE
Knowledge Booster
Background pattern image
Computer Science
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
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
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage