with your stock table (videos rental store rents out) you'd have a stockID and a title field. Other fields you may have may include Category (e.g. drama, action, sci-fi etc), main actors, distributor, year of release etc
then with the transaction table you would have a customerID field and a...