BCA Semester 3 – System Analysis and Design – Unit 4: Design (12Hrs)

Question 1

Explain the guidelines to design in an interface and dialogue box e-commerce system.

Marks: 5

Year: 2020 Final TU FOHSS

Guidelines for Designing Interface and Dialogue Boxes in an E-Commerce System Designing an effective user interface and dialogue boxes is critical for the success of an e-commerce system. The interfac

Question 2

How can you transform ER Diagram into relation? Explain with your own suitable example.

Marks: 10

Year: 2020 Final TU FOHSS

Transforming an ER Diagram into Relations ER Diagram (Entity-Relationship Diagram) represents the logical structure of a database using entities, attributes, and relationships. Transforming an ER Di

Question 3

What are the steps in creating decision table? How do we reduce the size and complexity of a decision table?

Marks: 5

Year: 2021 Final TU FOHSS

Steps in Creating a Decision Table A decision table is a structured way to represent complex decision logic using conditions and actions. The steps to create a decision table are: 1. Identify the Co

Question 4

How can you transform ER Diagram into relation? Explain with your own suitable example.

Marks: 5

Year: 2021 Final TU FOHSS

Transforming an ER Diagram into Relations ER Diagram (Entity-Relationship Diagram) represents the logical structure of a database using entities, attributes, and relationships. Transforming an ER Di

Question 5

Giving a simple example, explain how ER schemas are converted into a set of relations.Your example should have the use of multivalued and composite attributes too.Cardinality is a must.

Marks: 5

Year: 2022 Final TU FOHSS

Conversion of ER Schema into a Set of Relations Example: Student–Course System ER Schema Description We consider the following entities and relationship: 1. Entity: STUDENT - StudentID (Primary K

Question 6

. Define DFD. Write rules to draw a DFD. Draw a DFD upto level 1 for library management system.

Marks: 10

Year: 2023 Final TU FOHSS

Data Flow Diagram (DFD) Definition A Data Flow Diagram (DFD) is a graphical representation of the flow of data within a system. It shows how data moves from external entities to processes, how it i