BUS RESERVATION SYSTEM

Draw an E-R schema (diagram) that satisfies all the requirements you have specified in detail in step

specify the (information) Requirements" of your application domain in simple English. (at least 8-10 paragraphs). your paragraphs should be written in simple English. It should not include technical terms such as "entity", "cardinality", "sub-entity", weak-entity",..... A person without a formal database education should be able to read and understand your statements.

2 Draw an E-R schema (diagram) that satisfies all the requirements you have specified in detail in step #(1).

Your E-R diagram (schema) should include at least two out of three of the following constructs: (1) ISA relationships, (2) weak entity types, and (3) relationship types defined on a single entity type recursive relationship types. If it does not, modify your original "Requirements Specifications" so that it does. O It would be a great practice if you can draw your E-R diagram in a step-wise manner as we did in the class, and as it was shown in the slides.