Unit – I
Q1 Expand and explain in brief the following:
Q2 What are the following software used for?
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?
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.
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
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
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
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.