Your assignment is to prepare and submit a paper on components of database. All the movies fall under DVDs, VBS or VCD. Customers pay fines for spoilt and late return of rented videos.The entities in

Your assignment is to prepare and submit a paper on components of database. All the movies fall under DVDs, VBS or VCD. Customers pay fines for spoilt and late return of rented videos.

The entities in this scenario are

Store

Video

Video_suppliers

Video_order

Customer

The customers orders for videos. They can also decide to purchase or return the video. 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.

The relationships in this scenario are:

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 relationships 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 orders.

Video_supplier-video. One and only video supplier can supply a certain video.

Customer-payment. One and only one customer can make payment to one or many videos.

Video_order-video_supplier.