Solution-Write insert statements to insert data into the

Write insert statements to insert data into the tables

Assignment Help Database Management System

Reference no: EM13922294

A new manager was recently hired along with 5 employees who will work under her.

The President of our company has created a new department for her to head as well.

You can assume that all the new employees were hired today. Make sure your changes get saved to the database.

Information:

New Employees:

First Name	Last Name	Credit Limit	Phone Number
Jane	Smith	15.00	7890
Martha	Woods	20.25
Bill	Bourne
Mike	Oleni	33.33	3333
C	Etter	43

New Manager:

Rose Hamby is the manager of all the employees above. Her information is below:

First Name	Last Name	Credit Limit	Phone Number	Manager Name
Rose	Hamby	14.00	3433	Susan Brown

The new department that was created for Rose is as follows:

Department Code	Department Name
IT	Information Technology

Write insert statements to insert the data into the tables above. Show all the insert statements you used, along with the order they were run in. Use the seq_employee_id SEQUENCE to get the employee_id. Do not hard-code the manager_id value in your insert statements.

After all the data is entered, run selects to show that the data is actually in the database. Show those screenshots below.

Reference no: EM13922294

Questions Cloud

Uncollectible accounts is adjusted accordingly : Swarthmore Clothing Corporation grants its customers 30 days' credit. The company uses the allowance method for its uncollectible accounts receivable. During the year, a monthly bad debt accrual is made by multiplying 3% times the amount of credit sa..

Examine crime statistics for reports : Explain why the causality between these variables goes in the direction you claim that it goes. (In other words, make clear why the variables cannot logically be reversed.)

What is the optimal number of spares to order : What is the optimal number of spares to order? Carrying no spare parts would be the best strategy for what range of shortage cost?

Space designer and tool wire med space designer instructions : Research health care facilities in your area that are either new or are being renovated. Your research will help you select your project focus. You will use this facility in future assignments throughout the course. Your selections are limited to

Write insert statements to insert data into the tables : Write insert statements to insert the data into the tables above. Show all the insert statements you used, along with the order they were run in. Use the seq_employee_id SEQUENCE to get the employee_id. Do not hard-code the manager_id value in..

Record accrued interest payable : On September 1, 2012, Tavani Co. issued a note payable to National Bank in the amount of $1,200,000, bearing interest at 12%, and payable in three equal annual principal payments of $400,000. On this date, the bank's prime rate was 11%. The first ..

Halifax sold merchandise on account : During 2016, Halifax sold merchandise on account for $13,400,000. This merchandise cost Halifax $8,710,000 (65% of selling prices). Also during the year, customers returned $661,000 in sales for credit. Sales returns, estimated to be 5% of sales, are..

A 20 year old pregnant black hispanic female presented : A 20 year old pregnant Black Hispanic female presented to the Emergency department in critical condition following a single vehicle car accident. She showed signs and manifestations of interior draining and was encouraged to have a blood transfusion ..

What is expected of the cpa firm in order to merit : A CPA firm does not guarantee the financial soundness of a client when it renders an opinion on financial statements, nor does the CPA firm guarantee the absolute accuracy of the statements. What is expected of the CPA firm in order to merit such c..

User Account

All Pages

Write insert statements to insert data into the tables

Reference no: EM13922294

Reference no: EM13922294

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT