Unit I

By Alan Ortiz,2014-05-17 14:34
23 views 0
Feasibility study results in to a report called Feasibility Report which consist of : -A proposed solution to the problem including alternate solutions

    Unit I

Q1 Expand and explain in brief the following:

    i. GNU

    ii. SDLC

    iii. FLOSS

    iv. ER

Q2 What are the following software used for?

    i. Mozilla

    ii. Apache

Q3 Differentiate between entity and attribute with the help of an example

    Q4 Name any two applications of data mining.

    Q5 Identify the type of relationship represented by the following statement and

    draw an entity relationship diagram to show it.

    “Each garment must have one and only one price. Each price may be for one or

    more garments.” Q6 Explain the term OSS and GNU

    Q7 What are the following software used for?

    i. PHP

    ii. MySQL Ans. PHP is a programming language primarily for server side applications and

    developing dynamic web content.

    MySQL is a multithreaded, multiuser, SQL relational database Server(RDBS)

Q8 Name any four application areas of databases.

    Q9 What are the different types of relationships that can be depicted through an

    E/R model? Explain the concept of ER Model using the case study of a Ticket

    Reservation System that has three entities Ticket, Passenger and Train. Assume that

    each passenger can buy more than one ticket.

    Q10 Define:

    i. Freeware

    ii. Shareware Ans. The term free software is generally used for software, which is available free of

    cost and which allows copying and further distribution, but not modification and

    whose source code is not available. It is not free and open source software

    Shareware is software, which is made available with the right to redistribute copies.

    It is stipulated that if one intends to use the software, often after a certain period of

    time, then a license fee should be paid.

    Q11 Write one point of difference between front end and back end with one example

    of each.

    Ans. Front end is responsible for receiving user queries, requests etc. (interface with

    which the user interacts directly) and passing it over to the back end

    Backend handles all databases accesses through one or more servers. After processing the user’s requests, the server returns the results to the backend which interprets the results and passes them on to front end.

    Q12 Write one example each of “one to many” and “many to many” relationships

    between two entity sets


    Q13 What is the purpose of data mining? Give one example

    Ans. Data mining is used for predicting future trends and behaviours, allowing business to make proactive, knowledge-driven decisions. Or

    The purpose of data mining is to extract/obtain predictive information from the available set of past data.


    If we are looking for a sunken Spanish galleon on the high seas, the first thing we might do is to search the times when Spanish treasures had been found by others in the past. Based on that model of research , we can determine, where, most likely, can this ship be found.

    Q14 During System Development Life Cycle, in which phase is the scope and true nature of problem determined? Explain in brief with the help of an example. Ans. Analysis phase, during this phase the existing system’s

    problems/limitations/functioning are minutely analyzed. This give the clear picture of the problem so as to know the exact cause of the problem/limitation. Q15 Write one point of difference between a freeware and free software Ans. Free software is the software available at no cost and no restrictions i.e it can be copied, modified and redistributed, whereas

    Freeware is free of cost, can be copied and redistributed but cannot be modified as no source code is available.

    Q16 How is post implementation review important during system development life cycle?

    Ans. This phase is an evaluation of a system in terms of the extent to which the system accomplishes stated objectives and actual project costs exceed initial estimates. Its basic purpose is to see if the system has met the objectives set for it. Q17 identify the type of relationship represented in the following statement and draw an entity relationship diagram to show it: “A customer can buy many items.’

    Q18 Explain the term metadata with the help of example

    Ans. The information that describes the model and definitions of the source data elements is called a metadata. It is also known as data dictionary which stores table structures, indexes details, view details etc.


    In a table storing item details, the description of table’s data such as

    Itemcode integer

    Price float

    Itemname varchar2(20) is the metadata. (data about data)

    Q19 What is a Financial Accounting System? Name any two entities or tables that could be a part of this system?

    Ans. Financial Accounting is responsible for maintaining past and present accounting data, business transactions, assets and liabilities. The basic functions of this system are: recording, measuring, monitoring, planning and control, information for decision and communication.

    Two tables are: Business transaction table and assets table

    Q20 What is feasibility study with reference to SDLC? Explain

    Ans. The basic purpose is to determine whether the whole process of system analysis leading to computerization would be worth the effort for the organization Eg if an organization is attempting to integrate a number of different computerized systems, the feasibility study might reveal the fact that the integration would not yield desired result and it is better to design the system from scratch. Feasibility study results in to a report called Feasibility Report which consist of : -A proposed solution to the problem including alternate solutions considered. -Rough estimates on the cost/benefit analysis if solution implemented -Approximate time, effort and cost estimates for completion of the project Q21 Explain the concept of object oriented modeling.

    Ans. Object modeling refers to building models and performing activities so that all this leads up to the deployment of a good object-oriented system. The object modeling is associated with object-oriented design that considers a system with some objects and methods, where object have a state, and methods inspect and modify the object.

    Q22 Define data ware housing using suitable example.

     Ans. The process of making/developing data ware houses.

    It is a system for storing and delivering massive quantities of data. It is a centralized data repository that stores and provided already transformed and summarized data, therefore, making it an appropriate environment for more efficient DSS(Decision Support System)

    Eg, an orgainzation might be having a data warehouse storing details of its previous policies, decisions, performances, research etc. that is useful for making future decisions.

    Q23 What is an inventory control system? Name any two tables or entities that could be a part of this system?

    Ans. This system maintains optimum inventory levels, control inventory costs and track merchandise movement. It provides the tools needed to minimize inventory levels and out-of-stock conditions and maximize valuable management information and profitability.

    Two tables or entities are: item table and order table

    Q25 What do you understand by a many-to-one relationship? Explain with an example.

    Q26 Expand the term UML and explain its usage.

    Ans. Unioth clfieed Modeling Language . it is an open and industry standard visual modeling language for object oriented system. It is used to represent model of a system graphically. It represents system model by showing model elements (nodes) and relationship(arch) between them

Q27 Explain the concept of client server computing with the help of examples.

    Ans. The client/server computing system involves two important components: client

    And server.

    This system represents a model wherein request are made at one end the client and

    the services are provided at other end ---the server. It can be of various type: 1-tier,

    2-tier, 3-tier, n-tier

    Clent requestor of services.

    Server provider of services.

    A single machine can be both client as well as server depending on the software


    Q28 Name the essential components of SDLC . explain any two components in brief.

    Q29 Differentiate between ER modeling and object modeling technique.

    Ans. ER modeling

    - it goal is normalization and fast retrieval of data.

    - Cannot map real world models as it does not consider/include


    - Offers a static data structure

    - Grouping is possible only on the basis of entity types.

Object Modeling Technique

    - its goal is to model a business process using real world objects.

    - Can map real world models as it includes behaviour (relationship,


    - Offers a dynamic structure

    - Flexible grouping is possible as objects can also be grouped on the

    basis of behaviour types.

Q30 What is ER modeling? Explain the concept of ER modeling using the case

    study of a School that has three entities: student, teacher and subject. Assume that

    each student can study more than one subject while each teacher can teach only one


    Ans. Entity Relationship diagram /model is a high level, conceptual model that

    describe data in the form of entities, attributes and relationships

    Entity an object that exists and is distinguishable from other objects.

    Attribute a property of an attribute

    Relationship an association among several entities.

Report this document

For any questions or suggestions please email