Database Redesign - Database Processing: Fundamentals, Design, and Implementation - page 392

EMPLOYEE STORE

Figure 8-6
The Morgan Importing MIPIS
Modified SALES_ORDER
Configuration

EmployeeID StoreID

StoreName
City
Country
Phone
Fax
EmailAddress
Contact

LastName
FirstName
Department
Phone
Fax
EmailAddress

INVOICE

InvoiceNumber

InvoiceDate
StoreID(FK)
PurchasingAgentID(FK)
SubtotalUSD
TaxUSD
TotalUSD

ITEM

ItemID

ItemDescription
Category

INVOICE_LINE_ITEM
InvoiceNumber(FK)
LineNumber

ItemID(FK)
Quantity
UnitPriceUSD
ExtendedPriceUSD

D. Using your dependency graph, describe the tasks necessary to change the name of the
SHIPMENT_ITEM table to SHIPMENT_LINE_ITEM and the needed changes to col-
umn names.

E. Write all SQL statements to make the name change described in part D.

F. Using your dependency graph, describe the tasks necessary to convert the sales order
part of the MIPIS to the new configuration.

G. Code SQL statements to implement your redesign recommendations in your answer
to part F.