Detailed Design Document (Delete Product)

Deleting a product is described in the above diagram. The user passes the product and motif number combination to the system. The system checks to see if the corresponding product is currently on order by any customers in the Order datastore before flagging the product as inactive (deleted).

The returned status corresponds to the success of the operation. If the product is successfully flagged as deleted in the Product datastore, the status returns Successful. If the product is currently on order by any customer, the user is notified of this condition.

P-Spec

Process ID	1.B.4
Process Name	Delete Product
Inputs	motif number, product number
Outputs	None
Permissible User	Administrator, Salesperson
Assumptions	All information entered is syntactically correct.
Error Conditions	The product specified by the product number and motif number does not exist.

Data Elements (Data Dictionary)

Name	motif number
Kind	Primary Key
Type	Alphanumeric
Description	A primary key attribute of entity Product. The maximum length is 3 alphanumeric characters. The format is: 3 digits motif number (mmm). This motif number is classified in the following format (color, design and font). For example: csi The attribute describes the characteristics of one product. The characteristics includes the different combinations of the components (color, design and font). It is combined with product number to generate the primary key for the entity Product.

Name	product
Kind	Data movement in DFD
Type	Instance of an Entity
Description	This data element corresponds to a complete instance of the Entity Product.

Name	product number
Kind	Primary key
Type	Integer
Description	A Primary key attribute of entity Product. The maximum length is 4 digits. The format is the type integer. For example: 3634 The primary key specifies the unique product number of a product. It is combined with motif number to generate the primary key for the entity Product.

Name	order
Kind	Data movement in DFD
Type	Instance of an Entity
Description	This data element corresponds to a complete instance of the Entity Order.

Name	status
Kind	Data movement in DFD
Type	Return Message
Description	This data element corresponds to an error message being returned from an operation. An error message may be both successful and unsuccessful. Unsuccessful error messages are further subcategorized into different errors based on the possible errors that can occur in an operation.