Byerly DAD 220 Module Two Activity (1)
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Business
Date
Feb 20, 2024
Type
docx
Pages
1
Uploaded by CaptainPencil6470
Professor Venckus
Sarah Byerly
04 September 2023
DAD 220 Module Two Activity Template
Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers and any supporting screenshots.
1.
How many records are shown in the Employee table?
5
2.
How many attributes are there in the Branches table?
8
3.
Which attribute could be a primary key for the Employee table?
Employee_ID
4.
How many decimal places (maximum) can be stored in an employee’s salary field?
2
5.
How many decimal places (maximum) can a Department_ID have?
0
6.
What three rules do tables obey?
No duplicate rows
Columns must have a unique name that clearly descries the culumn.
Each cell can only contain one value.
7.
Is the Employee table normalized? How do you know?
This table is normalized because only a single value is in each cell.
8.
What is the result of the following query?
Select sum(Salary) from Employee where Department_ID=3;
170,000
9.
Identify the Employee ID(s) that would be returned as a result of the following query.
Select * from Employee where Classification <> 'Exempt';
100 and 102
10.
What is the result of the following query?
Select max(Salary) from Employee;
90,000
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Required information
Problem 9-2
[The following information applies to the questions displayed below.]
An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table.
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
301
O/C
315
W/R
329
N/C
302
N/C
316
F/R
330
O/R
303
F/R
317
F/R
331
N/R
304
O/R
318
N/R
332
W/C
305
F/R
319
F/R
333
W/C
306
N/R
320
N/R
334
N/R
307
N/C
321
O/C
335
F/C
308
O/R
322
W/C
336
W/C
309
N/R
323
F/R
337
F/C
310
N/C
324
O/C
338
N/R
311
O/C
325
W/C
339
N/R
312
O/R
326
N/C
340
N/C
313
N/R
327
O/R
341
N/R
314
O/R
328
N/R
Key:
Problem type:
Customer type:
N
= Noisy
C
= Commercial customer
F
= Equipment failure
R
= Residential customer
W
= Runs warm
O
= Odor
Problem 9-2 Part a
a.
Using the data, prepare a check sheet for the problem…
arrow_forward
Assistance with the following please showing all working.
arrow_forward
Chapter 5: Homework Mini Cases
Required:
1. Describe the risks associated with the system depicted in the flowchart below.
2. Describe the physical controls needed to mitigate each risks.
Purchases Department
Receiving Department
Čentral Čomputer Facility
Account Payable Department
Warehouse
Packing
Slip
Vendor
PO
Invoice
Rec Reprt
Identify Items
and Select
Prepare
Receiving
Accaunting
System
Vendor
report
Reconcile
Reconcile and
Packing
Slip
Updlate
Inventory
documents and
Rec Reprt
set up Liability
nve ntory
PO
Records
Rec Reprt
Rec Reprt
PO
Invoice
ALLOUnt
PO
Payable
Rec Reprt
Vendor
arrow_forward
1) Create a business scenario/description.
2) Based on the business description created, construct an Order Processing flow chart that
is appropriate for the business.
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
The following are the car repair shop data:
Ticket No.
1
Work
Brakes
Ticket No.
11
Work
Lube & oil
Ticket No.
21
Work
Transmission
2
Brakes
12
Battery
22
Lube & oil
3
Tires
13
Tires
23
Tires
4
Brakes
14
Lube & oil
24
Lube & oil
5
Lube & oil
15
Brakes
25
Brakes
6
Lube & oil
16
Tires
26
Brakes
7
Battery
17
Lube & oil
27
Brakes
8
Lube & oil
18
Lube & oil
28
Lube & oil
9
Brakes
19
Brakes
29
Tires
10
Lube & oil
20
Tires
30
Battery
Click here for the Excel Data File
a. Prepare a check sheet for the above car repair shop data:
Work Type
Frequency
Brakes
Tires
Lube & oil
Battery
Transmission
Total
0
arrow_forward
do fast
arrow_forward
Quesition no.2.5 related to manufacturing system. Automation and production system forth edition book chapter no.2 exercise quesition 2.5
arrow_forward
Please create fishbone diagram for the given case, sample in is also in the photo attached.
arrow_forward
Answer number 2 only. Full solution. Unique answers only.
arrow_forward
00:53:53
C
k
TB Problem Qu. 5-114 (Algo) Mccabe Corporation uses the weighted-average...
for September.
Mccabe Corporation uses the weighted-average method in its process costing. The following data pertain to its Assembly Department
Mc
Graw
Hill
control
Work in process, September 1
Units started into production during September
Units completed during September and transferred to the next department
Work in process, September 30
Equivalent units of production
Q
A
2
Required:
the weighted-average method.
Compute the equivalent units of production for both materials and conversion costs for the Assembly Department for September using
Z
option
W
S
# 3
X
F3
Materials
E
H
command
D
$
4
DOD
DOO
F4
Conversion
R
C
do 5
%
F
U
*
8
N
DII
F8
Units
800
8,200
7,300
1,700
(
9
F9
K
M
0
Materials
55%
F10
Percent Complete
75%
L
H
P
F11
>
Help
command
Conversion
10%
25%
+ 11
Save & Exit
2
F12
option
2
Sub
dele
arrow_forward
1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift.
Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will
not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately?
NUYLOTNQhObm1bEVKUTO90
a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry.
O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this.
CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby.
40 Cara's gift is very thoughtful and will help to build a relationship with her clients.
NUTYks10TNRUQ2h0bmkbEVKUTO90
arrow_forward
Weighted-Average Method Arsenio Company manufactures a single product that goes throughtwo processes, mixing and cooking. The following data pertain to the mixing department for August:[LO 6-2, 6-5][LO 6-2, 6-3, 6-4]Work-in-Process Inventory, August 1Conversion: 80% complete 34,000 unitsWork-in-Process Inventory, August 31Conversion: 50% complete 30,000 unitsUnits started 66,000Units completed and transferred out ?CostsWork-in-Process Inventory, August 1Material X $ 64,800Material Y 88,100Conversion 119,880Costs added during AugustMaterial X 152,700Material Y 135,900Conversion 305,120Material X is added at the beginning of work in the mixing department. Material Y is also added in themixing department, but not until units are 60% complete with regard to conversion. Conversion costs areincurred uniformly during the process. The company uses the weighted-average cost method.Required1. Calculate the equivalent units of material X, material Y, and conversion for the mixing department.2.…
arrow_forward
Timber Solutions Ltd. is expanding and needs to hire more personnel in the accounting office. Leena Barker, the chief accounting officer, knew that her cousin Rose was looking for a job. Leena offered Rose a job as her assistant. Leena will be responsible for Rose’s performance reviews and training.
Question
List some problems with the proposed personnel situations in the accounting department ?
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
QUESTION 2
Propose TWO examples of system in Management Information System (MIS) that you believe are the most important to the company, covering the features or functions available in the systems. Support your discussion with the related diagram or screenshot of functions or features provided in the system. Then provide summaries of these two systems in a table form. Please refer to the rubric criteria for the report requirements.
arrow_forward
No written by hand solution
limitations to new cafe in a shopping centre
arrow_forward
Please, explain in simple terms of how you find the answer , so I may understand and process information given. Thank you soo much. By the way I have uploaded this question before but it wasn't clear .
arrow_forward
convert the table to
Precedence Diagram
مخطط الأسبقية
arrow_forward
○ E.
Founded in 1970, ABC is one of the world's largest insurance companies with locations in 28 countries. Given the following description, flowchart the new
policy setup process as it existed in 1970:
Individual customers who wanted to set up a new policy would visit one of ABC's 70 branch offices or make contact with an agent. They would then fill out an
application and sometimes attach a check. The branch office then sent the application package through company mail to the XYZ division in London.
In addition, a customer might also fill out the application at home and send it directly to any number of ABC locations, which would then transfer it to the
London operation. Once received, XYZ separated the various parts of the application, then scanned and digitized it. The electronic image was then retrieved
from a server and delivered to an associate's desktop client computer. The associate was responsible for entering the information on the form into the
appropriate database. If the…
arrow_forward
Question 1Data Warehouses and Data MartsWrite a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts to acquire data. You must use the CSU Online Library to locate at least two sources for your paper.Question 2Name the four stages of the business process management cycle and summarize the activities in each.Your response should be at least 200 words in length.Question 3Business Process ManagementIn this writing assignment, you will explore how organizations use business process management (BPM). Write a onepage(250-word) paper explaining how organizations use business process management (BPM). Be sure to use at leastone specific example from the CSU Online Library, and address the following in your paper:What is business process management (BPM)?Why do processes need management?What are BPM activities?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- Required information Problem 9-2 [The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. JobNumber Problem/Customer Type JobNumber Problem/Customer Type JobNumber Problem/Customer Type 301 O/C 315 W/R 329 N/C 302 N/C 316 F/R 330 O/R 303 F/R 317 F/R 331 N/R 304 O/R 318 N/R 332 W/C 305 F/R 319 F/R 333 W/C 306 N/R 320 N/R 334 N/R 307 N/C 321 O/C 335 F/C 308 O/R 322 W/C 336 W/C 309 N/R 323 F/R 337 F/C 310 N/C 324 O/C 338 N/R 311 O/C 325 W/C 339 N/R 312 O/R 326 N/C 340 N/C 313 N/R 327 O/R 341 N/R 314 O/R 328 N/R Key: Problem type: Customer type: N = Noisy C = Commercial customer F = Equipment failure R = Residential customer W = Runs warm O = Odor Problem 9-2 Part a a. Using the data, prepare a check sheet for the problem…arrow_forwardAssistance with the following please showing all working.arrow_forwardChapter 5: Homework Mini Cases Required: 1. Describe the risks associated with the system depicted in the flowchart below. 2. Describe the physical controls needed to mitigate each risks. Purchases Department Receiving Department Čentral Čomputer Facility Account Payable Department Warehouse Packing Slip Vendor PO Invoice Rec Reprt Identify Items and Select Prepare Receiving Accaunting System Vendor report Reconcile Reconcile and Packing Slip Updlate Inventory documents and Rec Reprt set up Liability nve ntory PO Records Rec Reprt Rec Reprt PO Invoice ALLOUnt PO Payable Rec Reprt Vendorarrow_forward
- 1) Create a business scenario/description. 2) Based on the business description created, construct an Order Processing flow chart that is appropriate for the business.arrow_forward! Required information [The following information applies to the questions displayed below.] The following are the car repair shop data: Ticket No. 1 Work Brakes Ticket No. 11 Work Lube & oil Ticket No. 21 Work Transmission 2 Brakes 12 Battery 22 Lube & oil 3 Tires 13 Tires 23 Tires 4 Brakes 14 Lube & oil 24 Lube & oil 5 Lube & oil 15 Brakes 25 Brakes 6 Lube & oil 16 Tires 26 Brakes 7 Battery 17 Lube & oil 27 Brakes 8 Lube & oil 18 Lube & oil 28 Lube & oil 9 Brakes 19 Brakes 29 Tires 10 Lube & oil 20 Tires 30 Battery Click here for the Excel Data File a. Prepare a check sheet for the above car repair shop data: Work Type Frequency Brakes Tires Lube & oil Battery Transmission Total 0arrow_forwarddo fastarrow_forward
- Quesition no.2.5 related to manufacturing system. Automation and production system forth edition book chapter no.2 exercise quesition 2.5arrow_forwardPlease create fishbone diagram for the given case, sample in is also in the photo attached.arrow_forwardAnswer number 2 only. Full solution. Unique answers only.arrow_forward
- 00:53:53 C k TB Problem Qu. 5-114 (Algo) Mccabe Corporation uses the weighted-average... for September. Mccabe Corporation uses the weighted-average method in its process costing. The following data pertain to its Assembly Department Mc Graw Hill control Work in process, September 1 Units started into production during September Units completed during September and transferred to the next department Work in process, September 30 Equivalent units of production Q A 2 Required: the weighted-average method. Compute the equivalent units of production for both materials and conversion costs for the Assembly Department for September using Z option W S # 3 X F3 Materials E H command D $ 4 DOD DOO F4 Conversion R C do 5 % F U * 8 N DII F8 Units 800 8,200 7,300 1,700 ( 9 F9 K M 0 Materials 55% F10 Percent Complete 75% L H P F11 > Help command Conversion 10% 25% + 11 Save & Exit 2 F12 option 2 Sub delearrow_forward1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift. Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately? NUYLOTNQhObm1bEVKUTO90 a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry. O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this. CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby. 40 Cara's gift is very thoughtful and will help to build a relationship with her clients. NUTYks10TNRUQ2h0bmkbEVKUTO90arrow_forwardWeighted-Average Method Arsenio Company manufactures a single product that goes throughtwo processes, mixing and cooking. The following data pertain to the mixing department for August:[LO 6-2, 6-5][LO 6-2, 6-3, 6-4]Work-in-Process Inventory, August 1Conversion: 80% complete 34,000 unitsWork-in-Process Inventory, August 31Conversion: 50% complete 30,000 unitsUnits started 66,000Units completed and transferred out ?CostsWork-in-Process Inventory, August 1Material X $ 64,800Material Y 88,100Conversion 119,880Costs added during AugustMaterial X 152,700Material Y 135,900Conversion 305,120Material X is added at the beginning of work in the mixing department. Material Y is also added in themixing department, but not until units are 60% complete with regard to conversion. Conversion costs areincurred uniformly during the process. The company uses the weighted-average cost method.Required1. Calculate the equivalent units of material X, material Y, and conversion for the mixing department.2.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education