0 like 0 dislike
32 views
in Biology by (1m points)
Draw and explain ER diagram for the system or getting admission in your college?

1 Answer

0 like 0 dislike
by (1m points)

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.

Welcome to Free Homework Help, where you can ask questions and receive answers from other members of the community. Anybody can ask a question. Anybody can answer. The best answers are voted up and rise to the top. Join them; it only takes a minute: School, College, University, Academy Free Homework Help

19.4k questions

18.3k answers

780 comments

3.2k users

Free Hit Counters
...