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 COMPUTER
APPLICATION
SEMESTER V
SUBJECT CODE & NAME Mit405– Data
Warehousing and Data Mining
Assignment Set -1
Q.1
Explain the key issues during data warehouse construction.
Differentiate
between data warehouse and OLTP databases.
5+5
Answer
:
Differences between OLTP and Data
Warehouse :
● Application databases
are OLTP (On-Line Transaction Processing) systems where every transaction has
to be recorded as and when it occurs. Consider the scenario where a bank ATM
has disbursed cash to a customer but was unable to record this event in the bank
records. If this
Q.2 Explain metadata classification.
Using suitable diagram show the relationship between metadata
classifications. 7+3
Answer
:
Metadata classification :
Before
gathering the overall collection strategy for metadata, the organization must
access metadata requirements. The method is iterative process with planned
intermittent release. It is the warehouse architect responsibility to define
and determine the scope and importance of metadata to be collected before a
strategy is put into place. It is the responsibility of the development team to
assign
Q.3
Elaborate the basic tasks involve in data transformation. 10
Answer
:
Basic tasks involve in data
transformation :
Data
transformations are often the most complex and, in terms of processing time,
the most costly part of the ETL process. They can range from simple data
conversions to extremely complex data scrubbing techniques. Before moving the
extracted data from the source systems into the Data Warehouse, you inevitably
have to perform various kinds of data transformations. You have to transform
the data according to standards because they come from many dissimilar source
Assignment Set -II
Q.1
Differentiate between the following:
(a)
Business Intelligence vs. Data warehouse 5
(b)
Business Intelligence vs. Data mining 5
Answer
:
BI versus Data Warehouse :
Data
Warehousing deals with all aspects of managing the development, implementation
and operation of a data warehouse or data mart including Meta data management,
data acquisition, data cleansing, data transformation, storage management, data
distribution, data archiving, operational reporting, analytical reporting,
security management, backup/recovery planning, etc. Business
Q.2
Explain the following:
(a)
Database Management Systems (DBMS) vs. Data Mining. 5
(b)
Data mining techniques. 5
Answer :
Data Mining Vs Database Management
System (DBMS) :
DBMS
stands for “Database Management System". This is the software that manages
data on physical storage devices. The software provides the ability to store,
access and modify the data. The software also provides a suite of utilities to
manage and monitor the performance on those actions against the data. Examples
of a DBMS would be Oracle, SQL/Server, DB2 and Informix in the relational (
Q.3
List and describe the categories of web mining. 10
Answer :
Categories of Web Mining :
Web
mining can be broadly defined as the discovery and analysis of useful
information from the World Wide Web. Web mining can be broadly divided into
three categories:
●
Web Content Mining
●
Web Structure Mining
●
Web Usage Mining.
All
of the three categories focus on the process of knowledge discovery of
implicit, previously unknown and
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)
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)
MIT4064– Customer Relationship
Management
Assignment Set - 1
Q1
Describe operational CRM and its components.
Answer:
Operational
CRM
The customer-facing applications of CRM such as
sales automation, enterprise marketing automation and customer service are
known as operational CRM.
Operational CRM emphasizes on automation of
horizontally integrated business processes, together with
Q2
Elaborate the two ways of using the e-mail management capabilities in
Enterprise Marketing Automation.
Answer:
There
are two ways of using the e-mail management capabilities in MA. They are:
•
Inbound e-mail management – It helps organizations
to handle inbound queries raised by the customers. The inbound e-mail
management is totally considered as a service-oriented activity. Organizations
carry out
Q3
Explain customer response management via following:
(a)e-mail
(b)SMS
Answer:
Customer
response management via email:
One of the most popular channels these days is
e-mail, as the urban customer prefers to receive all the communication through
electronic mail. It helps the customer not only to check the e-mails as and
when convenient, but also provide them sufficient information online and thus
reduce the need to visit stores and shops. When a company chooses to capture
the customer response via e-mail, the company has to decide what responses must
be captured as multi-level responses can be
Assignment Set - 2
Q1
Describe the followings:
(a)First
part call control
(b)Third party call control
Answer:
(a)First
party call control
In first
party call control, there is a direct connection between the user’s personal
computer (PC) and the telephone system. The telephone functionality is
typically built into the computer with a modem card. This can also be
Q2
Describe the steps followed in CRM project planning.
Answer:
The
following steps are followed in project planning:
1. Breaking up of the requirement specifications
into smaller subtasks or activities
2. Sequencing of activities and identifying
activities that can be implemented at the same time
3. Framing a
Q3
Describe the three business advantages and disadvantages of implementing
application service provider (ASP).
Answer:
The
three business advantages of implementing application service provider are:
• Pay-as-you-go – An ASP charges the company a
monthly rental which can help spread the costs for the company.
• No 'extras' needed – The Company need not pay for
any specialist or expensive hardware. That is, 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)
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)
MIT4073-
WIRELESS AND MOBILE COMMUNICATION
Set
-1
Q1 Briefly explain the functions of
each layer in the TCP/IP reference model?
5x2
Answer:
The TCP/IP Reference
Model :
TCP/IP
means Transmission Control Protocol and Internet Protocol. It is the network
model used in the current Internet architecture as well. Protocols are set of
rules which govern every possible communication over a network. These protocols
describe the movement of data between the source and destination or the
Q2 Explain how Frequency Division
Duplex (FDD) is applied in GSM standard for 900 MHz (5X2) 10
Answer:
Frequency Division
Duplex (FDD) is applied in GSM standard for 900 MHz :\
Frequency division multiple access (FDMA) is a medium
accessing scheme by allocating frequencies to transmission channels according
to the Frequency Division Multiplexing (FDM) scheme. Note that in FDM, medium
is accessed by the users through the frequency allocated to them. Allocation of
frequencies can either be fixed or dynamic. For example, frequency allocated is
fixed for radio
Q3 Explain about the GSM TDMA frame
with the help of frame structure.
Answer:
GSM – TDMA/FDMA
Frame :
In GSM architecture that the entities are connected
through certain type of interface. Each interface has its own use and
functionality. For example, Um is a radio interface that comprises the
mechanism for multiplexing and media access. Let us study how this interface
that deploys TDMA/FDMA for media access works. GSM implements Space Division
Multiple Access (SDMA) using cells with
Set
-2
Q1 Explain the IEEE 802.11 protocol
architecture.
Answer:
IEEE 802.11 protocol
architecture :
IEEE 802.11 standard is
often termed as Wi-Fi and has become the defacto standard. This standard is an
example of WLANs. There are variety of standards under the IEEE 802.11
standards, each with a letter suffix. IEEE 802.11 standards cover everything
for the wireless standards and include standards for security aspects, quality
of service and other related to wireless
Q2 Justify that “There is the
problem with TCP when it is used with the fixed networks together with mobile
and wireless devices”. 10 10
Answer:
Mobile and wireless devices are connected to the fixed
network through the access point. Slow start algorithm is a useful mechanism in
fixed networks but it is not efficient when TCP is used together with mobile
receivers or senders. It is because in networks with mobile and wireless
end-systems, the main reason for packet loss may not be due to congestion.
Remember that TCP concludes that a congestion situation has occurred whenever
it detects a missing
Q3 Explain in brief the
configuration parameters that needs to be adapted by the TCP in the wireless
environments. 10
Answer:
Configuration
parameters that needs to be adapted by the TCP in the wireless environments :
Transaction-oriented TCP
(T/TCP) was developed for the mobile host that requires reliable transmission
while sending a short request to a server time to time and gets responded with
a short message. Standard TCP requires packets for connection setup and release
for reliable and successful transfer of data packets. Since standard TCP
requires several packets over the wireless link, it is not be suitable just for
the transmission of short request or short message with several packets.
Moreover, setup
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)
