ASSIGNMENT - 2
INFORMATION TECHNOLOGY FOR AGRIBUSINESS
BY
D BHAGYASHREE
2018-31-027
ONE MARK QUESTIONS
1. Define database
Database is a collection of data
2. Expand DBMS
Database Management System.
DBMS = Database + Management System.
3. Define DBMS
DBMS is a collection of inter-related data and set of programs to store & access those
data in an easy and effective manner.
4. What is Data redundancy?
Data redundancy refers to the duplication of data. Data redundancy often leads to
higher storage costs and poor access time.
5. What are two things that are required for DBMS
Storage of data and retrieval of data.
6. What is the main purpose of database systems?
The main purpose is to manage the data.
7. Drawbacks of File system in simple points
Data redundancy, Data inconsistency, Data Isolation, Dependency on application
programs, Atomicity issue.
8. What atomicity of transaction refers to?
“All or nothing”, which means either all the operations in a transaction executes or
none.
9. Mention 2 advantages of DBMS?
• Data Consistency and Integrity
• Easy access to data
10. Mention 2 disadvantages of DBMS?
DBMS implementation cost is high compared to the file system Complexity:
Database systems are complex to understand
11. How DBMS is applied in Banking sector?
For storing customer info, tracking day to day credit and debit transactions, generating
bank statements etc. All this work has been done with the help of Database
management systems.
12. List out some sectors where we can use DBMS?
Education sector, Banking sector, Telecom industry
13. Types of DBMS Architecture
There are three types of DBMS architecture:
1. Single tier architecture
2. Two tier architecture
3. Three tier architecture
14. Single tier architecture
In this type of architecture, the database is readily available on the client machine, any
request made by client doesn’t require a network connection to perform the action on
the database.
15. In two-tier architecture, where is the Database system and DBMS application is
present?
In two-tier architecture, the Database system is present at the server machine and the
DBMS application is present at the client machine
16. Three Level Architecture in DBMS
1. External level
2. Conceptual level
3. Internal level
17. External level is known as…………VIEW LEVEL
18. What is the reason for knowing External level as “View level”?
The reason this level is called “view” is because several users can view their desired
data from this level which is internally fetched from database with the help of
conceptual and internal level mapping.
19. What is conceptual level?
The whole design of the database such as relationship among data, schema of data etc.
are described in this level. Database constraints and security are also implemented in
this level of architecture. This level is maintained by DBA (database administrator).
20. Lowest level of the architecture………… Internal level
21. What is internal level of architecture meant for?
This level describes how the data is actually stored in the storage devices. This level is
also responsible for allocating space to the data
22. What is Data abstraction?
The process of hiding irrelevant details from user (in order to ease the user interaction
with database, the developers hide internal irrelevant details from users) is known as
Data abstraction.
23. What are the three levels of abstraction?
Physical level, Logical level and View level.
24. Which level describes the user interaction with database system. -View level
25. What is the physical level of data abstraction?
This is the lowest level of data abstraction. It describes how data is actually stored in
database. You can get the complex data structure details at this level.
5 MARK QUESTIONS
26. What is DBMS and need and purpose of DBMS?
27. Explain the advantages of DBMS over file system?
28. Write the disadvantages of DBMS?
29. Note down the applications of DBMS?
30. Explain single tier architecture with an example?
31. Explain two tier architecture with a diagram?
32. Explain three tier architecture with a diagram?
10 mark questions
33. Explain in detail about DBMS?
34. Write a note on application of DBMS in Agriculture sector?
35. Explain DBMS Architecture and its types with suitable diagram?
36. Explain DBMS Three level architecture with diagram?
37. Briefly explain database abstraction and its level?
