Hi, need to submit a 250 words essay on the topic Database Design.The store in turn keeps the videos and creates video order in case customers request for any video. The videos are purchased, hired, r

Hi, need to submit a 250 words essay on the topic Database Design.

The store in turn keeps the videos and creates video order in case customers request for any video. The videos are purchased, hired, returned or sent from the supplier to the store when the store orders for them. The video supplier receives payment for his videos and sends the video to the store.

Customer-video. There exists one to one, one to many or many to one relationship that pertains to customers. One and only one customer can hire, purchase or return a certain video. one and only one customer can also return, hire or purchase zero or more than one video.

Store-video. there exists one to one or one to many relationship between the stores and the videos. This is because one and only one store can stock one or more videos and also one and only one store can create one or more video