Question: Use the Northwind ERD, located below, write the following queries. 1 . Add yourself as an employee with at least 5 fields. 2 . Create

Use the Northwind ERD, located below, write the following queries.
1.Add yourself as an employee with at least 5 fields.
2. Create a new field in the Employee Table called PrimaryPhone.
3. Move all data in the HomePhone field to the PrimaryPhone field.
4. Remove the HomePhone Field.
5. Create a View that includes essential Product and Supplier information.
6. Remove all existing orders so that the orders appear to get ready for the next year. No order history should remain.
7. In order to Drop the Territories Table, what must I do?
Use the Northwind ERD, located below, write the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

I need help creating these queries in MS Access please! we are given the outputs but i need to know how to get to these outputs i was given these three tables and asked to write the following...

Q:

Consider the following description of the WORKER table Null Field W_ID NO NO YES NO NO W_FNAME W_ADDRESS W_HOURS W_RATE Use Structured Query Language (SQL) to compose the following queries: 1. Create...

Q:

web project Palestinian Best Food Store (PBFS), is an online food store that sales authenticated Palestinian Food, such as Zater, Olive Oil, Sage, ets. Also sales pre-packaged Palestinian meals such...

Q:

Assignment 2 Due February 7 Overview In this assignment, you will store more information for the game board. Instead of just a money value, each grid cell on the board will have a tile with a genus,...

Q:

4) You will create and use a new second database, sem_projectB. Your script must be able to be run repeatedly as a single file. Add the following tables, Add data with a single INSERT for each table:...

Q:

Account Owner ? John Client (use your own name on the form) Checking account #111222333 held at US Bank, 100 Main Street, Big City, OH 45000. Balance - $8,225 on 6/30/16; $5,129 on 12/31/16...

Q:

This International Taxation coursework requires preparing a Form 114 (FBAR) for calendar year 2014. Please see the details of this coursework in attached files. Financial Crimes Enforcement Network...

Q:

This International Taxation coursework requires preparing a Form 114 (FBAR) for calendar year 2014. Please see the details of this coursework in attached files. Financial Crimes Enforcement Network...

Q:

This International Taxation coursework requires preparing a Form 114 (FBAR) for calendar year 2014. Please see the details of this coursework in attached files. Financial Crimes Enforcement Network...

Q:

Answer this question using subqueries if needed. Thanks! 1. Find the minimum, maximum, and average salary in each department. Query: DROP DATABASE IF EXISTS HW1; CREATE DATABASE HW1; Use HW1; CREATE...

Q:

A long solenoid is formed by winding 20 turns/cm. What current is necessary to produce a magnetic field of 20 mT inside the solenoid? a) 8.0 A b) 4.0 A c) 2.0 A d) 1.0 A

Q:

For each real number θ let tθ: R2 R2 be represented with respect to the standard bases by this matrix. Show that tθ1+θ2 = tθ1...

Q:

Activity 6 0 Ethics Affecting Financial Statement Amounts Purpose: Understand the effect ethical decisions have on amounts reported for accounts receivable. A manager of a small electronics store...

Q:

The primary responsibility for product safety lies with the consumer. government. producer. Consumer Product Safety Commission