Question

The school canteen wants to maintain records of items available in the school canteen and generate bills when students purchase any item from the canteen. The school wants to create a canteen database to keep track of items in the canteen and the items purchased by students. Design a database by answering the following question:

The school wants to find out how many calories students intake when they order an item. In which relation should the attribute ‘calories’ be stored?

Answer 1

In Items table