STORE (StoreID, StoreName, City, Country, Phone, Fax, Email, Contact)

PURCHASE_ITEM (PurchaseItemID, StoreID, PurchaseDate, ItemDescription, Category, PriceUSD)

SHIPMENT (ShipmentID, ShipperID, ShipperInvoiceNumber, Origin, Destination, DepartureDate, Arrival Date)

SHIPMENT_ITEM (ShipmentID, ShipmentItemID, PurchaseItemID, InsuredValue)

SHIPPER (ShipperID, ShipperName, Phone, Fax, Email, Contact)

Assume that the organizations personnel are the owner (Marcia), an office administrator, and one full-time salesperson, and two part-time salespeople. Marcia and the office administrator needs to process data in all tables. Additionally, the full-time salesperson can enter purchase and shipment data. The part-time employees can only read shipment data.

Q:Explain the nature of database administration activities at Morgan. As an aggressive consultant, keep in mind that you can recommend yourself for performing some of the DBA functions.

related to uper table explian the answer