CS507 Assignment 3 Solution Spring 2019

Hello VU students here is the solution of CS507-Information System Assignment No.3 Spring 2019.Assignment Solution in Doc file. You Also Like our Facebook Page, Join Facebook Group, follow on Google+ and Subscribe our YouTube Channel. Please Share it with your Friends. Thank you.

Solution for the Assignment is presented for your convenience. Download it and make it according to your requirement and do not copy paste.

Assignment Solution:

 (Part A)

(1)

Flow chart is the best design tool to describe the steps in transaction. Because flowchart is the most commonly use design and analysis technique. The diagrammatic presentation gives a quick understanding of the business processes and flows

(2)

The terminator symbol is used to start and end transaction which is      it is start with issuing prequalification documents and end with intimate or award contract.

(3)

Diagram flow chart:

(Part B)

(1)

The Entity relationship diagram (ERD) is used to describe the component relationship and their properties. It provides a graphically notation for representing such data model in the form of entity relationship diagram.

An entity set is a set of entities of the same type that share the same properties. All entities in an entity set have the same set of attributes, i.e. common characteristics e.g. names, addresses, date of birth, etc.

There are main three types of entities which are,

1.   Weak Entity

2.   Strong Entity

3.   Composite Entity

In the given scenario it is the composite entity type.

Basically there are four types of attributes which are,

1.   Single/composite

2.   Single/multi-valued

3.   Null

4.   Derived

In given scenario two types of attributes used a composite attribute and a multi-valued attribute.

Explanation: 1- in given data it contain name, address, account, etc. and these refers to composite type. 2- In given data contain more than one value and this is refers to multi-valued attribute.

(2)

Entity & their Relationship:

The entity-relationship diagram (ERD) is a data model or diagram for high-level descriptions of
conceptual data model, and it provides a graphical notation for representing such data models in the form of entity-relationship diagrams.

Relationship Chart

In above diagram each entity shares a relationship with for logical purpose.