To construct a small commercial database and demonstrate its Essay

To construct a small commercial database and demonstrate its functionality - establish ExampleTo get the selected point in times delivered, the user has to register with the site and set up a payment and delivery plan. The order details are mailed to the users 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 domiciliate 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 learn 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 users login session. In case, a user logs out without checking out, the selected item is sent back to the available product