ASSIGNMENT
DRIVE SPRING 2019
PROGRAM Master of Business Administration- MBA
SEMESTER Semester 3
SUBJECT CODE &
NAME
ISM 301- Software Engineering
SET-I
Q.1
Define software engineering and briefly discuss about its evolution.
Differentiate between “software” and “hardware.”
Definition
software engineering and discussion on its evolution. 7
Different
between software and hardware. 3
Answer-
Software Engineering :
IEEE
defines software engineering as:
●
The application of a
systematic,disciplined,quantifiable approach to the development,operation and
maintenance of software; that is, the application of engineering to software.
●
The study of approaches
as in the above statement. The term “software engineering” was coined way back
in 1968 during the proceedings of the “North Atlantic Treaty Organization
(NATO) Software Engineering Conference” held at Garmisch, Germany, and was intended
to trigger discussions regarding the perceived “software crisis” at that point
in time. The so-called crisis evolved around certain complexities in the
software developmental process like projects running late, projects running
beyond estimated cost, dubious quality of the software being created, mismatch
between customer requirements and the
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
Q.2 What is an SRS? Explain the need
and importance for having such a document.
Definition
of SRS. 2
Need and importance of SRS. 8
Answer-
Definition of SRS :
A software requirements
specification (SRS) is a comprehensive description of the intended purpose and
environment for software under development. The SRS fully describes what the
software will do and how it will be expected to perform. An SRS minimizes the
time and effort required by developers to achieve desired goals and also
minimizes the development cost. A good SRS defines how an application will
interact with system hardware, other programs and human users in a wide variety
of real-world situations. Parameters such as operating speed, response time,
Q.3
Discuss Software project scheduling using Gantt charts.
Explanation
of software project scheduling using Gantt charts. 10
Answer-
Software project scheduling using Gantt charts :
A
software project has to be scheduled accurately, as any kind of schedule
slippage can affect the cost and effort involved in the software project.
Therefore, while scheduling a project, we must adhere to the following points:
●
Establish a bridge between chronological time
and the human effort.
●
Use milestones to show progress.
●
Distribute effort throughout the software
engineering process.
●
Check for availability of scheduling methods.
●
Represent the schedule and
SET-II
Q.1
What is a software design? Explain architectural design in detail.
Definition
of software design. 2
Explaining
the architectural design. 8
Answer-
Software design :
The
process of depiction of how a particular software is to be developed is called
software design. The design also includes requirements, practices, methods,
life cycles and guidelines to develop a system. Software design is a structured
methodology. There are various methodologies that specify complete set of
standards, tools, procedures and documentation. The aim of any methodology
should be to establish:
●
A style and procedure
for the way a system is developed or an existing/available system is improved.
●
Management control
should present milestones and checkpoints for the development.
●
Quality of the product as per the specifications.
Software
design is applied
Q.2
Describe system testing. Explain debugging and its approaches.
Explanation
of system testing 4
Explanation
of debugging and its approaches. 6
Answer-
System testing :
System Testing is the testing of a
complete and fully integrated software product. Usually, software is only one
element of a larger computer-based system. Ultimately, software is interfaced
with other software/hardware systems. System Testing is actually a series of
different tests whose sole purpose is to exercise the full computer-based
system. The system testing is conducted based on unit and integration testing.
It is a very important step in quality management process. For system
Q.3
Define SQA. Briefly explain the SQA plan.
Definition
of SQA 4
Explanation
of SQA plan. 6
Answer-
SQA Defination :
Software quality assurance (SQA) is a
process that ensures that developed software meets and complies with defined or
standardized quality specifications. SQA is an ongoing process within the
software development life cycle (SDLC) that routinely checks the developed
software to ensure it meets desired quality measures. oftware quality assurance
(SQA) is a process which assures that all software engineering processes,
methods, activities and work items are monitored and comply against the defined
standards. These defined standards could be one or a combination of any like
ISO 9000, CMMI model, ISO15504, etc. SQA incorporates all software development
processes
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
ASSIGNMENT
DRIVE SPRING 2019
PROGRAM Master of Business
Administration- MBA
SEMESTER Semester 3
SUBJECT CODE &
NAME
ISM302 – Database Management System
(DBMS)
SET-I
Q.1
Outline the properties of Database Management System? Summaries components of
DBMS with its uses?
Properties
of DBMS 4
components
of DBMS 6
Answer-
Properties of Database Management
System :
The
following are the important properties of database:
●
A database is a logical
collection of data having some implicit meaning. If the data are not related
then it is not called as proper database. For example, a student studying in
class II got 5th rank.
Stud_name
|
Class
|
Rank
obtained
|
Vijetha
|
Class II
|
5th
|
●
A database consists of
both data and the description of the database structure and constraints. For
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
Q.2
Explain in details three-schema architecture of DBMS.
Mentioning
the three schemas correctly 1
Explanation
for each schema 3x3
Answer-
Schema Architecture :
According
to the three-schema or three-tier architecture, the schema is a representation
of the real-world objects. The four levels are level 0, level 1, level 2 and
level 3. Level 0 represents the real world, level 1 represents the entity
relationship model, level 2 represents the relational model and level 3
represents the physical data structures. Before going through in detail on the
working of three-schema architecture, you should have knowledge on data models,
schema and instances.
●
Data Models: You can define data model as a set of concepts for viewing a set
of data in a structured wa
Q.3
List various functions of Distributed databases. Explain three different
types of data fragmentation.
List
various functions of Distributed databases.
5
Explain
three different types of data fragmentation.
5
Answer-
Functions of distributed databases :
Basic
functions performed by DDBMS in addition to those of centralized DBMS are as
follows:
●
Distributed query processing – Distributed query processing means the ability
to access remote sites and transmit queries and data among the various sites
via the communication network.
●
Data tracing – DDBMS should have the ability to keep track of
the data distribution, fragmentation and replication by maintaining
SET-II
Q.1
Explain the steps involved in database access operations. Describe the ACID
properties with examples
Explain
the steps involved in database access operations. 5
Describe
the ACID properties with examples 5
Answer-
Steps involved in database
access operations :
The
basic database access operations are as follows:
1. Read-item
(x) -It reads a database item named “x” into a program variable.
2. Write-item
(x) - It writes the value of the program variable x into the database.
Read-item
(x) includes the following steps:
1. Find
the address of the disk block that contains item “x.”
2. Copy that disk block into a buffer in main
memory.
3. Copy item x from the buffer to the program
variable x.
Executing
the write-item (x) includes the following steps:
1. Find
the address of the disk block that contains item (x).
2. Copy
that disk block
Q.2
List and explain the relational model constraints.
List
the constraints 1
Explanation 3x3
Answer-
Relational Model Constraints :
The
relational database is composed of many relations and tuples. Each tuple is
related to one another in a number of ways. The database depends on the state
of its relations at a particular instant of time. The state of the relation
depends on the restrictions which are put on the actual values in the database. There are three main types of constraints:
1. Inherent-model-based
2. Schema-based
3. Application-based
Inherent-model-based : This
type is also
Q.3
Differentiate between tuple relational calculus and domain relational
calculus. 5
Explain
the different types of SQL statements.
5
Answer-
Tuple Relational Calculus versus Domain Relational Calculus
:
Tuple relational calculus :
The
tuple calculus is based on specifying a number of tuple variables. A tuple
variable is a variable that ranges over some named relation that is a variable
whose permitted values are only tuples of that relation. This means that in a
relation R, if the tuple variable t ranges
over R, then at any given time “T” represents some individual tuple of R.
Domain relational calculus :
There
is another type of relational calculus
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
ASSIGNMENT
DRIVE
SPRING 2019
PROGRAM
Master of Business Administration-
MBA
SEMESTER
3
SUBJECT CODE & NAME
ISM303 – Computer Networks
SET-I
Q1.
What is a computer network? Describe the factors that encourage the computer
networking in an organisation.
Definition
of computer network 2
Explanation
of the factors that encourage the computer networking in an organization 8
Answer:
Definition of computer network :
A computer network is a group of
computer systems and other computing hardware devices that are linked together
through communication channels to facilitate communication and resource-sharing
among a wide range of users. Networks are commonly categorized based on their
characteristics.
Networks
are used to:
●
Facilitate communication via email, video conferencing, instant
messaging, etc.
●
Enable multiple users to share a single hardware device like a
printer or scanner
●
Enable file sharing across the network
●
Allow for the sharing of software or operating programs on remote
systems
● Make information easier
to
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
Q.2
Using suitable diagram discuss the working of CSMA/CD protocol in detail?
Working
of CSMA/CD diagram 2
Explanation
of working of CSMA/CD 8
Answer:
Working of Carrier Sense Multiple
Access with Collision Detection(CSMA/CD) Protocol :
The
CSMA/CD protocol can be compared with a typical life scenario such as a group
discussion during an interview. Suppose several candidates are sitting around
the table. Every candidate must listen to the instruction for a while before
speaking (Carrier Sense). After listening to the instruction, during a pause
every candidate has an equal chance to participate in group discussion
(Multiple Access). In the case when two candidates speak simultaneously, they
detect the situation and quit
Q.3
Explain synchronous and asynchronous data link protocols.
Explanation
of synchronous data link protocols 5
Explanation
of asynchronous data link protocols 5
Answer:
Synchronous data link protocols :
Synchronous protocol is a communication protocol that controls a
synchronous transmission. In this protocol, signals are synchronised and
coordinated. The transmission would be similar between any two systems across
the network. The transmission to the next system would be started only after
the completion of the current transmission. Following are some of the features
of synchronous protocol :
●
Synchronous
SET-II
Q.1
Describe the five classes of IP addresses.
Explanation
of five classes of IP addresses 5x2
Answer:
Five classes of IP addresses :
IP
address specifies a unique ID to access the network. It defines IP addresses
into five types of classes as depicted in
Q.2
Discuss benefits and drawbacks of SONET/SDH standards.
Benefits
of SONET/SDH 6
Drawbacks
of SONET/SDH 4
Answer:
Benefits of SONET/SDH
:
● Synchronous Digital Transmission : Until the introduction
of SONET in the mid-1980s, plesiochronous digital hierarchy (PDH) systems
commonly used data multiplexing technology. The primary problem with PDH was
that to extract low-speed traffic, all traffic that was multiplexed to higher
speeds had to be de-multiplexed into lower speeds. With PDH, the
Q.3
Explain different types of cloud in cloud computing.
Explanation
of different types of cloud 10
Answer:
Types of cloud :
Generally,
cloud computing can be classified either on the basis of location or the type
of service being provided. On the basis of location, cloud can be classified as
follows:
●
Public cloud
●
Private cloud
●
Community cloud
●
Hybrid cloud
Public Clouds :
The clouds, accessed or
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
ASSIGNMENT
DRIVE SPRING 2019
PROGRAM MASTER OF BUSINESS
ADMINISTRATION (MBA)
SEMESTER III
SUBJECT CODE & NAME ISM304 – BUSINESS
INTELLIGENCE AND TOOLS
SET – I
Q.1 What are the major issues pertaining to
implementing Business Intelligence (BI) in organizations?
Issues pertaining to implementation of BI
practices and policies 10
Answer:
The
major issues pertaining to such practices and policies are as follows:
Definitions: BI
cannot be implemented successfully in the absence of a clear definition about
perspective goals. Initially, only 10 to 20 KPIs should be chosen to create
standards and gradually be increased to reflect the overall performances. The
lack of agreement within the departments in any organisation is the biggest
challenge. To illustrate this, let us consider the finance and sales
departments, which define “gross margin” with different perspectives. This shows
that the two departments will obtain diverse figures, which will negate the
effect of automation. This problem Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
Q.2 What is Data Warehousing? Explain the
components and goals of Data Warehouse.
a)
Definition of Data Warehousing 2
b)
Components of Data Warehouse 4
c)
Goals of Data Warehouse 4
Answer:
Data Warehousing :
Data warehouse is a repository that is used to collect, store,
manage, and distribute data across the entire organisation. Its objective is to
help an organisation in decision making through efficient data management and
use of various techniques, processes, and individuals. According to William
(Bill) H. Inmon, known as the Father of Data Warehouse, “A data warehouse is a
subject-oriented, integrated, time-variant and non-volatile collection of data
in support of management’s decision-making process”. A data warehouse has the
following features:
●
It is standardised.
3
List and explain the tools used in Business Intelligence as per their
capabilities.
a)
Tools supporting organizational memory capability. 2.5
b)
Tools supporting information integration capability 2.5
c)
Tools supporting insight creation capability 2.5
d)
Tools supporting presentation capability 2.5
Tools supporting organisational
memory capability :
Organisational
memory capability represents an organisation’s set of intellectual resources.
These resources include data, information and explicit knowledge. This
capability emphasises on storage in such a manner so that they can be accessed
easily. Querying software tools are the best examples of tools supporting
organisational memory capability. They are a leading variety of business
intelligence tools. The strength of querying software is its ability to
instantly extract, summarise, sort and display results that are particularly
important for the management. This software uses
Set – II
Q.1 List and explain the Steps in Development of
Business Intelligence Solutions.
Steps
in Development of BI solutions 10
Steps in Development of Business
Intelligence Solutions :
While
starting to plan for a new BI project, an organisation needs to design the
right BI solution for the kind of analysis it plans to carry out. An
organisation also needs to evaluate the existing IT infrastructure to ensure
that it can support this kind of a solution. Development of a BI solution is
easier when an organisation has a particular business problem to resolve. An
organisation must start designing a BI solution after considering the manner
and requirement of interaction between people and information. With a
user-centric approach, an organisation can start working on designing a
solution that properly accesses and structures the data to support business
Q.2 Explain the main features of a financial
reporting system
Main
features of financial reporting system
10
Answer:
Main features of financial reporting system :
The
following are the main features of a financial reporting system:
●
Drag-and-drop report builder: This feature helps in creating sophisticated
reports and analysing them with ease. To generate a report, you need to select
the desired items from a menu, drag them onto a graphical workspace and choose
appropriate formatting options.
●
Choice of dimensions in rows and columns: This feature enables you to easily design your
report. You
●
Q.3
List and explain the Ten Keys to ensure success of BI in organizations.
Explanation
of the Ten keys 10
Answer:
Ten Keys to Business Intelligence
Success :
There
is no doubt that companies need to understand the importance of BI to run an
organisation in an efficient and effective manner. Uncertainty in economic
conditions and other major dynamic changes in the market make it difficult for
organisations to compete. Every organisation works very hard to stay ahead of
the competition and sometimes, even to be able to just stay in the competition.
A company or an
Its half solved only
New
smu SPRING 2019 solved assignments available with us
LAST
DATE IS 08-07-2019
charges Rs 99 per assignment (new price)
or
contact any time 8791490301,
08273413412 (both whatsapp no)
No comments:
Post a Comment