SMU MBA ASSIGNMENTS

Sikkim manipal Solved MBA Assignments, SMU MBA, Solved assignments, 1st sem, 2nd sem, 3rd sem, 4th sem, SMU MBA PROJECTS

Email Us

SEMESTER 3 – MIS

SEM 3 MANAGEMENT INFORMATION SYSTEM (MIS) 2013
MI0033- SOFTWARE ENGINEERING

1
Highlight the reasons for measuring a software product. Also discuss the classification of process metrics measurement.
A
Highlighting the 5 reasons for measuring a software product
5
10
Listing the two categories of measuring a process metrics and listing the sub categories of them
5
2
The Elite info systems has gone through three phases of application change management. They are informal, production promotion and software configuration management. In earlier informal phase the software engineer who developed the code has to place it into production. Due to poor documentation, there was difficulty in understanding and differentiating between the new code and existing code
Then elite info systems adopted change management process. The first ERP was implemented in the company. The company also segregated the duties of the software professional in the company based on the area of specialization and domain knowledge. According to this phase the developer who develops the code could not be held responsible for placing into production. Rather if the developer who wants to change the code has to submit the request through web based application where the changes are tracked and updated simultaneously. Automated workflow was established so that requests could be routed to the right channel for approval. The SCM was introduced into their development life cycle and this brought about a change in the software production life cycle. The SCM process gave segregation of duties which diminished the damage that could be caused by incompetence. Therefore in software configuration management phase, segregation of duties ensured security and reduced the risk. The various responsibilities of configuration migration, enhancement of quality control and analysis and coordination with the change management group.
The tools used in the systems is application- change tracking and development tool. They used this software to govern and archive the various software versions. It stores all the code in the archiving version manager, which enhance quality and simplifies troubleshooting.
The process adopted helps to improve the quality by managing change and predicting its effect. Consistent governing rules were enforced throughout the deployment process. It provide clear accountability which automated audits trails identified the required approvals at each phase. Early intervention results in more repeatable, faster deployments with fewer errors.
Due to the deployment of this process, the three main goals of change management were achieved which are; development of quality, reduction by risk by helping ensure that processes are repeatable and predictable, and reduction of development costs. The following are the benefits of the process Increased developer productivity Improved IT service to internal clients Enhanced scalability Employee acceptance
Therefore Elite Info Systems concludes that SCM is to be made as an integral part of their production process. The company regarded SCM not as a luxury, but as necessity.
a. Which process did Elite Info Systems deployed to improve the quality of change? Why?
b. What is predictive reliability? How SCM will help in prediction?
A
a. Answering which process
1
10
reason for the process: why and benefits,
4
b. Defining predictive reliability
2
Explaining how the SCM helps in prediction
3
3
With the program module diagram explain bottom-up integration. Give example
A
Diagram
2
10
Explaining bottom-up integration
6
Example
2
4
Mr. Shyam Kumar is the Assistant project manager in a software company. The company has bagged a contract for developing software for the credit card division of a private bank. Mr. Shyam Kumar and his team have decided to take up the requirement analysis phase of software engineering. What are the tasks or operations that Mr. Shyam Kumar and his team have to take up in order to complete the software requirement analysis phase?
A
Explaining the 4 analysis tasks of software requirement analysis
4
10
Figure of domains of software requirement analysis
1
Explaining each domains
5
5
Consider your friend has opened a small IT hub or internet café in your city. List the steps that you implement the key practices that explain the infrastructure and performances of his hub.
A
Listing the key process areas
8
10
Diagram
2
6
Write Short notes on
a. Prototyping
b. Quality Control (QC)
A
a. Explaining system prototyping
2
10
Listing it benefits (atleast 4)
2
Mentioning the two approaches of prototyping
1
b. Explaining implementation of QC
2
Explaining what is quality assurance
2
Listing the three different types of cost
1

MI0034- DATABASE MANAGEMENT SYSTEMS

1
How is DBMS classified based on several criteria? Explain each one of them with few examples where ever required
A
Listing the criterion
3
10
Explaining the types based on each criterion
6
Example
1
2
Differentiate between B+ tree and B- tree. Explain them with diagrams
A
2 Diagrams
4
10
Explanation based on comparison
6
3
EMPLOYEE
EMP_ID NAME PROJECT SALARY DEPT_NUM
MUL1 Ramya PR1 40000 1
MUL2 Nupur PR1 45000 2
SMU1 Rajesh PR3 20000 2
SMU2 Vinay PR2 50000 3
SMU3 Anil PR2 80000 2
DEPARTMENT
DEPT_ID DNAME PLACE
1 MIS Bangalore
2 HRM Bangalore
3 Finance Chennai
4 Research Bangalore
Using these tables answer the following question
a. If we want to see all the employees with salary between 40000 and 50000, which query can be used?
b. Select employee name from EMPLOYEE table, whose name starts with R
c. Explain aggregate functions and grouping in detail
A
a. Query based in BETWEEN operator
SELECT * from employee WHERE salary between 40000 to 50000
2
10
b. Query based in LIKE condition
SELECT * from employee WHERE Name LIKE ‘r%’;
3
c. Explaining aggregate functions on select statement, with an example, showing the output of the query, explaining having clause, with example
5
4
What are the problems and failures that may encounter with respect to the transactions in a database management system? Give examples.
A
Explaining the three problems with code
6
10
Listing the types of failures (atleast 4)
4
5
Consider any database of your choice (may be simple banking database/forecasting database/project management database). Show the deduction of the tables in your database to the different types of normal forms
A
Choosing a proper database
2
10
Explaining the 5 normal forms with respect to the database chosen
8
6
Read the following case study thoroughly and answer the following questions:
Laxmi bank is one of the largest private sector banks of India. It has an extensive network of more than 200 branches. It offers banking services to retail as well as corporate clients. The bank faced a challenge in integrating multi-pronged database management system into a centralized system. The IT department of the bank also realized that the computing capabilities of its PCs and servers were not proportionately distributed among all its branches. Each branch had its database management system stored in a traditional way on the disk. The total cost of operating and maintaining the current IT infrastructure was very high and the fundamental shortcomings added to the costs. Moreover, there were also recurrent problems due to the malfunctioning of the currently operational database management system. Therefore, the bank’s top management decided to fix the problem and operationalise a robust database management system. The bank hired an external database technology consulting firm called AKPY Info systems Limited.
AKPY divided the entire IT infrastructure of the bank around two verticals. The retail banking vertical and the corporate banking vertical. All the individual database servers from the individual branches were removed. The entire database system was made virtual such that the managers and the staff can access only the required information (related to retail banking or corporate banking) from the respective centralised data centers. There were only two such centralised data centers (one for retail banking and another for corporate banking) that were managed centrally. Staff and managers could access the information through their PCs and laptops. Centralised database management system complemented the security system by bringing in authentication through a unified ID management server. Managers and officers of the bank were able to process half a million transactions per month in real time after the new implementation. There were significant savings in the cost and also in the consumption of power. Now there were no problems with regard to imbalances in the load across various network servers. Due to centralised data management, top management could keep an eye on the functioning of various branches. Hence the cases of fraud and cheating reduced considerably. The bank managers could also process the loan applications in reduced time since the customer’s previous records could be accessed at the click of the button and approval from the higher authorities could be obtained in real time. Moreover the new system also brought in many applications that helped local managers in the decision making process.
a. List the uses of centralized data management
b. What steps Laxmi bank need to take if it were to change its centralised database system to a distributed database system in future?
A
a. Listing the uses from the from the case study
2
10
b. Explaining about data fragmentation, replication and allocation techniques
6
c. Is it possible to replicate the centralised database management model of the bank in a manufacturing concern? Give reasons.
2

MI0035- COMPUTER NETWORKS

1
A multiplexer takes several data communication lines or signals and converts them into one data communication line or signal at the sending location. Explain the basic methods of multiplexing.
A
Listing the three methods
1
10
Explaining each method
6
Diagram for each
3
2
Write short notes on
a. Network quality of service
b. Gateways
c. Mobile Telephone system
d. Geostationary satellites
e. Ethernet
A
a. Explaining Network quality of service
2
10
b. Describing gateways
2
c. Describing telephone systems
2
d. Explaining the advantages of geostationary satellites
2
e. Describe Ethernet
2
3
Describe the architectural framework of Integrated Services Digital Network (ISDN).
A
Explaining about segregated and integrated architecture with diagram
3
10
Different queuing configurations with diagram
3
Explaining about multiple devices and D channel
4
4
LAN is a privately owned networks which spans over a size of up to a few kilometers in a building or a campus.
a. How can LAN be differentiated from other Networks.
b. Explain Wireless Lans
A
a. Three types of characteristics
3
10
b. Explaining the meaning of wireless
2
c. Explaining wireless LANs
3
d. Diagram of wireless LANs
2
5
Read the following case study thoroughly and answer the following questions:
India is the second most populous country in the world. Even with abundant natural resources, it is still considered a developing country. In India, it is necessary that research and development that has taken place in the field of communication should reach rural areas. This is because nearly 70% of the population lives in villages.
In India, physical infrastructure such as roads and highways is still not fully developed. Wired communication requires digging of roads, laying of cables and erecting towers. It involves tremendous human effort and enormous capital outlay in the rural and hilly areas. Hence wireless communication implemented through satellites can play a vital role.
Realising the importance of satellite communication, India implemented Satellite Instructional Television Experiment (SITE) in 1975-76. This made it possible to broadcast educational and other programs related to family planning, agriculture and health issues through television sets even in the remote areas. This initiative helps in creating awareness and also helps government in bringing developmental schemes to the door step of the masses.
An advantage of satellite communication is that, satellites can amplify the signals and resend it to thousands of stations on the ground at the same time. Digital TV and radio programmes can directly reach the receivers found in the cars and homes through a satellite. For large organisations, it has become much cheaper to transmit commercial information to thousands of their dealers scattered across the globe by means of satellites. Wired communication can easily get disrupted when the cables are damaged intentionally or unintentionally. However, microwave satellite communication is not affected even in the adverse environmental conditions. Thus, during the times of natural disasters, the physical infrastructure of wired communication may be destroyed. But still contact can be maintained with the affected people through the satellites. In addition, remote sensing satellites can be used to keep an eye on the enemy movements, determine the locations of natural resources, warn about impeding cyclones and exactly pinpoint the presence of fishes or submerged objects in the oceans or seas.
Another form of wireless communication is the mobile communication. Mobile handsets have made it possible for the people not only to converse among themselves but also carry out banking and e-commerce transactions. Satellites have also made it possible the implementation of Global System for Mobile Communication(GSM) through which wireless Internet can be provided.
a. Highlight the advantages of wireless communication over wired communication.
b. In what ways, rural India has benefited through satellite communication.
A
a. Listing the advantages of wireless
5
10
communication
b. List the benefits of satellite communication in rural India
5
6
Explain world wide web in detail
A
Defining WWW, HTML, HTTP, and HTTP request- response behavior
10

MI0036- BUSINESS INTELLIGENCE & TOOLS

How do you classify the different types of business Intelligence
A
9 types of BI
10
10
2
a. Similarity measures determine the similarity between the two objects. What are the four methods to determine the similarity characteristic between the two objects?
b. Illustrate decision tree
A
a. Listing four methods and explaining them
4
10
b. Illustrating decision tree
4
General form of decision tree diagram
2
3
Define data mining and describe the architectural framework of data mining.
A
Definition of data mining
2
10
Architecture of datamining- includes data preparation steps, DM three layers, database tier
8
4
Discuss the features of various types of business models with the help of examples.
A
Explaining the 6 types of business models
6
10
Examples for each
4
5
A non-profit organisation – a leader in promoting urban sustainability in India – has the permission to supervise and propose resourceful energy and source utilisation by corporate entities across India. The customer was using spreadsheets to confine various information with regards to unit consumption, charges, research, and analytics of Energy Usage. The Intensity for both Heating Degree Days & Cooling Degree Days, and it was suffering from the disadvantages of utilisation of multiple non-standard spreadsheets. The crucial challenge of the organisation was to develop excellence of data; time needed to gather & authenticate information, distribute graphs & analysis with cyclic time series, and carry out other ad hoc queries & difficult analysis.
Customer also wanted a BI solution that is easy to use, available from web, and needs negligible human resources to execute these periodic tasks. Elegant BI Business Intelligence solution deployed with customised ETL solution has offered web based, simple to use, and error-free analytic system to client, in short time span and small budget. Research coordinators at client side, now have complete picture of the energy usage patterns and trends in hours rather than days, and they spend more time doing other ad hoc research and data mining, rather than collecting, consolidating, and validating data from large number of spreadsheets received from member organisations every month. This initiative is helping customer sustain its management position for a better cause of supporting sustainable metropolitan communities in India.
a. What are the aspects of BI framework? Explain each of them in detail
b. What are the tools used in the above case study to meet the challenges of the organization and to maintain food quality as well?
A
a. Listing and explaining the 4 aspects of BI framework
5
10
b. Identifying the tools used
5
6
ABC is an online educational organization which offers number of programmes. Throughout the world. It has its franchise all over the world. It has to maintain huge data about all the all the programmes that are currently running and also that are withdrawn but still running for old students. How should it plan to implement the business intelligence solutions? What are the limitations of Business Intelligence?
A
Explaining planning to implement a BI solution
8
10
Listing the limitations of BI
2

Leave a Reply

You must be logged in to post a comment.