Question: Write SQL statements to create a table EMPLOYEE_BACKUP to back up the EMPLOYEE table shown in Figure 5.6. Figure 5.6 One possible database state for

Write SQL statements to create a table EMPLOYEE_BACKUP to back up the EMPLOYEE table shown in Figure 5.6.
Figure 5.6
One possible database state for the COMPANY relational database schema
EMPLOYEE

EMPLOYEE Se Salary Super esn Dno Addiess Fname 123456789 1965-01-09 731 Fondren, Houston, TX M Smith 30000 333445555 Jon

DEPARTMENT Oreme Doumber Mgsan Oramd Rosearch Doumber Mgrsan 333445555 Mg start dato Administration Hoadquarters 1988-05

EMPLOYEE Se Salary Super esn Dno Addiess Fname 123456789 1965-01-09 731 Fondren,

Houston, TX M Smith 30000 333445555 Jon Franklin 333445655 Wong 1955-12-08 638

Voss, Houston, TX 40000 888665656 25000 987654321 Alicia 999887777 1968-01-19 3321 Caatle,

Spring. TX Zelaya Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444

EMPLOYEE Se Salary Super esn Dno Addiess Fname 123456789 1965-01-09 731 Fondren, Houston, TX M Smith 30000 333445555 Jon Franklin 333445655 Wong 1955-12-08 638 Voss, Houston, TX 40000 888665656 25000 987654321 Alicia 999887777 1968-01-19 3321 Caatle, Spring. TX Zelaya Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX English 43000 888665555 Jennifer Ramesh M 38000 333445555 25000 333445555 Joyoe Ahmad 453453453 1972-07-31 5831 Rice, Houston, TX 987987987 1969-03-20 080 Dallas, Houston, TX 88866E555 1937-11-10 450 Stone, Houston, TX Jabbar Jamos M 55000 NULL Borg DEPARTMENT Oreme Doumber Mgsan Oramd Rosearch Doumber Mgrsan 333445555 Mg start dato Administration Hoadquarters 1988-05-22 1905-01-01 987654321 888665555 1981-06-19

Step by Step Solution

★★★★★

3.34 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Below SQL statement is to create table EMPLOYEE BACKUP to backup ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1019-B-C-A-C-B-A-M(3622).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

If you have not already done so, create and populate the Marcias Dry Cleaning (MDC) database for the DBMS you are using as described in: Chapter 10A for Microsoft SQL Server 2012 Chapter 10B for...

How might a firm's board of directors discourage its managers from attempting to manipulate financial statements to create a temporarily high stock price?

Use the information in problem 9 to create a table similar to Table 17.1 and value the lease. Is it the same value found in problem 9? It should be! Year Lease Cash Flows Saved cost of a new backhoe...

Problem 6 (12 points): Identify the single valued Primary Keys in the Employee table if we know the table will never change. Use the table attached at the end of the assignment. Dno Figure 5.6 One...

acording to the company schema pliz i want a solution coming from the (company scheme) please do not give a solution in the app already because I already seen them GEIT 3341: Database I 5\% Bonus...

Specify Primary Key for each table below, also specify foreign keys, if any. For each foreign key, please indicate that foreign key references to which table. 210 Figure 5.6 One possible database...

There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...

GEIT 3341: Database 3. Find the first name, middle initial and last name of all employees who work on exactly 2 projects. (2.5 points) 2. Produce a relation showing the department name and the name...

I need ONLY professional expert in Database course. I need all these questions to be answered correctly . Please use the SCHEMA to answer the following queries Database I Course: express the...

Database I Using the COMPANY schema, express the following operations in SQL. For your SELECT operations, make sure that they always work without modification even if the underlying tables change via...

Briefly explain the term generally accepted accounting principles.

9 The amplitude of vibration of an undamped system is measured to be 1 mm. The phase shift from != 0 is measured to be 2 rad and the frequency is found to be 5 rad/s. Calculate the initial conditions...

9. Challenge: Show how to set the screen background color in video mode 13h to green.

4 Choose two organisations with which you are familiar, one from the commercial sector (perhaps from work or from your place of study) and one voluntary body (perhaps from a hobby, sport or society...

In 1980, over San Francisco Bay, a large yo-yo was released from a crane. The 116 kg yo-yo consisted of two uniform disks of radius 32 cm connected by an axle of radius 3.2 cm. What was the magnitude...

In unit-vector notation, what is the torque about the torque about the origin on a particle located at coordinate (0, -4.0m 3.0m) if that torque is due to (a) Force F1 with components F 1x = 2.0 N,...

A plum is located at coordinates (-2.0 m, 0, 4.0 m). In unit-vector notation, what is the torque about the origin on the plum if that torque is due to a force F whose only component is? (a) F x = 6.0...

25) Company Democrat bonds have the following terms: they mature in 10 years; they pay semiannual interest of $35; their par value is $1,000. If the (annual) market rate of interest on similar bonds...

Korbel Company is considering purchasing Hamilton (a privately heid company) and discovers the following about Hamllon a. No allowance for doubtul accounts has been established A $10,000 allowance is...

can you find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15, 2022. Bonds have a par value of $2000 in semiannual coupons....