MCS-014 : SYSTEMS ANALYSIS AND DESIGN-SOLVED QUESTION PAPER - JUNE - 2016
1. (a) Prepare SRS for a library management system. Make necessary assumptions. 8 MARKS
ANSWER: GET ANSWER HERE http://mca.nowgray.com/2017/01/srs-for-library-management-system.html
(b) Draw ERD for a library management system. Explain various components and relationships in detail. 8 MARKS
ANSWER: GET ANSWER HERE
(c) Differentiate between DFD and Flow chart.
ANSWER: GET ANSWER HERE
https://eternalsunshineoftheismind.wordpress.com/2013/02/04/differences-between-data-flow-diagrams-flowcharts/
Discuss the importance of levels of DFD.8 MARKS
ANSWER: DFD can be categorized in the following forms:
Context diagram: An overview of an organizational system that shows the system
boundaries, external entities that interact with the system and the major information
flows between the entities and the system. In this diagram, a single process represents
the whole system.
First level DFD: A data flow diagram that represents a system’s major processes, data
flows, and data stores at a high level of detail.
Functional decomposition diagram: Functional decomposition is an iterative
process of breaking the description of a system down into finer and finer detail which
create a set of charts in which one process on a given chart is explained in greater
detail on another chart. In this diagram, sub-processes of first level DFD are explained
in detail. Or you can GET ANSWER HERE for more information....
Context diagram: An overview of an organizational system that shows the system
boundaries, external entities that interact with the system and the major information
flows between the entities and the system. In this diagram, a single process represents
the whole system.
First level DFD: A data flow diagram that represents a system’s major processes, data
flows, and data stores at a high level of detail.
Functional decomposition diagram: Functional decomposition is an iterative
process of breaking the description of a system down into finer and finer detail which
create a set of charts in which one process on a given chart is explained in greater
detail on another chart. In this diagram, sub-processes of first level DFD are explained
in detail. Or you can GET ANSWER HERE for more information....
(d) Explain the following diagrams withexamples : 2x4=8(i) Structured chart
ANSWER: Structure Charts
Structure Charts are used to illustrate software (program) structure to fulfil
business requirements. Structure charts describe the interaction between independent
module and the data passing between the modules. These module specifications can
be passed to programmers prior to the writing of program code. In structure chart the
whole application is divided into modules (set of program instructions) and modules
are designed according to some principles of design.
A structure chart is a tree of sub-routines in a program (Refer to figure 4.7). It
indicates the interconnections among the sub-routines. The sub-routines
should be labelled with the same name used in the pseudo code.
GET ANSWER HERE For more information
Structure Charts are used to illustrate software (program) structure to fulfil
business requirements. Structure charts describe the interaction between independent
module and the data passing between the modules. These module specifications can
be passed to programmers prior to the writing of program code. In structure chart the
whole application is divided into modules (set of program instructions) and modules
are designed according to some principles of design.
A structure chart is a tree of sub-routines in a program (Refer to figure 4.7). It
indicates the interconnections among the sub-routines. The sub-routines
should be labelled with the same name used in the pseudo code.
[ HINT - just write the definition from above url and any 2 diagrams with as examples. Don't write everything completely from it as it is just for 4 marks.]
(ii) State-machine diagram
ANSWER: For definition of State Machine Diagram Get Answer Here
https://www.visual-paradigm.com/VPGallery/diagrams/State.html
(e) What are the guidelines for databasedesign ? Explain the term 'Relational
Database Schema'. Give an example of this schema.
ANSWER: Guidelines for Database Design
The following are various guidelines for Database Design:
- ensure that data stored in the files (database tables) are atomic. Data stored in the atomic form can be combined later to generate data in specific form;
- every table must have a primary key which identifies each record in the table distinctly. Descriptive and meaningful name is to be used while naming a field in the table ( For example, use product_id instead of ID);
- use single column primaray key whenever possible. As most of the join operations are made on primary key and composite primary keys make the operation slower;
- use numeric key whenever possible;
- use primary key name as foreign key for better readability;
- avoid allowing null values to go into the columns that have discrete range of possible values; and
- avoid multiple tables with similar structure wen one table is sufficient.
[ANSWERS WILL BE CONTINUED AND WILL BE UPLOADED SHORTLY]
