To construct a small commercial database and demonstrate its Essay

To construct a small commercial database and demonstrate its functionality - Essay Example To get the selected items delivered, the user has to register with the site and set up a payment and delivery plan. The order details are mailed to the user’s registered email. Delivery (ID, IssueDate, IssueTime, Type, DeliveryDate, mobileNumber,RecipientFirstName, RecipientLastName, RecipientAddressLine1, RecipientAddressLine2, RecipientCity, RecipientPostCode, RecipientPhone) The attributes completely represent all required aspects of the delivery. If the customer wishes to have the products delivered at residence, the option can be selected or the customer can get the order shipped to a particular shop. Brand Name is to be considered as an attribute of a separate entity brand. This is to ensure, a particular brand name is always referred to with the same spelling and name description. In case the name of the brand changes, only one change will have to be made. The item selected is usually not timestamped. The item stays in the cart only till the user’s login session. In case, a user logs out without checking out, the selected item is sent back to the available product