10 suppose table E aor employees) looks like this: E Eno, ame, salary, Medical,

Question

10 suppose table E aor employees) looks like this: E Eno, ame, salary, Medical, Address) Then suppose we want you to write a program to produce mailing labels Thus, you need name and address of each employee. We don't want you to see Salary and we don't want you to see "Medical To accomplish this I can do one of the following: a) Create a new table that just has the three columns of Eno, Name and Address and put all the rows from E into the new table b) create a VIEW that just has the three columns of Eno, Name and Address

Explanation / Answer

1 (a)

CREATE TABLE new_E AS (Select Eno,Name,Address from E);

(b)

CREATE VIEW V_E As Select Eno,Name,Address from E;

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.