Question

8. 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

look this answer @ doubtnut then hope for answer