• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 4 out of 53 pages
Exam (elaborations)

Database Management System: An Evolutionary Approach 1st Edition by Jagdish Chandra Patni, Hitesh Kumar Sharma and Ravi Tomar | TEST BANK & SOLUTIONS MANUAL

Document preview thumbnail
Preview 4 out of 53 pages

TEST BANK & SOLUTIONS MANUAL for Database Management System: An Evolutionary Approach 1st Edition by Jagdish Chandra Patni, Hitesh Kumar Sharma and Ravi Tomar. ISBN 4934 . (Complete Download). Table of Contents 1. Basics of Database. 1.1 Introduction and History of Database. 1.2 Data and Information. 1.3 Database. 1.4 Need for a Database. 1.5 File based database management system. 1.6 Database System. 1.7 Database System components. 1.8 Database Management System Services. 1.9 Database Characteristics. 1.10 Advantages of Database. 1.11 Limitations of Database. Case Studies. 2. Data models and Architecture of DBMS. 2.1 Evolution of Data Model. 2.2 Hierarchical Database Model. 2.3 Network Data Model. 2.4 Relational Database Model. 2.5 Object Oriented Data Model. 2.6 Object Relational Data Model. 2.7 Three Level Architecture of Database. 2.8 Data Independence. 2.9 Database Languages. 3. Relational Database Management System (RDBMS). 3.1 Difference Between RDBMS and DBMS. 3.2 Features of RDBMS. 3.3 Advantages of RDBMS. 3.4 Disadvantages of RDBMS. 3.5 Examples of RDBMS. 3.6 RDBMS Terminologies. 3.7 Keys in Database. 3.8 Integrity Constraints in DBMS. 3.9 Relational Algebra. 3.10 Structured Query Language (SQL). 3.11 CODD’s Twelve Rules of Relational Database. 3.12 Database Development Life Cycle. 4. Entity Relationship Model. 4.1 Entity Relationship Diagram. 4.2 Components of a ER Diagram. 4.3 Participation Constraints. 4.4 Strong and Weak Relationship. 4.5 Handling Many to Many Relationship. 4.6 Example of E-R Model. 4.7 Enhanced Entity-Relationship Model. 4.8 Reduction of ER Diagram to Relational model. 5. Normalization. 5.1 Introduction Normalization –A bottom up approach. 5.2 Need for Normalization. 5.3 Types of Dependencies. 5.4 First Normal Form. 5.5 Second Normal Form. 5.6 Third Normal Form. 5.7 Boyce-Codd Normal Form. 5.8 Multi-valued Dependency. 5.9 Join Dependency. 5.10 Lossless and Lossy Decompositions. 6. Managing Data Using Structured Query Language (SQL). 6.1 Introduction to SQL. 6.2 Data Definition Commands. 6.3 Data Manipulation Language (DML). 6.4 Data Control Language. 6.5 Transaction Control Language (TCL). 6.6 Data Query Language (DQL). 6.7 Aggregate Functions. 6.8 Date and Time Functions. 6.9 String Functions. 6.10 Conversion Functions. 6.11 Mathematical Functions. 6.12 Special Operators. 6.13 Types of Constraints. 6.14 Sub Query. 7. Introduction to PL/SQL. 7.1 Variable and Constants. 7.2 Data Types. 7.3 PL/SQL Literals. 7.4 Control Statement. 7.5 PL/SQL case statement. 7.6 PL/SQL Loop. 7.7 PL/SQL Continue statement. 7.8 PL/SQL GOTO statement. 7.9 PL/SQL Procedure and Functions. 7.10 PL/SQL cursor. 7.11 PL/SQL Exception. 7.12 PL/SQL Exception Handling. 7.13 PL/SQL Triggers. 8. Transaction Management in Database. 8.1 Definition of Transaction. 8.2 Properties of Transaction. 8.3 States of Transactions. 8.4 Schedule. 8.5 Serializability. 8.6 Recoverable Schedules. 8.7 Concurrency Control. 8.8 Concurrency Control Mechanism. 8.9 Database Back UP and Recovery. 8.10 Security, Integration and Authorization.

Content preview

,
,and excelling in the competitive market of today. For example, “59375598702” is the data
whereas the “phone number of Bob is 59375598702” is the information.


3. How information is smartly used to take decisions in a business? Explain.
Ans: Organizations are capable of processing the information and using it to make decisions
for surviving and excelling in the competitive market of today. The usage of information
extends across the company. Although the applications vary by industry, one constant is the
utilisation of accurate, timely information that may improve company operations and, as a
result, the customer experience. When the customer experience is improved, sales, earnings,
and businesses thrive. Information is fast and becoming the lifeblood of business, and its
significance in an organization's long-term success cannot be emphasized.


4. Describe information cycle with its advantages and disadvantages.
Ans: Data, pictures, text, documents, and speech are all forms of information. To obtain
information, data is processed using models. The produced information reaches the receiver in
good time and is then used to make judgments/decisions. These decisions can then cause
additional events and activities, resulting in enormous quantities of dispersed data that is
recorded and delivered as an input, and the cycle continues.


5. What do you mean by quality of information?
Ans: Information must be accurate, timely and relevant. Accuracy means there should not be
any manipulated or distorted information. It should clearly convey the meaning of the data it
is based on. Timeliness of information is defined as information reaching the recipient within
the needed period. The information may be of no use if it reaches/arrives late and relevancy
means that the information that may be relevant for one user may not be relevant for another
even though it might have been accurate as well as timely.


6. Explain the various stages of databases and discuss why we are using databases?
Ans:
Databases also have a finite lifespan. They also are replaced with successful databases that are
more flexible and have up-to-date structure. There are generally six stages of the database
lifecycle:
Analysis: The stakeholders(organizations, universities etc.) who require database management
services are interviewed in order to identify the problems, possibilities and constraints of the
existing system. In this phase the objectives and scope of the new system to be developed is
determined.

, Design: The conceptual design is created in this phase from the requirements gathered during
the analysis phase. A logical and physical design is also created for the easy implementation
of the database in the next step.
Implementation: In this step database management system (DBMS) is installed and databases
are created. The data is imported in created databases.
Testing: The database is tested and fine-tuned in respect to the applications that are going to
use it.
Operation: In this phase, the databases work properly and provide the needed information to
the users.
Maintenance: In this phase, changes are made to the database in response to new requirements.


A database can be defined as a collection of data, which is designed to be used by different
people. The data stored in disks and tapes is always dispersed and hence difficult to control.
Some other important reasons that move us towards adoption of databases for organization are
as follows:

• Duplication of data and effort from the users’ end.

• Redundancy of data.

• Data is hardcoded in applications.

• Inconsistent data.

• Data integrity issues.

• Data security issues.

• Concurrency issues.

• Non-uniform backup and recovery methods.

• Interdependence between data and programs.

• Ad hoc data management techniques.

• Ad hoc representation of relationships.



7. Define and discuss the components of a database and its uses.

Connected book
 image
Jagdish Chandra Patni, Hitesh Kumar Sharma, Ravi Tomar, Avita Katal Database Management System
Publisher: 2022 ISBN: 9780367244934 Edition: Unknown

Document information

Uploaded on
February 1, 2023
Number of pages
53
Written in
2022/2023
Type
Exam (elaborations)
Contains
Questions & answers
CA$42.80

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
AcademiContent
4.0
(393)
Sold
3228
Followers
2133
Items
1191
Last sold
20 hours ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions