Consider the General Hardware relational database shown in Figure 7.19. a. Write an SQL command to create
Question:
Consider the General Hardware relational database shown in Figure 7.19.
a. Write an SQL command to create the CUSTOMER table.
b. Write an SQL command to create a view of the CUSTOMER table that includes only the Customer Number and HQ City attributes.
c. Write an SQL command to discard the OFFICE table.
d. Assume that Customer Number 8429 is the responsibility of Salesperson Number
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Fundamentals Of Database Management Systems
ISBN: 9780470624708
2nd Edition
Authors: Mark L. Gillenson
Question Posted: