Homework 1. Due 9.30 AM Tuesday August 14.
Must be done *individually*, no copying whatsoever.
Submissions must be handwritten. Use pencils for the diagrams
to allow for easy correction.
A
Design an ER diagram for representing information about petrol pump
allocation. Details should include:
- information about pumps such as address, location, etc.
- information about allottees such as name, address, etc.
- information about allocations (decide what you want to represent)
- information about allocation committees (name of committee,
chairman, members, and their addresses), and which pumps
each one allocated.
- information about bribes paid (to who, by who, for what, amount, etc).
Make sure to include appropriate constraints.
B
Convert the ER diagram to a set of tables.
Just list the table schemas e.g. "allottee(name, address, otherfields)"
No need to give type information. Whereever conversion is non-trivial,
indicate reasoning (e.g. "The table for R is merged with the table for E").