MASTER OF COMPUTER APPLICATIONS
Course Code: MCS-014
Course Title: Systems Analysis and Design
Assignment Number: MCA (I)/014/Assignment/15-16
Maximum Marks: 100
Weightage: 25%
Draw ERD for Online Admission System for a University. Make necessary assumptions.
ER Diagram
Notations for the components of ERD:
Entities: An entity is something about which the business needs to store data. An entity is a class of persons, places, objects, events or concepts about which we need to capture and store data. An entity instance is a single occurrence of an
entity.
Attribute: An attribute is a descriptive property or characteristic of an entity. Synonyms include element, property and field.A compound attribute is one that actually consists of other attributes. It is also known as a composite attribute. An attribute “Address” is the example of compound attribute as shown in the following illustration
Relationships: A relationship is a natural business association that exists between one or more entities. The relationship may represent an event that links the entities.
Cardinality: defines the minimum and maximum number of occurrences of one entity that may be related to a single occurrence of the other entity. Because all relationships are bidirectional, cardinality must be defined in both directions for every relationship.