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
questions:
a) To store each item name along with its price, what relation should be used? Decide
appropriate attribute names along with their data type. Each item and its price should
be stored only once. What restriction should be used while defining the relation?
b) In order to generate bill, we should know the quantity of an item purchased. Should
this information be in a new relation or a part of the previous relation? If a new
relation is required, decide appropriate name and data type for attributes. Also,
identify appropriate primary key and foreign key so that the following two restrictions
are satisfied: i) The same bill cannot be generated for different orders. ii) Bill can be
generated only for available items in the canteen.
c) 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

Answer:

good night sweet dreams

Answer 2

aap isko tasalli se pdho phir answer karne ki Koshish karna