SEM 3 INFORMATION TECHNOLOGY( IT) SUMMER 2013
SEM 3 INFORMATION TECHNOLOGY( IT) SUMMER 2013
MI0033 —Software Engineering
Q1. Waterfall Model, V-Model and Spiral Model are of the software development processes. Companies are using these models to have a systematic and defined approach in software development. Which of the four phases are involved in the software development process? (listing the 4 types- 4 marks, explaining the types- 4 marks, examples-2 marks) 10 marks
Q2. Suppose you have assigned the task of measuring the software product, how would you use the size oriented and function oriented metrics in your task? (explanation of size oriented metrics- 4 marks, explanation of function oriented metrics- 4marks, examples for each with problem-2 marks) 10 marks
Q3. a. You are a SCM manager in a software company. How will you establish a software configuration management process in a company? (definition- 1 marks, 4 procedures in software configuration management process-4 marks) b. You are appointed as a software developer in a software company and you have been asked by your project manager to check details of the bugs from the previous version. How will you gather details associated with the various bugs in the previous version? (definition — 1 mark, typical work cycle-4 marks) 5+5 marks
Q4. a. If you are a software engineer you must be expert in the field of software, hardware and also database. It has been listed by the industry professionals that time and effort are the most important factors in the system analysis stage. Briefly explain the steps used in in system analysis. ( listing the steps- 2 marks, explanation-4 marks) b. If you are a software developer in small company, how will you conduct a specification review? (explanation-4 marks)
Q5. What are the different methods of software prototypes and tools? (definition of software prototype-1 mark, 3 types of techniques- 3 marks, explaining tools- 4 marks, benefits of software prototype- 2 marks) 10 marks
Q6. List and explain any 5 principles of design fundamentals (Listing-5 marks, explanation- 5 marks)
MI0034 —Database Management Systems
Q1. Suppose the employee name, employee id, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequential address book or it can be stored on a hard disk, using a computer and software like Microsoft Excel. Using this example define a database. List and explain the various procedures carried on in a DBMS with a detailed example of the database. (defining a database- 1 mark, listing the 3 procedures — 3 marks, explanation- 3 marks, one examples for each of them – 3 marks)10 marks
Q2. What are the different types of interfaces provided by DBMS? (listing the 6 types: 3 marks, listing the properties of these types-7 marks) 10 marks
Q3. Level 2 cache has got higher latency than Level 1 by 2 times to 10 times in 512 KiB or more. Its value is nearer to kilobyte. This is one of the levels of memory hierarchy. Define memory hierarchy. What are the other levels in memory hierarchy? Explain in one life each for each of them. (defining memory hierarchy- 1 mark, listing the 6 levels -3 marks, explanation- 6 marks) 10 marks
Q4. Indexes are usually defines on a single field of a file called an indexing field. List and describe the different types of indexes (listing the 5 types of indexes-3marks, explanation in detail- 5 marks, examples- 2 marks ) 10 marks
Q5. Consider a book is written by a particular author. And you have to explain to some one the relationship that exists between the author and the book. Normally you can draw a diagram and show the relation. These diagrams are called entity-relationship diagram in which book is one entity, author is one entity, and the relationship that exists between the two entities is written. Likewise explain the various notations used to represent the ER diagram. (listing the notations with diagrams — 5 marks, explaining each one of them in one line with example each-5 marks )
Q6. Consider a banking database (select the tables and fields of your choice). Now apply all the operations of relational algebra and find the result. (creating database-2 marks, listing the operations of relational algebra- 3 marks, showing the result for all operations- 5 marks)
MI0035 —Computer Networks
Q1. Videoconferencing is used to conduct meetings with the people who are located in far distance. Videoconferencing is an example of which type of computer networks? Explain in detail the different types of networks with example. (identifying the correct type — 2 marks, list the different types of networks — 1 mark, explaining the types- 6 marks, examples-1 mark) 10 marks
Q2. Explain the three principles of data communication system. (explanation-5 marks, diagram — 2 marks, examples- 3 marks) 10 marks
Q3. Data compression technique makes the file size smaller so that it can easily get transmitted over any types of network such as internet, intranet or a local area network. Explain the different types of data compression (listing the different types with example — 5 marks, explanation- 5 marks) 5+5 marks
Q4. A protocol helps in establishing the communication between two systems. Protocols are mainly divided into asynchronous and synchronous protocols. List and describe in detail the different types of protocols that are classified under the two main protocols. (list and correct differentiating of protocols under the two main types — 5 marks, explanation- 5 marks) 10 marks
Q5. How are the different topologies of computer networks arranged? Explain the working of each of them (listing the different topologies with examples — 2 marks, explanation- 4 marks, diagrams- 4 marks) 10 marks
Q6. a. Elaborate the arrangement of IP addressing with an example (explanation- 3 marks, examples- 2 marks) b. List the various best internet service providers in India with respect to their efficiency. (listing — 2 marks, explaining — 3 marks)
MI0036 —Business Intelligence Tools
Q1. a. Emergency Medical Association (EMA) is a group of 250 board- certified emergency physicians. They are responsible for effectively managing the emergency departments. List out what BI values and applications they should be implementing (listing and explaining the reason behind it- 5 marks) b. Most of the credit card companies permit a consumer to get approval for specified amounts via mobile to ensure that the purchase is covered. This type of consumer support which retains a customer to the bank for a longer time is real time business intelligence. Define real time Business intelligence and the various steps involved in the process. (defining- 2 marks, list and explain the process- 3 marks) 5 + 5 marks
Q2. Today businesses largely rely on the information available and can be communicated through various sources, both internally and externally with the help of internet. Explain the role of Business Intelligence in modern business. What are the three different types of decision that most business organisations take? (explanation-5 marks, different types of decision-5 marks) 10 marks
Q3. a. Granularity of data is an important factor to be considered in the business which involves data warehousing. How the characteristics of data granularity does varies from application to application? List the different tools in data granularity. (4 points — 4 marks, listing- 2 marks) b. Consider a data warehousing enterprise where a Total data quality management (TDQM) cycle has to be implemented. Find the members involved in TDQM team of that organisation. (listing- 2 marks, explanation-2 marks)
Q4. a. You are given the responsibility to organise a tour for your batch to an organisation. Find out the parameters used by your team for data mining. (listing the parameters- 3 marks) b. Explaining the working of data mining. (explanation of how data mining works- 7 marks) 3+7 marks
Q5. According to a recent IDC report, knowledge management is in a state of high growth, especially among the business and legal services industries. As the performance metrics of early adopters are documenting the substantial benefits of knowledge management, more organizations are recognizing the value of leveraging organizational knowledge. Define Knowledge Management. Explain the various characteristics of Knowledge management. What are knowledge assets? (definition- 2 marks, characteristics—6 marks, definition-1 mark, example-1 mark) 10 marks
Q6. How to make the best use of Business intelligence? What are the advantages of BI with sales? (explanation- 5 marks, explanation- 5 marks) 10 Marks
