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..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write long term problems when constraints are implemented

Why are these so significant yet so frequently ignored by developers? Write the long term problems when these constraints are not implemented? "

  Assignment 62suppose your database system has failed

assignment 6.2suppose your database system has failed. describe the database recovery process and the use of

  What is sql and for what purpose is it used in databases

What is SQL and for what purpose is it used in databases

  Create a local database that will synchronize data

In the prior phase, you started work on some of the application's graphical user interface (GUI). In this assignment, you will add a data entry form to the GUI and create a local database that will synchronize data to the isolated storage containe..

  Implement a relational database management system

Select a commercial or open source relational database management system of your choice and outline the locking mechanisms inherent in the system to maintain transaction-level consistency.

  Decide which attributes are foreign keys and justify this

Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify this. Draw an ER diagram for these relations, using your answer to problem 1

  When you create a query in access than you are essentially

When you create a query in access, you are essentially

  Develop a data dictionary and create an e-r diagram

Identify the entities and relationships that are relevant for a system to manage SEAMM. Develop a data dictionary (catalogue) and create an E-R diagram.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Develop view for sum of number ordered multiplied by price

Develop a view named OrdTot. It comprises the order number and order total for each order presently on file. (Order total is sum of the number ordered multiplied by quoted price.

  Optimize the query in the select script using alter table

optimize the query in the select script using Alter Table to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.

  Create database using professional principles and standards

Your database project must meet the following assessment requirements - Create a database using professional principles and standards.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd