You work as a Database Developer for a Web based music company named Music2Music. You are designing a database for online order management application. The customers use the company's Web site to place orders for the music CDs. Orders details are first inserted into an online database named OrdersData. The Orders database includes a table named Orders and a table named OrderDetails. The Orders table contains basic information about the orders. The OrderDetails table contains information about the individual items in the orders. Fragments of the Orders database is given below:

Requirements of the database design are given below:

Customers must be able to use the company's Web site to view orders

stored in the OrdersData database.

Customers should be able to see only their own orders.

Customers should not be able to modify the orders.

The primary key values of the orders are not relevant to the customers and should not be visible. What will you do?

Question

You work as a Database Developer for a Web based music company named Music2Music. You are designing a database for online order management application. The customers use the company's Web site to place orders for the music CDs. Orders details are first inserted into an online database named OrdersData. The Orders database includes a table named Orders and a table named OrderDetails. The Orders table contains basic information about the orders. The OrderDetails table contains information about the individual items in the orders. Fragments of the Orders database is given below:

Requirements of the database design are given below:

Customers must be able to use the company's Web site to view orders

stored in the OrdersData database.

Customers should be able to see only their own orders.
Customers should not be able to modify the orders.

The primary key values of the orders are not relevant to the customers and should not be visible. What will you do?

Accepted Answer

B. Create a stored procedure that retrieves the order information for a customer.

Answer

A. Create a view that displays the order information for a customer.

Answer

C. Grant SELECT permissions on the Orders and OrderDetails tables to the customers

Answer

D. Create a scalar user-defined function that retrieves the order information for a customer.

You work as a Database Developer for a Web based music company named Music2Music. You are designing a database for online order management application. The customers use the company's Web site to…

Question

Exhibit

Options

How the community answered

Community Discussion