Language Bar

Thursday, January 19, 2012

CS403 GDB no 2 Solution


Total Marks
5
Starting Date
Wednesday, January 18, 2012
Closing Date
Thursday, January 19, 2012
Status
Open



Dear Students
GDB will be open for 2 days on 18th January 2012.
The topic of discussion is given below
“Normalization Process removes the anomalies from the data but ultimately it affects the Query Performance of DML operations:” why..? Justify the statement.
Guidelines      
·         Discuss both “Positive and negative effects” (if any)
·         Your answer should be precise and should not be greater than 6 lines
·         Do not post the answer of GDB topic in MDB


Solution 

Application of normal forms beyond third normal
form can tend to produce too many entities, resulting in too many
entities in SQL query joins. Too many entities in SQL query joins can
reduce system performance for any type of database. The more entities in a
join, the more difficult queries are to tune. Also, more query complexity
makes it more difficult for a database query optimizer to make a best guess
at the fastest execution path for a query. The result is poor performance.
From a purely commercial perspective, good performance is much more
important than granular perfection in relational database design. It’s not
about the design but more about satisfied customers and end users. Poor
response time from a computer system will upset people. In fact, poor
response time can be much more than simply upsetting because it can
impact business and the bottom line for a company.

Over normalization using third normal forms and beyond can lead to
poor performance in both OLTP and data warehouse type databases. Overnormalization
is more commercially in top-down designed Java object
applications. In this situation, an object structure is imposed onto a relational
database. Object and relational data structures are completely different
methodologies, because the fine details of granularity are inherent in
object modeling. The same is true of extreme application of normal forms,
but that creates too many entities, too much processing built into a database
model, and ultimately highly complex SQL coding and poor performance
as a result.




--------------------------------------------------------------------------------------------------------------




Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.


            


MKT501 GDB No 2 Solution



Total Marks
20
Starting Date
Tuesday, January 17, 2012
Closing Date
Thursday, January 19, 2012
Status
Open
Question/Description

Topics covered:

  • Critique of Selling
  • Selling techniques
Mr. Aslam is an entrepreneur and commenced his own small scale retail store business to earn his livelihood. With the passage of time his business started growing and he decided to update his business on modern technological processes. He decided to introduce inventory management system and scanned price tags in order to bring more accuracy and transparency in stock holding and accounts maintenance. Mr. Aslam intended to purchase that technological equipment from a world known electronics store. At the end of December, he visited the store, met a sales agent, told him the requirements and asked him to guide accordingly. Being at the end of the month, the sales agent was intrinsically compelled to meet his target sales. Hence; instead of guiding Mr. Aslam for a low cost Core2Duo machine (which can easily fulfill his requirements), sales agent persuaded him to purchase more expensive laptop and presented him its features in such an illusive manner that Aslam decided to purchase an expensive laptop. After some time, back at business place, Aslam regretted to purchase an expensive machine though it was no more beneficial to him than any other low cost computer and he decided not to go for shopping at that electronics store.


Discussion Question:
By keeping above case in consideration you are required to discuss the ethical perspective of the selling technique adopted by sales agent and the customer while purchasing a machine.

Important Instructions:

1.   Your discussion must be based on logical facts.
2.   Your comments on the topic should not exceed 500 words.
3.   The GDB will remain open for 2 working days/ 48 hours. (Change if more days are allowed)
4.   Do not copy or exchange your answer with other students.  Two identical / copied comments will be marked Zero (0) and may damage your grade in the course.
5.   Obnoxious or ignoble answer should be strictly avoided.
6.   Questions / queries related to the content of the GDB, which may be posted by the students on MDB or via e-mail, will not be replied till the due date of GDB is over.

     For Detailed Instructions please see the GDB Announcement





SOLUTION


See this one correct idea solution 
Mr. Aslam may seek the advice of a salesperson given that a salesperson can help him realize the right car given those criteria. This can be a socially useful function; salespeople have specialized knowledge of products that can help consumers make an informed decision.
However, a salesperson may also talk a consumer into purchasing more expensive equipment then he needs or can afford.
However, it is sometimes the case that customers purchase a product or service that was not initially intended and remains an inappropriate purchase after the fact. On the other hand, the consumer in this scenario can be held partially responsible for the inappropriate purchase; indeed, "A fool and his money are soon parted." (English proverb)
Selling Technique is the body of methods used in the profession of sales. A good salesperson is much more knowledgeable about their product or service than the prospect could ever likely be and can offer valuable information and insight to the decision making process.
Good selling involves asking questions to elicit the prospect's needs and desires and finding the appropriate product or service that meets those needs and that the prospect is willing to pay for. If good prospecting (qualifying) is done, then the prospect may already be well suited to the product or service and the salesperson simply needs to lead the prospect to act on the desires and needs he has. A good salesperson is much more knowledgeable about their product or service than the prospect could ever likely be and can offer valuable information and insight to the decision making process.


Plz don’t copy make your own word this is only idea and one more

Persuasive selling technique was used by the sales agent to persuade Mr. Aslam and due to it he bought the expensive machine. Sales agent personal involvement was also in it because he wanted to meet the target of his sales. Ethically it is wrong to show such type of behavior even after getting the full details from the buyer so sales agent crossed the boundary of ethics by changing the thinking of Mr. Aslam and he successfully made the sale by persuasion technique.
On the other hand Mr. Aslam went there only to buy inexpensive machine and ethically he took help and guidance from the sales agent. But he was misguided to buy expensive machine.
In the end don’t forget that persuader was sales agent and he persuaded Mr. Aslam but no sale can be completed without buyer’s intention to buy that product "A fool and his money are soon parted" in this case Mr. Aslam became fool and he bought an expensive machine. Ethically sales agent was wrong and Mr. Aslam was right in this case.
If you feel that this will not help then please do reply to get better solution.



CONTACT US FORM