2.1 ORGANIZATIONAL BEHAVIOUR1 Suggest any suitable motivational theory for IT industry and substantiate yourviews.2. “Attitude determines your Altitude”-Substantiate your views on this quote withrelevant corporate examples.3. “A happy Worker is a productive worker”- Discuss in a behavioural perspective.4. ‘Organisational development involves the development of organization in thelight of its future expansion plan’. Elaborate your views.2.2 MANAGEMENT INFORMATION SYSTEM1. Discuss MIS strategies that companies in the electricity utilities industry couldemploy to achieve a competitive advantage.2. “The best way to reduce systems development costs is to use applicationsoftware packages or fourth-generation tools”. Do you agree or disagree?Substantiate your answer.3. Adopting an enterprise application is a key business decision as well as atechnology decision. Do you agree or disagree? Justify your views.4. Discuss in detail the activities involved in the development of e-commerce basedInformation System in a retail sector.2.3 DATABASE MANAGEMENT SYSTEM1. Create an ER diagram for the loan management system of a finance company.Loans are given on the purchase of various items with different interest rates.The company keeps track of defaulters and taken appropriate steps againstthem. Make and state suitable assumption (if any).2. Draw a neat sketch to indicate the architecture of a distributed data base system forcollege administration process with an example. Explain the various forms of datafor fragmentation used in DDB.3. Develop a conceptual data model for a hospital information system and write aPL/SQL program using oracle to perform the following tasks.a) Print the patient – details according to room wise.b) Print the patient – details according to disease wise.c) Print the patient – details according to the doctors attending them.(Assume your own tables and fields)4. Consider the following relational schemaAccount (A/C No., branch name, balance)Loan (Loan No., A/C No.)Depositor (Customer Name, A/C No.)Borrower (Customer Name, Loan No.)Write queries in SQL for the following.a) Find all loan number for loan made at Thanjavur branch.b) Find all customers who have both a loan and an account in the bank at eachbank.c) Find the number of depositors in each branch.32.4 E-COMMERCE1. Give the skeleton of the design of a virtual library system for the UGC.2. E – Commerce is a boom to the corporate world – comment.3. Compare the communication system in traditional business and on-linebusiness.4. Discuss the role of data mining techniques and data visualization in ECommerce.2.5 ENTERPRISE RESOURCE PLANNING1. Rank the various ERP packages in the order of their market share. Give suitablesuggestions for your ranking.2. Carrying out a study of EPC as adopted by SAP and show how it complementsthe Generic Modeling Technique.3. Is IRP implementation same as ERP packages implementation? Give reasons foryour answer.4. Discuss briefly about the organization with ERP and organization without ERP.Which type of organization is better? Substantiate your views.2.6 DATA WAREHOUSING AND DATA MINING1. Suppose that a data warehouse for big-university consist of the following fourdimensions: Student, Course, Semester and Instructor, and two measures countand avg_grade. When at the lowest conceptual level (Ex. For a given student,course, semester and instructor combination), the avg_grade measure stores theactual course grade of the student. At higher conceptual level, avg_grade storesthe average grade for the given combination.a. Draw a snowflake schema diagram for the data warehouse.b. Starting with the base cuboid (Student, Course, Semester, Instructor). Whatspecific OLAP operations (eg. Roll-up from Semester to Year) should oneperform in order to list the average grade of MBA courses for each biguniversity students.c. If each dimension has five levels (including all) such asStudent<major<status<university<all, how many cuboids will this cubecontains (including the base).2. Give an example where data mining is crucial to the success of a business. Whatdata mining functions does this business need? Can they be performedalternatively by data query processing or simple statistical analysis?3. Illustrate with an example, each of the following data mining functionalities:(a) Association and Correlation analysis, (b) Classification, (c) Prediction,(d)Clustering and (e)Evolution analysis.4. Describe in detail about the various applications of data mining in finance, biomedical science and retail fields.42.7.1 SOFTWARE PROJECT MANAGEMENT1. a) How an user can be involved in defining a project? Explain.b) Identify the milestones in a project schedules plan. Discuss the difficulties inpreparing the plan.2. a) Compare the initial and final schedule of a project with an example.b) How weak quality in a project can be anticipated? Justify your answer.3. a) Discuss the relationships that exist among activities. Give examples.b) How to create the activity responsibility matrix? Give its importance.4. a) Discuss the vendor management tools in project.b) Explain the various attributes of successful leader.2.7.2 ADVANCED WEB DESIGN1. Design and develop a website using ASP .NET MVC 4, EF, Knockoutis andBootstrap for an online trading company.2. Design a website on your own and discuss the following for developing yourwebsite:(a) Identify which type of website you will design – personal, organizational orcommercial. Write a brief paragraph describing the website’s overall purposeand its targeted audience. Create a name for your website.(b) List atleast three general goals for your website. List elements in addition totext – photos, music, animation, and so forth – that you could include onyour general goals.(c) Identify the design tools you expect to use to develop your website.(d) Identify an available domain name and URL for your website. Research tomake sure it is available.3. Design and develop a website for a MNC and describe the following:(a) Identify the element(s) that you could include on your website that wouldconvey to its audience that the website’s content is current.(b) Identify the connectivity tools you will use to encourage users to publish orpromote your content and explain how you will use them.(c) Identify ways you can promote interactivity at your website.(d) Create an appropriate tag line for your website and describe how you willuse it in the website’s design.(e) Describe how you plan to use basic design principles to enhance yourwebsite’s usability.4. Use any one of the search engine to search for websites for network marketingcompanies and describe the following process: (a) Open each website in a differenttab; (b) Review the privacy and data security issues and tools discussed at eachwebsite; and (c) Explain how you would use this information to ensure the privacyof visitors’ information and the security of visitors’ data at your website.
