B. The Queen Anne Curiosity Shop database design used in Chapter 3 was: ITEM (It

Question

B. The Queen Anne Curiosity Shop database design used in Chapter 3 was: ITEM (ItemNumber, Description, Cost, ListPrice, QuantityOnHand) CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, Email) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, Email) VENDOR VendorlD, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, Email) ITEM (ItemID, ItemDescription, PurchaseDate, Itemcost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeelD, SaleDate, SubTotal, Tax, Total) SALE ITEM (SaleID, SaleltemID, ItemID, ItemPrice) The referential integrity constraints are: VendorID in ITEM must exist in VendorID in VENDOR Customer ID in SALE must exist in CustomerID in CUSTOMER EmployeelD in SALE must exist in EmployeelD in EMPLOYEE SaleID in SALE ITEM must exist in SalelD in SALE ItemID in SALE ITEM must exist in ItemID in ITEM The Queen Anne Curiosity Shop has modified the ITEM and SALE ITEM tables as follows: ITEM (ItemID, ltemDescription, UnitCost, UnitPrice, QuantityonHand, vendorID) SALELITEM (SaleID, SaleltemID, ItemID, Quantity, ItemPrice, ExtendedPrice) These changes allow the sales system to handle nonunique items that can be bought and sold in quantity. When new items from vendors arrive at the Queen Anne Curiosity Shop, the office personnel unpack the items, put them in the stockroom, and run an Item Quantity Received Transaction that adds the quantity received to QuantityOnHand. At the same time, another transaction called an item Price Adjustment Transaction is run, if necessary, to adjust UnitCost and UnitPrice. Sales may occur at anytime, and when a sale occurs, the Sale Transaction is run. Every time a SALE ITEM line is entered, the input Quantity is subtracted from QuantityonHand in ITEM and the ItemPrice is set to the UnitPrice.

Explanation / Answer

Read

Update

Read

Insert

Update

Delete

Read

Delete

Grant Rights

Revoke Rights

In this the sales people is nothing to do with item insert and delete. It is enough for them just to read the item to sale and the to update the database if the item was sold.

Management can do anything with the sale_item as they are people who decide the items to sell.

Administrative people can read and delete the items as they have nothing to do with update and insert of sale_ item as that will be decided by management

System administrator can be grant and revoke permissions to all the remaining people.

Read

Update

Read

Update

Delete

Insert

Read

Grant Rights

Revoke rights

As the same sales people just sell the item's so it is enough for them to read and update the item

Management can do anything with the items so they are having all the permissions.

Administrative people can have option to just read as they are nothing to do with the items. They are just responsible to provide the service.

System administrator is just responsible for giving permissions and revoke permissions.

SALE_ITEM

Read

Update

Read

Insert

Update

Delete

Read

Delete

Grant Rights

Revoke Rights

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

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