Data Processing |
These are the three tables Chris is going to add to his database:
Member: This table contains information about the members. This might include name,
address, telephone number etc.
Stock: This table contains information about the video or DVD; whether it is a video or
DVD, the title etc.
Transaction: This table contains information about the transaction; the date due back,
rental cost etc.
Other information, such as the name of Chris’s store and the date of the entry, can be
added automatically.