SMU MBA SEM 3 IT SPRING 2015 ASSIGNMENTS

GET FULLY SOLVED AND PROFESSIONALLY WRITTEN  SMU ASSIGNMENTS AT NOMINAL COST

 

COST WILL BE RS.125 PER SUBJECT OR RS.600 PER SEMESTER

 

KINDLY EMAIL US AT:

assignmentsolutionshelp@gmail.com or call us at 07506193173

SMU MBA SEM 3 IT SPRING 2015 ASSIGNMENTS

MI0033 – SOFTWARE ENGINEERING

1 Explain in detail the requirement of use case diagram for a bank database when customer withdraws cash using cheque from the bank.

Explaining use-case based software requirements

Explaining using bank as an example

2 Write short notes on

a. Planning and estimation phase

b. Scheduling and tracking phase

c. Risk analysis phase

d. Scope of a software project

3 Software reuse is a new approach of building software, using the software that already exists in a company, rather than building software systems from scratch.

a. What are the different classifications of software reuse?

b. List the various advantages of software reuse

A a. Explaining opportunistic reuse, planned systematic reuse, horizontal and vertical reuse

b. Listing at least 10 advantages of software reuse

4 Describe the five principles of analysis.

Listing and explaining the five analysis principles

5 Elaborate the terminologies used in software testing fundamentals

A Explaining the three terminologies viz.,

a. testing objectives

b. test information flow

c. test case design

6 Show the mapping the ISO 9001 to the CMM

Explaining mapping of at least any 10 clauses

 

MI0034 – DATABASE MANAGEMENT SYSTEM

1 Write short notes on

a. Latency and seek

b. RAID

c. Blu-ray Disk drive

d. Variable length records

2 Explain various forms of Normalization with an example of employee database

Constructing an un-normalized normal form

Converting the un-normalized normal form to different normal forms with an explanation

3 Elaborate the different types of schema-based constraints

Listing and explaining 5 different types of constraints

4 Write SQL commands for the following queries

a. List all the employees from a employee database whose salary falls in the range from Rs. 25,000 to Rs. 35,000

b. If there are two tables STUDENT and SUBJECT, display the list of students who have opted for computer subject.

c. Display the name of the highest scorer in the class.

d. For every project located in “London”, list the project number, the controlling department number and the department manager’s last name, address and birth date

a. SQL command using Between and OR operator

b. SQL command using single-row nested queries

c. SQL command using multiple-row nested queries

d. SQL command using mix of algebraic operators

5 a. List the advantages of Distributed Database Management System (DDBMS)

b. List the disadvantages of DDBMS

c. What is data fragmentation and data replication?

a. Listing advantages of DDBM

b. Listing disadvantages of DDBMS

c. Explaining data fragmentation

Explaining data replication

6 Write short notes on

a. Inheritance

b. Relationships

c. Object classes

d. Object Relational Database Management System

 

MI0035 – COMPUTER NETWORKS

1 Explain the working of Carrier Sense Multiple Access with Collision Detection (CSMA/CD) Protocol.

Working of CSMA/CD in a Flowchart

Explaining the working in detail

2 Write short notes on

a. Coaxial Cables

b. Satellite

c. Microwave

d. Value-added Network

e. Web EDI

3 Write short notes on

a. Subnet

b. Super netting

c. Subnet masks

d. Dynamic NAT

e. Domain Name System

4 a. What is an email? List the advantages of an Email

b. Write the steps to set up a pop-up blocker

a. Definition

Listing at least 5 advantages of an email

b. Writing complete 9 steps to set up a pop-up blocker

5 Briefly explain the networking applications in government sector

Listing the objectives

About networking applications – understanding the networking for government sector and listing the websites and portals and explaining for them

6 Explore the different models in cloud environment and their examples

Introducing Infrastructure as a Service

Introducing Platform as a Service

Introducing Software as a Service

Explaining Cloud Elements

 

MI0036 – BUSINESS INTELLIGENCE & TOOLS

1 a. Discuss the contribution of business analytics in strategy management

b. How is CRM linked to business intelligence?

a. Various contributions of business analytics in strategy management

b. How the CRM linked to business intelligence

2 Explain the data mining process in detail

Figure to datamining process

Explanation of the process

3 Relate between BI tools and relationship marketing strategy with

Relationship between BI tools and relationship marketing strategy

Some example

4 What are the main features of a financial reporting system

Atleast 10 features

5 Discuss the various critical challenges that need to be overcome for BI to succeed within an organisation

Listing the critical challenges

6 a. List the factors responsible for the increasing importance of BI in organisations.

b. What are the obstacles in Implementing BI in Organisations

a. Listing the factors responsible for increasing importance of BI in organization

b. explaining the obstacles faced while implementing BI in organization