2-4 Lab_Updating Tables
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Business
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by mrsjdsmith15
DAD-220 Southern New Hampshire University
Jessica DelValle-Smith
October 30, 2023
2-4 Lab: Updating Tables
4. After creating the tables, use the correct commands to
describe them
. You’ll only be given commands to describe one of the tables and must complete the same action for the second one on your own. Validate your work with a screenshot.
A.describe Employee;
B.
Write the correct command to describe the Branches table
5.
Insert
the following
records into the Employee table (with support)
. Each line going from left to right is a record. Each line going from top to bottom is a column. Validate your work with a screenshot.
A.
INSERT INTO Employee VALUES (100, 'John', 'Smith', 1, 'Exempt', 'Full-Time', 90000),
(101,'Mary','Jones',2,'Non-Exempt','Part-Time',35000),
(102,'Mary','Williams',3,'Exempt','Full-Time',80000);
B.
INSERTEmply
Type the command select* from Employee; and take a screenshot of it to validate this step.
6.
Insert
the following
records into the Employee table
for Gwen Johnson and Michael Jones by writing the correct SQL commands
on your own
(without support).
A. Gwen Johnson: Employee ID = 103, DEPARTMENT_ID = 4, Classification = NULL, Status = Full-
Time, SALARY = 40000
B. Michael Jones: Employee ID = 104, DEPARTMENT_ID = 4, Classification = Non-Exempt, Status = Full-Time, SALARY = 90000
C. Insert your name into the table to verify and prove your work. (Your First and Last Name, or a nickname): Employee ID = 105, DEPARTMENT_ID = 1, Classification = Non-Exempt, Statues = Full-time, SALARY = (Choose a value between 50000 and 99000)
D.
Type the command select* from Employee; and take a screenshot of it to
validate this step.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Assistance please: showing working,
arrow_forward
typing clear no chatgpt used i will give 5 upvotes
arrow_forward
Please answer Question 1
arrow_forward
17.2
arrow_forward
v Question Completion Status:
Moving to another question will save this response.
Question 2
Match the following terminologies to their corresponding definitions:
A temporary endeavor undertaken to create a unique product, service, or result. A. Value chain
v set of logically related collection of tasks performed to achieve a defined
B. Project
outcome.
C. Procedure
v A series of tasks that an organization performs to convert inputs to outputs.
D. Product.
v Reducing the number of employees to cut costs.
E. Rightsizing.
F. Cost Reduction
G. Process.
H. Supply Chain.
AMoving to another question will save this response.
arrow_forward
Required information
[The following information applies to the questions displayed below.]
The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. They will
be built completely from scratch to the exact specifications used for the originals. As further authentication, the aircraft will
be made using the technology and manufacturing processes available when the originals were built. Each of the 16
airplanes will be flown to Air Force and aviation museums throughout the country for exhibition. Aviation enthusiasts can
also visit the production facility to see exactly how such aircraft were built in 1938.
Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about the Four F
Sixes from the Air Force. The information includes some of the old cost data from the builders of the original aircraft. The
available information is for the total accumulated time as the 1st, 8th, and 32nd…
arrow_forward
a
b
When using the Daily Business Manager, you cannot do which of the following:
a
C
b
d
с
d
Show Transcribed Text
a
b
с
Record notes (messages) to help you remember tasks to be completed.
HST is charged to a customer when:
Advance the session date for recording transactions.
List recurring invoices for the next 7 days.
Change the setting to not display this manager window.
d
Show Transcribed Text
S
The customer will be reselling the goods to another customer.
The customer will be using the goods for their own use.
When the red stick pin is clicked in a Sales Journal window, Sold to: area, it means that:
The customer has prepaid the order and will pick up the goods in 10 days.
a and b are correct.
a Graphs.
This is an invoice for a
arrow_forward
Sir, please solve this problems asap.No need any kind of large explanation.Only providing the ans with (70-100) words will be enough. Thanks. (Solve question 4)
arrow_forward
4.
is a technique that tracks employee movement patterns through various jobs.
OA. Markov analysis
O B. Human resource planning
OC. Trend analysis
OD. Task identity
Mark for review (Will be highlighted on the review page)
ce Previous Question
Next Question >>
arrow_forward
!
arrow_forward
help me question 1 iii), vi), v), iv)
arrow_forward
Miss Ida is a front desk manager at Northern Resort. When dealing with unhappy customers, Miss Ida is performing her role as_________
Question 4 options:
liaison officer
disturbance handler role
spokesperson role
negotiator role
arrow_forward
Please do not give solution in image format thanku
Alpha Airlines has to decide how many meals to load on its daily 6 pm non-stop flight from Philadelphia to Los Angeles. The meals are sold on board to economy class passengers for $10.00 and cost the airline $4.00 each. All meal orders must be made at least 48 hours before the flight departs. Any meals left over at the end of the flight are tossed into the trash by the ground clean-up crew. Alpha estimates that the demand for the meals on this flight is Poisson distributed with a mean of 9.
1.How many meals should Alpha order? (Choose the closest answer.)
a) 6
b) 7
c) 8
d) 9
e) 10
f) 11
g) 12
h) 13
i) 14
arrow_forward
DETERMINERS
LEVEL B1
I. Choose A, B, C or D to indicate the correct answer to each of the following
questions.
1. Very,
_people came up with a solution to this difficult math problem.
C. many
A. little
B. few
D. much
2. I usually listen to the weather forecast, though I have_
faith in it.
A. little
B. few
C. many
D. a large number of
3.
_is capable of greatness as long as he or she is determined.
A. No one
C. Many
connection between the two assignments.
C. none
B. Everyone
D. Few
4. There wasn't
A. any
B. little
D. few
5. Indonesia has had more bird flu deaths than
other country, and
variants of the H5N1 virus still circulate there.
A. any - several B. all - more
6. We had so many people over to lunch yesterday, but there was
everybody.
A. enough of
C. each - plenty
D. some - some of
food for
B. plenty of
C. a lot
D. too much
7.
dollars were transferred to his bank account after the deal was
closed, 10,000 dollars to be exact.
C. Thousands of
of money into setting up security camera
A.…
arrow_forward
6. Head of department is the one who responsible for managing several different departments that are responsible for
different tasks.
(True/ False)
arrow_forward
Your answers are saved automatically.
Remaining Time: 18 minutes, 33 seconds.
* Question Completion Status:
Moving to another question will save this response.
Question 5
A
is some combination of products, services, information, or experiences
provided to consumers to satisfy a need or want.
O a. value proposition
O b. market offering
O c. market mix
O d. market segment
O e. brand positioning
arrow_forward
95.
Second step in problem solving process is to
a.
practicing the solution
b.
organizing the data
c.
design a solution
d.
define a problem
arrow_forward
Don't use chat etc solve it correct complete solutions handwriting
arrow_forward
A service provided delivering packages to a locker for customers to pick up at their convenience is an example of:
Question content area bottom
Part 1
A.
hybrid office.
B.
passive contact.
C.
active contact.
D.
front office.
arrow_forward
You have been tasked to establish and implement an effective hearing conservation program for a manufacturing industry. Noise monitoring shows that the employees working in the production area has been exposed to 8-hour TWA noise exposures between 85.0 dBA and 90.0 dBA. REQUIREMENT/ASSIGNMENT QUESTION Based on the latest DOSH requirements, discuss the requirements for an effective hearing conservation program and steps to make the program as effective as possible. a) Your report should include the following: i.Executive summary ii.The objective and importance of conducting noise monitoring iii.Process description (Flow chart, diagram etc.) iv.Methods and measurements v.Results and discussion vi.Conclusions and recommendations to reduce the noise exposure in the company b) Each aspects must be discussed and supported with evidences (pictures, documents, flow charts, etc) from the selected company. c) Relevant regislations related to each aspect must be properly quoted and discussed. (…
arrow_forward
Please do not give solution in image format thanku
The original Hawthorne studies were set up to study:- employee breaks; testing used in the selection of employees lighting; employee personality conflicts; employee incentives.
During production planning, the operation manager must make decision about all of the the following EXCEPT; the type of production process that will be used; facility layout product design; resource planning; site selection.
----- is a gap between what is and what is desired and ---- is the gap between what is and what is required. ( A need; a want) (Experience;Motivation) (A want; a need) (motivation, experience.)
arrow_forward
94.
Last step in process of problem solving is to
a.
design a solution
b.
define a problem
c.
practicing the solution
d.
organizing the data
arrow_forward
Which represents what quality management is?
a. involves the preparation of a quality management plan that describes the process and metrics that will be used.
b. processes that provide confidence that product and service quality are being managed.
OC. Act of overseeing all activities and tasks needed to maintain a desired level of excellence.
Od.outlines systematic approaches used to improve upon quality assurance and quality control processes
e. ensuring quality of a product/service is maintained and defects are appropriately managed.
QUESTION 20
What is quality improvement?
Oa. Act of overseeing all activities and tasks needed to maintain a desired level of excellence.
O b. Processes that provide confidence that product and service quality are being managed.
Oc Ensuring quality of a product/service is maintained and defects are appropriately managed.
d. Outlines systematic approaches used to improve upon quality assurance and quality control processes.
e. Involves preparation of…
arrow_forward
()8
please answer the questions in a ABCD form
THANK YOU FOR YOUR HELP!!
(Please igonore numbers on screen) Answers are sometimes shown in second image, Please select as many answers , if they're correct of course, once again thank you.
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
- 17.2arrow_forwardv Question Completion Status: Moving to another question will save this response. Question 2 Match the following terminologies to their corresponding definitions: A temporary endeavor undertaken to create a unique product, service, or result. A. Value chain v set of logically related collection of tasks performed to achieve a defined B. Project outcome. C. Procedure v A series of tasks that an organization performs to convert inputs to outputs. D. Product. v Reducing the number of employees to cut costs. E. Rightsizing. F. Cost Reduction G. Process. H. Supply Chain. AMoving to another question will save this response.arrow_forwardRequired information [The following information applies to the questions displayed below.] The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. They will be built completely from scratch to the exact specifications used for the originals. As further authentication, the aircraft will be made using the technology and manufacturing processes available when the originals were built. Each of the 16 airplanes will be flown to Air Force and aviation museums throughout the country for exhibition. Aviation enthusiasts can also visit the production facility to see exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about the Four F Sixes from the Air Force. The information includes some of the old cost data from the builders of the original aircraft. The available information is for the total accumulated time as the 1st, 8th, and 32nd…arrow_forward
- a b When using the Daily Business Manager, you cannot do which of the following: a C b d с d Show Transcribed Text a b с Record notes (messages) to help you remember tasks to be completed. HST is charged to a customer when: Advance the session date for recording transactions. List recurring invoices for the next 7 days. Change the setting to not display this manager window. d Show Transcribed Text S The customer will be reselling the goods to another customer. The customer will be using the goods for their own use. When the red stick pin is clicked in a Sales Journal window, Sold to: area, it means that: The customer has prepaid the order and will pick up the goods in 10 days. a and b are correct. a Graphs. This is an invoice for aarrow_forwardSir, please solve this problems asap.No need any kind of large explanation.Only providing the ans with (70-100) words will be enough. Thanks. (Solve question 4)arrow_forward4. is a technique that tracks employee movement patterns through various jobs. OA. Markov analysis O B. Human resource planning OC. Trend analysis OD. Task identity Mark for review (Will be highlighted on the review page) ce Previous Question Next Question >>arrow_forward!arrow_forwardhelp me question 1 iii), vi), v), iv)arrow_forwardMiss Ida is a front desk manager at Northern Resort. When dealing with unhappy customers, Miss Ida is performing her role as_________ Question 4 options: liaison officer disturbance handler role spokesperson role negotiator rolearrow_forwardarrow_back_iosSEE MORE QUESTIONSarrow_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