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

Write the application for university admissions office

Write the application for university admissions office. Prompt user for a student's High School Grade Point and an admission test score.

How much supervisory wages and factory supplies

How much supervisory wages and factory supplies cost would NOT be assigned to products using the activity-based costing system - How much supervisory wages and factory supplie

Develop a table mainmenu with at least three fields

Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run. Your code (for the button) will dynamically read the caption from the table and as

Convert the first normal form to second normal form

Convert each of the previously identified entities to third normal form. Make certain that the necessary foreign keys have been added to the final tables to support the rela

Provide an entity relationship diagram

Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards. Provide a logical and physica

Create database management system for bike shop

Your job is to create a database management system for bike shop who ‘buys' and ‘sells' new and second-hand bikes, and also parts of bike. Bike is constructed with parts whil

Effective partnership relationship between management

Using research evidence, critically evaluate the key factors for an effective partnership relationship between management and a trade union - Critically analyse Nasser's stra

Requirements for the construction of a database system

Performance Tuning (COMP 0343A) Analyse requirements for the construction of a database system based on an understanding of performance issues and Gather and analyse data for

Reviews

Write a Review

 
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