The document provides an introduction to database systems. It defines key terms like database, database management system (DBMS), and database system. It describes the characteristics of database systems and some advantages over file-based systems, like reduced redundancy and supporting multiple users. It also outlines typical DBMS functionality, components of a database system environment, different types of database users, and the historical development of database technology.
This document provides an overview of a Relational Database Management System (RDBMS) unit prepared by D.GAYA, an Assistant Professor of Computer Science at Pondicherry University Community College. It defines key RDBMS concepts and components, including database languages, the query processor, runtime and database managers, and the database engine. It also outlines benefits of RDBMS such as data security, sharing, integration and abstraction/independence. Applications mentioned include following ACID properties, multi-user access, multiple views, and security features. Finally, it briefly introduces data modeling and different data models.
The document discusses key concepts related to databases and database management systems (DBMS). It defines what a database is - a collection of interrelated data organized for efficient retrieval, insertion and deletion. It describes characteristics of the database approach like self-describing nature, insulation between programs and data, support of multiple views, and sharing of data. The document also discusses database management systems, advantages and disadvantages of DBMS, types of DBMS like hierarchical, network, relational and object-oriented, database architectures, types of databases like centralized and distributed, data models, and defines what a database schema is.
This document provides an introduction to database management systems (DBMS). It defines key DBMS concepts like databases, data, schemas, and instances. It describes typical DBMS functionality like defining databases, loading data, querying data, and concurrent access. It introduces data models, DBMS languages, database users, and advantages of the database approach. It also discusses the hierarchical and network data models. The document aims to give an overview of fundamental DBMS concepts and components.
1. The document provides an overview of database management systems (DBMS), including their key characteristics, architecture, data models, schemas, and independence. A DBMS stores data in a way that makes it easier to retrieve, manipulate and generate information from it.
2. A typical 3-tier architecture separates a DBMS into 3 tiers - a database data tier, application middle tier, and user presentation tier. This makes the system highly modular and independent.
3. Common data models include the entity-relationship model and relational model. The entity-relationship model represents real-world entities and relationships, while the relational model stores data in tables and uses normalization.
The document provides information on database management systems and related concepts. It defines key terms like data, information, field, record, file, and database. It describes the functionalities of a database like defining, constructing, and manipulating it. It discusses database system architecture including the data model, database management system (DBMS), database administrators, database designers, and end users. It also covers database characteristics, advantages and disadvantages of the DBMS approach.
1) Database systems provide several key advantages over file-based systems, including controlling redundancy, restricting unauthorized access, and representing complex relationships among data. They allow data to be stored logically in one place while supporting multiple views.
2) A DBMS allows defining data structures, manipulating and sharing databases for applications. It provides facilities for backup/recovery and enforcing integrity constraints.
3) A database administrator is responsible for authorizing access, coordinating use, and acquiring resources for the database and DBMS. Their role is to oversee the primary resource of the database and secondary resources of related software.
The document provides an introduction to database systems. It defines key terms like database, database management system (DBMS), and database system. It describes the characteristics of database systems and some advantages over file-based systems, like reduced redundancy and supporting multiple users. It also outlines typical DBMS functionality, components of a database system environment, different types of database users, and the historical development of database technology.
This document provides an overview of a Relational Database Management System (RDBMS) unit prepared by D.GAYA, an Assistant Professor of Computer Science at Pondicherry University Community College. It defines key RDBMS concepts and components, including database languages, the query processor, runtime and database managers, and the database engine. It also outlines benefits of RDBMS such as data security, sharing, integration and abstraction/independence. Applications mentioned include following ACID properties, multi-user access, multiple views, and security features. Finally, it briefly introduces data modeling and different data models.
The document discusses key concepts related to databases and database management systems (DBMS). It defines what a database is - a collection of interrelated data organized for efficient retrieval, insertion and deletion. It describes characteristics of the database approach like self-describing nature, insulation between programs and data, support of multiple views, and sharing of data. The document also discusses database management systems, advantages and disadvantages of DBMS, types of DBMS like hierarchical, network, relational and object-oriented, database architectures, types of databases like centralized and distributed, data models, and defines what a database schema is.
This document provides an introduction to database management systems (DBMS). It defines key DBMS concepts like databases, data, schemas, and instances. It describes typical DBMS functionality like defining databases, loading data, querying data, and concurrent access. It introduces data models, DBMS languages, database users, and advantages of the database approach. It also discusses the hierarchical and network data models. The document aims to give an overview of fundamental DBMS concepts and components.
1. The document provides an overview of database management systems (DBMS), including their key characteristics, architecture, data models, schemas, and independence. A DBMS stores data in a way that makes it easier to retrieve, manipulate and generate information from it.
2. A typical 3-tier architecture separates a DBMS into 3 tiers - a database data tier, application middle tier, and user presentation tier. This makes the system highly modular and independent.
3. Common data models include the entity-relationship model and relational model. The entity-relationship model represents real-world entities and relationships, while the relational model stores data in tables and uses normalization.
The document provides information on database management systems and related concepts. It defines key terms like data, information, field, record, file, and database. It describes the functionalities of a database like defining, constructing, and manipulating it. It discusses database system architecture including the data model, database management system (DBMS), database administrators, database designers, and end users. It also covers database characteristics, advantages and disadvantages of the DBMS approach.
1) Database systems provide several key advantages over file-based systems, including controlling redundancy, restricting unauthorized access, and representing complex relationships among data. They allow data to be stored logically in one place while supporting multiple views.
2) A DBMS allows defining data structures, manipulating and sharing databases for applications. It provides facilities for backup/recovery and enforcing integrity constraints.
3) A database administrator is responsible for authorizing access, coordinating use, and acquiring resources for the database and DBMS. Their role is to oversee the primary resource of the database and secondary resources of related software.
- DBMS stands for Database Management System and is a collection of interrelated data and a set of programs used to access, update, and manage the data. The goal of a DBMS is to provide an environment that is convenient and efficient for retrieving, storing, and manipulating data.
- A database schema represents the logical structure of a database and includes information about the database's tables, fields, relationships, and data types. A database instance is a snapshot of the data stored in a database at a particular point in time.
- There are three levels of data abstraction: the physical level describes how data is physically stored, the logical level describes the logical relationships and structure of data, and the view level describes how different
Adbms 3 main characteristics of the database approachVaibhav Khanna
Self-describing nature of a database system:
A DBMS catalog stores the description of a particular database (e.g. data structures, types, and constraints)
The description is called meta-data.
This allows the DBMS software to work with different database applications.
Insulation between programs and data:
Called program-data independence.
Allows changing data structures and storage organization without having to change the DBMS access programs.
This chapter introduces databases and database management systems (DBMS). It defines key concepts like data, database, and DBMS. It also provides examples of database applications and typical DBMS functionality like defining databases, loading data, and concurrent access. The chapter concludes by discussing the advantages and limitations of using a DBMS.
This document discusses data, information, databases, database management systems (DBMS), and the architecture of DBMS. It defines data as raw unorganized facts and information as processed data that provides meaning. A database is a shared collection of interrelated data designed to meet an organization's information needs. A DBMS is a collection of programs used to create and maintain a database. The document then describes the components of a typical DBMS architecture including the query processor, file manager, data manager, and data dictionary. It also discusses database users such as administrators, designers, analysts, and various types of end users.
This document provides an overview of database management systems (DBMS). It discusses what a DBMS is, its architecture and components. A DBMS allows for centralized control of data to reduce redundancy and inconsistencies. It also provides data sharing, integrity, security and recovery mechanisms. The document describes the entity-relationship, network, relational and object-oriented data models. It also discusses the three-tier architecture of a DBMS and the concept of data abstraction through the three schema architecture.
The document discusses database management systems (DBMS). It defines a database as a collection of related data and describes a DBMS as software that enables users to create, maintain and share databases. It provides an example of a university database with files for students, courses, grades and prerequisites. It outlines key characteristics of the database approach such as self-describing nature, insulation between programs and data, support of multiple views, and sharing of data.
The document discusses database management systems (DBMS). It defines key concepts like a database, DBMS, data models, and database users. It describes typical DBMS functionality including defining and constructing a database, data manipulation and querying, and concurrent access. Examples of a university database are provided. The advantages of the DBMS approach are controlling redundancy, restricting unauthorized access, providing persistent storage and efficient query processing. Database models, schemas and instances are introduced.
A database management system (DBMS) stores and manages data to allow for efficient retrieval, manipulation, and information production. It uses real-world entities and relationships to design its architecture in a normalized format to reduce redundancy. A DBMS provides features like querying languages, multi-user access, security, and multiple views. It has various types of users including administrators who maintain the system, designers who design the database structure, and end users who access applications to complete tasks. A DBMS represents data entities as tables with attributes, keys for identification, and relationships between tables.
The document provides an introduction to basic concepts of database systems including definitions of data, information, and knowledge. It discusses data/information processing and what a database and DBMS are. The main characteristics of the database approach are described including self-describing nature, insulation between programs and data, data abstraction, and support of multiple views. The document also discusses database users including actors on the scene like DBAs and end users, and workers behind the scene like DBMS designers. Finally, it briefly introduces some common data models like hierarchical, network, entity-relationship, relational, and object-oriented models.
Unit 1: Introduction to DBMS Unit 1 CompleteRaj vardhan
This document discusses database management systems (DBMS) and their advantages over traditional file-based data storage. It describes the key components of a DBMS, including the hardware, software, data, procedures, and users. It also explains the three levels of abstraction in a DBMS - the physical level, logical level, and view level - and how they provide data independence. Finally, it provides an overview of different data models like hierarchical, network, and relational models.
What is Data ?
What is Information?
Data Models, Schema and Instances
Components of Database System
What is DBMS ?
Database Languages
Applications of DBMS
Introduction to Databases
Fundamentals of Data Modeling and Database Design
Database Normalization
Types of keys in database management system
Distributed Database
This document discusses database management systems (DBMS) and their components. It describes DBMS as a set of programs that allow for the storage and retrieval of data. It then discusses the key components of a DBMS including the physical, logical, and view levels of abstraction, data models, data independence, data definition and manipulation languages like SQL, and the roles of database administrators and users. The document provides an overview of the architecture and design of database systems.
The document discusses database essentials including database management systems, database applications, the purpose of database systems, data models, database languages, database architecture, and the relational data model. Specifically, it defines what a DBMS is, provides examples of common database applications, describes why databases were developed to address limitations of file processing systems, outlines several data models including the relational model, discusses database languages for defining and manipulating data, presents the client-server architecture of database systems, and explains key concepts of the relational model including tables, tuples, attributes, relations, and domains.
The document provides an overview of database management systems (DBMS). It defines DBMS as software that creates, organizes, and manages databases. It discusses key DBMS concepts like data models, schemas, instances, and database languages. Components of a database system including users, software, hardware, and data are described. Popular DBMS examples like Oracle, SQL Server, and MS Access are listed along with common applications of DBMS in various industries.
CP 121_2.pptx about time to be implementflyinimohamed
The document discusses database concepts and architecture. It covers the three levels of data abstraction - physical, logical, and external levels. It also describes the three schema architecture, including the physical, conceptual, and external schemas. This architecture provides data independence and allows mappings between the different levels. The document also discusses different types of database systems such as single-user, multi-user, centralized, distributed, parallel, and client/server databases.
The document provides an introduction to database management systems and their components. It discusses that a database is a collection of related data representing some aspect of the real world. A database management system (DBMS) allows users to define, construct, manipulate and share databases. The key functions of a DBMS include data definition, data storage, data manipulation such as querying and updating, and sharing data among multiple users. The document also provides examples of database systems and their typical components such as utilities, tools, and centralized and client/server architectures.
1. The document discusses the components and overall structure of a database management system (DBMS). It describes the various levels of database architecture including the physical, logical, and external levels.
2. The key components of a DBMS include users, a query processor, storage manager, and data structures. The query processor consists of a DML compiler, DDL interpreter, and query evaluation engine. The storage manager includes modules for authorization, transactions, file management, and buffering.
3. Data models help represent the design of a database and describe entities, attributes, relationships, and constraints. Common models include the entity-relationship model and object-oriented model.
The document discusses different types of users that interact with a database management system (DBMS). It identifies end users, application programmers, system analysts, database administrators, and sophisticated users. It then describes key characteristics of the database approach including managing information, easy implementation of operations, multiple views of the database, representing real world applications, self-describing nature, logical relationships between records and data, and separation between programs and data.
The document provides an introduction to database management systems (DBMS). It defines a database as a collection of interrelated data organized for efficient retrieval, insertion and deletion. A DBMS is software that allows users to define, create, maintain and control access to the database. It also discusses the benefits of using a DBMS compared to file systems such as reduced redundancy, improved consistency and security. The key components of a DBMS architecture are also summarized such as the query processor, data dictionary, storage manager and query evaluation engine.
System software runs when the system is turned on to provide a platform for application software to run. It is written in low-level assembly language and is general purpose. Application software performs specific tasks for users and is written in high-level languages like C++ and Java. It only runs when requested by users and is user-specific. The key difference between system and application software is that system software provides the underlying platform while application software performs specific tasks.
Information and Communication Technology in EducationMJDuyan
(𝐓𝐋𝐄 𝟏𝟎𝟎) (𝐋𝐞𝐬𝐬𝐨𝐧 2)-𝐏𝐫𝐞𝐥𝐢𝐦𝐬
𝐄𝐱𝐩𝐥𝐚𝐢𝐧 𝐭𝐡𝐞 𝐈𝐂𝐓 𝐢𝐧 𝐞𝐝𝐮𝐜𝐚𝐭𝐢𝐨𝐧:
Students will be able to explain the role and impact of Information and Communication Technology (ICT) in education. They will understand how ICT tools, such as computers, the internet, and educational software, enhance learning and teaching processes. By exploring various ICT applications, students will recognize how these technologies facilitate access to information, improve communication, support collaboration, and enable personalized learning experiences.
𝐃𝐢𝐬𝐜𝐮𝐬𝐬 𝐭𝐡𝐞 𝐫𝐞𝐥𝐢𝐚𝐛𝐥𝐞 𝐬𝐨𝐮𝐫𝐜𝐞𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐧𝐞𝐭:
-Students will be able to discuss what constitutes reliable sources on the internet. They will learn to identify key characteristics of trustworthy information, such as credibility, accuracy, and authority. By examining different types of online sources, students will develop skills to evaluate the reliability of websites and content, ensuring they can distinguish between reputable information and misinformation.
- DBMS stands for Database Management System and is a collection of interrelated data and a set of programs used to access, update, and manage the data. The goal of a DBMS is to provide an environment that is convenient and efficient for retrieving, storing, and manipulating data.
- A database schema represents the logical structure of a database and includes information about the database's tables, fields, relationships, and data types. A database instance is a snapshot of the data stored in a database at a particular point in time.
- There are three levels of data abstraction: the physical level describes how data is physically stored, the logical level describes the logical relationships and structure of data, and the view level describes how different
Adbms 3 main characteristics of the database approachVaibhav Khanna
Self-describing nature of a database system:
A DBMS catalog stores the description of a particular database (e.g. data structures, types, and constraints)
The description is called meta-data.
This allows the DBMS software to work with different database applications.
Insulation between programs and data:
Called program-data independence.
Allows changing data structures and storage organization without having to change the DBMS access programs.
This chapter introduces databases and database management systems (DBMS). It defines key concepts like data, database, and DBMS. It also provides examples of database applications and typical DBMS functionality like defining databases, loading data, and concurrent access. The chapter concludes by discussing the advantages and limitations of using a DBMS.
This document discusses data, information, databases, database management systems (DBMS), and the architecture of DBMS. It defines data as raw unorganized facts and information as processed data that provides meaning. A database is a shared collection of interrelated data designed to meet an organization's information needs. A DBMS is a collection of programs used to create and maintain a database. The document then describes the components of a typical DBMS architecture including the query processor, file manager, data manager, and data dictionary. It also discusses database users such as administrators, designers, analysts, and various types of end users.
This document provides an overview of database management systems (DBMS). It discusses what a DBMS is, its architecture and components. A DBMS allows for centralized control of data to reduce redundancy and inconsistencies. It also provides data sharing, integrity, security and recovery mechanisms. The document describes the entity-relationship, network, relational and object-oriented data models. It also discusses the three-tier architecture of a DBMS and the concept of data abstraction through the three schema architecture.
The document discusses database management systems (DBMS). It defines a database as a collection of related data and describes a DBMS as software that enables users to create, maintain and share databases. It provides an example of a university database with files for students, courses, grades and prerequisites. It outlines key characteristics of the database approach such as self-describing nature, insulation between programs and data, support of multiple views, and sharing of data.
The document discusses database management systems (DBMS). It defines key concepts like a database, DBMS, data models, and database users. It describes typical DBMS functionality including defining and constructing a database, data manipulation and querying, and concurrent access. Examples of a university database are provided. The advantages of the DBMS approach are controlling redundancy, restricting unauthorized access, providing persistent storage and efficient query processing. Database models, schemas and instances are introduced.
A database management system (DBMS) stores and manages data to allow for efficient retrieval, manipulation, and information production. It uses real-world entities and relationships to design its architecture in a normalized format to reduce redundancy. A DBMS provides features like querying languages, multi-user access, security, and multiple views. It has various types of users including administrators who maintain the system, designers who design the database structure, and end users who access applications to complete tasks. A DBMS represents data entities as tables with attributes, keys for identification, and relationships between tables.
The document provides an introduction to basic concepts of database systems including definitions of data, information, and knowledge. It discusses data/information processing and what a database and DBMS are. The main characteristics of the database approach are described including self-describing nature, insulation between programs and data, data abstraction, and support of multiple views. The document also discusses database users including actors on the scene like DBAs and end users, and workers behind the scene like DBMS designers. Finally, it briefly introduces some common data models like hierarchical, network, entity-relationship, relational, and object-oriented models.
Unit 1: Introduction to DBMS Unit 1 CompleteRaj vardhan
This document discusses database management systems (DBMS) and their advantages over traditional file-based data storage. It describes the key components of a DBMS, including the hardware, software, data, procedures, and users. It also explains the three levels of abstraction in a DBMS - the physical level, logical level, and view level - and how they provide data independence. Finally, it provides an overview of different data models like hierarchical, network, and relational models.
What is Data ?
What is Information?
Data Models, Schema and Instances
Components of Database System
What is DBMS ?
Database Languages
Applications of DBMS
Introduction to Databases
Fundamentals of Data Modeling and Database Design
Database Normalization
Types of keys in database management system
Distributed Database
This document discusses database management systems (DBMS) and their components. It describes DBMS as a set of programs that allow for the storage and retrieval of data. It then discusses the key components of a DBMS including the physical, logical, and view levels of abstraction, data models, data independence, data definition and manipulation languages like SQL, and the roles of database administrators and users. The document provides an overview of the architecture and design of database systems.
The document discusses database essentials including database management systems, database applications, the purpose of database systems, data models, database languages, database architecture, and the relational data model. Specifically, it defines what a DBMS is, provides examples of common database applications, describes why databases were developed to address limitations of file processing systems, outlines several data models including the relational model, discusses database languages for defining and manipulating data, presents the client-server architecture of database systems, and explains key concepts of the relational model including tables, tuples, attributes, relations, and domains.
The document provides an overview of database management systems (DBMS). It defines DBMS as software that creates, organizes, and manages databases. It discusses key DBMS concepts like data models, schemas, instances, and database languages. Components of a database system including users, software, hardware, and data are described. Popular DBMS examples like Oracle, SQL Server, and MS Access are listed along with common applications of DBMS in various industries.
CP 121_2.pptx about time to be implementflyinimohamed
The document discusses database concepts and architecture. It covers the three levels of data abstraction - physical, logical, and external levels. It also describes the three schema architecture, including the physical, conceptual, and external schemas. This architecture provides data independence and allows mappings between the different levels. The document also discusses different types of database systems such as single-user, multi-user, centralized, distributed, parallel, and client/server databases.
The document provides an introduction to database management systems and their components. It discusses that a database is a collection of related data representing some aspect of the real world. A database management system (DBMS) allows users to define, construct, manipulate and share databases. The key functions of a DBMS include data definition, data storage, data manipulation such as querying and updating, and sharing data among multiple users. The document also provides examples of database systems and their typical components such as utilities, tools, and centralized and client/server architectures.
1. The document discusses the components and overall structure of a database management system (DBMS). It describes the various levels of database architecture including the physical, logical, and external levels.
2. The key components of a DBMS include users, a query processor, storage manager, and data structures. The query processor consists of a DML compiler, DDL interpreter, and query evaluation engine. The storage manager includes modules for authorization, transactions, file management, and buffering.
3. Data models help represent the design of a database and describe entities, attributes, relationships, and constraints. Common models include the entity-relationship model and object-oriented model.
The document discusses different types of users that interact with a database management system (DBMS). It identifies end users, application programmers, system analysts, database administrators, and sophisticated users. It then describes key characteristics of the database approach including managing information, easy implementation of operations, multiple views of the database, representing real world applications, self-describing nature, logical relationships between records and data, and separation between programs and data.
The document provides an introduction to database management systems (DBMS). It defines a database as a collection of interrelated data organized for efficient retrieval, insertion and deletion. A DBMS is software that allows users to define, create, maintain and control access to the database. It also discusses the benefits of using a DBMS compared to file systems such as reduced redundancy, improved consistency and security. The key components of a DBMS architecture are also summarized such as the query processor, data dictionary, storage manager and query evaluation engine.
System software runs when the system is turned on to provide a platform for application software to run. It is written in low-level assembly language and is general purpose. Application software performs specific tasks for users and is written in high-level languages like C++ and Java. It only runs when requested by users and is user-specific. The key difference between system and application software is that system software provides the underlying platform while application software performs specific tasks.
Similar to IMPORTANT QUESTIONS OF Data Base Management System MGU (20)
Information and Communication Technology in EducationMJDuyan
(𝐓𝐋𝐄 𝟏𝟎𝟎) (𝐋𝐞𝐬𝐬𝐨𝐧 2)-𝐏𝐫𝐞𝐥𝐢𝐦𝐬
𝐄𝐱𝐩𝐥𝐚𝐢𝐧 𝐭𝐡𝐞 𝐈𝐂𝐓 𝐢𝐧 𝐞𝐝𝐮𝐜𝐚𝐭𝐢𝐨𝐧:
Students will be able to explain the role and impact of Information and Communication Technology (ICT) in education. They will understand how ICT tools, such as computers, the internet, and educational software, enhance learning and teaching processes. By exploring various ICT applications, students will recognize how these technologies facilitate access to information, improve communication, support collaboration, and enable personalized learning experiences.
𝐃𝐢𝐬𝐜𝐮𝐬𝐬 𝐭𝐡𝐞 𝐫𝐞𝐥𝐢𝐚𝐛𝐥𝐞 𝐬𝐨𝐮𝐫𝐜𝐞𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐧𝐞𝐭:
-Students will be able to discuss what constitutes reliable sources on the internet. They will learn to identify key characteristics of trustworthy information, such as credibility, accuracy, and authority. By examining different types of online sources, students will develop skills to evaluate the reliability of websites and content, ensuring they can distinguish between reputable information and misinformation.
Brand Guideline of Bashundhara A4 Paper - 2024khabri85
It outlines the basic identity elements such as symbol, logotype, colors, and typefaces. It provides examples of applying the identity to materials like letterhead, business cards, reports, folders, and websites.
Environmental science 1.What is environmental science and components of envir...Deepika
Environmental science for Degree ,Engineering and pharmacy background.you can learn about multidisciplinary of nature and Natural resources with notes, examples and studies.
1.What is environmental science and components of environmental science
2. Explain about multidisciplinary of nature.
3. Explain about natural resources and its types
(𝐓𝐋𝐄 𝟏𝟎𝟎) (𝐋𝐞𝐬𝐬𝐨𝐧 3)-𝐏𝐫𝐞𝐥𝐢𝐦𝐬
Lesson Outcomes:
- students will be able to identify and name various types of ornamental plants commonly used in landscaping and decoration, classifying them based on their characteristics such as foliage, flowering, and growth habits. They will understand the ecological, aesthetic, and economic benefits of ornamental plants, including their roles in improving air quality, providing habitats for wildlife, and enhancing the visual appeal of environments. Additionally, students will demonstrate knowledge of the basic requirements for growing ornamental plants, ensuring they can effectively cultivate and maintain these plants in various settings.
Post init hook in the odoo 17 ERP ModuleCeline George
In Odoo, hooks are functions that are presented as a string in the __init__ file of a module. They are the functions that can execute before and after the existing code.
3. What is data, database, dbms ?
www.edulearninghub.com
4. Data is everything that is not program code.
A database is a collection of information that is
organized so that it can easily be accessed, managed, and
updated. In one view, databases can be classified
according to types of content:
That is a structured set of data held in a computer,
especially one that is accessible in various ways.
www.edulearninghub.com
5. The database management system (DBMS), is a computer
software program that is designed as the means of
managing all databases that are currently installed on a
system hard drive or network.
Different types of database management systems exist
www.edulearninghub.com
7. What is meta-data ?
The database definition is also stored in the
database in the form of database catalog or
dictionary , it is called meta-data.
The DBMS software such as Oracle, My SQL, SQL
Server, MS Access are used to manipulate the
data stored.
www.edulearninghub.com
8. What are the functionality or characteristics of
DBMS?
www.edulearninghub.com
9. Slide 1-9
Typical Functionality of DBMS
• Concurrent Processing and Sharing by a set of users
and programs – yet, keeping all data valid and
consistent
www.edulearninghub.com
10. Slide 1-10
Main Characteristics of the Database Approach
• 1) Self-describing nature of a database system:
A DBMS catalog stores the description of the
database. The description is called meta-data). This
allows the DBMS software to work with different
databases.
• 2) Insulation between programs and data: Called
program-data independence. Allows changing data
storage structures and operations without having to
change the DBMS access programs.
www.edulearninghub.com
11. Slide 1-11
• 3) Data Abstraction: A data model is used to hide
storage details and present the users with a
conceptual view of the database.
• 4) Support of multiple views of the data: Each
user may see a different view of the database,
which describes only the data of interest to that
user.
www.edulearninghub.com
12. • 5) Sharing of data and multiuser transaction
processing :
Allowing a set of concurrent users to retrieve and to
update the database.
Concurrency control within the DBMS guarantees that
each transaction is correctly executed or completely
aborted
. OLTP (Online Transaction Processing) is a major part of
database applications.
www.edulearninghub.com
15. Slide 1-15
Actors on the scene
– Database administrators: responsible for
authorizing access to the database, for co-
ordinating and monitoring its use, acquiring
software, and hardware resources, controlling its
use and monitoring efficiency of operations.
– Database Designers: responsible to define the
content, the structure, the constraints, and
functions or transactions against the database.
They must communicate with the end-users and
understand their needs.
– End-users: they are the peoples whose jobs require
access to the database for querying, updating, and
generating reports ; the database primarily exists
for their use
www.edulearninghub.com
16. Slide 1-16
Categories of End-users
• Casual : occasionally access the database, but they
may need different information each time.
• They use query language to satisfy their needs.
www.edulearninghub.com
17. • Naive or Parametric : they make up a large section
of the end-user population. They use previously
well-defined functions against the database.
• They are constantly querying and updating the
database, using standard type of queries and
updates called canned transactions- that have
been carefully programmed and tested.
• Examples are bank-tellers or reservation clerks
who do this activity for an entire shift of
operations.
www.edulearninghub.com
18. Slide 1-18
Categories of End-users
• Sophisticated : these include business analysts,
scientists, engineers, others thoroughly familiar with
the system capabilities.
• Many use tools in the form of software packages that
work closely with the stored database.
• Stand-alone : mostly maintain personal databases
using ready-to-use packaged applications
www.edulearninghub.com
19. System Analysist and Application Programmers
( Software Engineers)
• System Analysts determine the requirement of end
users.
• Application programmers implements these
specification as programs; then they test, debug,
document, and maintain.
• Such analysis or application programmes are
commonly called software engineers.
• They use the DBMS to accomplish their task.
www.edulearninghub.com
20. Slide 1-20
Advantages of Using the Database
Approach
1. Controlling redundancy
2. Restricting unauthorized access to data.
3. Providing persistent storage for program Objects
4. Providing Storage Structures for efficient Query
Processing
5. Providing backup and recovery services.
6. Providing multiple user interface
7. Representing complex relationships among data.
8. Enforcing integrity constraints on the database.
9. Availability to up-to-date information.
10. Reduces application development time
www.edulearninghub.com
21. Differentiate data model, schema, instance
Data Model:
A set of concepts to describe the structure (types, relationships,
constraints) of a database, and certain constraints that the database
should obey.
Schema:
The description of a database. Includes descriptions of the database
structure and the constraints that should hold on the database.
Database Instance:
The actual data stored in a database at a particular moment in time.
Also called database state (or occurrence).
www.edulearninghub.com
22. Write a note about Entity, Attribute,
Relationship
• Entity : An entity represents a real-world object or
concept such as an employee or student that is described
in the database
Example: student
• Attribute: An attributes represents property of an entity
Example: name, age , dob of a student
• Relationship: it is the association among two or more
entities
Example studying relationship between a student and a
class
www.edulearninghub.com
24. Three-Schema Architecture
• Defines DBMS schemas at three levels:
• Internal schema at the internal level to describe
physical storage structures and access paths. Typically
uses a physical data model.
• Conceptual schema at the conceptual level to
describe the structure and constraints for the whole
database for a community of users. Uses a conceptual
or an implementation data model.
• External schemas at the external level to describe the
various user views. Usually uses the same data model
as the conceptual level.
www.edulearninghub.com
25. What do you mean by Mapping in DBMS?
Mappings among schema levels are needed to transform
requests and data. Programs refer to an external
schema, and are mapped by the DBMS to the internal
schema for execution.
• The process of transforming the request and the result
between levels are called mapping
www.edulearninghub.com
26. Slide 2-26
What is Data Independence ?
• Data independence can be defined as the
capacity to change schema at one level of db
system without having to change the schema
at the next higher level
• Two types of data independence
1. Logical Data Independence:
2. Physical Data Independence:
www.edulearninghub.com
27. • Logical Data Independence: The capacity to
change the conceptual schema without having
to change the external schemas and their
application programs.
• Physical Data Independence: The capacity to
change the internal schema without having to
change the conceptual schema.
www.edulearninghub.com
29. Write a note about DBMS languages?.
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Examples:
DDL - CREATE, ALTER , RENAME
DML - SELECT , INSERT, DELETE, UPDATE
DCL - GRANT , REVOKE
www.edulearninghub.com
32. Explain different Types of attributes in DBMS
1: ATOMIC ATTRIBUTE
An attribute that cannot be divided into smaller independent attribute is known
as atomic attribute.
Example: age
2: COMPOSITE ATTRIBUTE
An attribute that can be divided into smaller independent attribute is known as
composite attribute.
Example: name
3:SINGLE VALUED ATTRIBUTE
An attribute that has only single value for an entity is known as single valued
attribute.
Example: age
www.edulearninghub.com
33. 4: MULTI VALUED ATTRIBUTE
An attribute that can have multiple values for an entity is known as multi valued
attribute.
Example: phone number
5: STORED ATTRIBUTE
An attribute that cannot be derived from another attribute is known as stored
attribute.
For example, birth date cannot derive from age of student.
6: DERIVED ATTRIBUTE
An attribute that can be derived from another attribute is known as derived
attribute.
For example, age can be derive from date of birth.
www.edulearninghub.com
34. 7: NULL VALUED ATTRIBUTE
An attribute, which has not any value for an entity is known as null valued
attribute.
For example, if age of a person not known
8: KEY ATTRIBUTE
An attribute that has unique value of each entity is known as key attribute.
For example, Email id
www.edulearninghub.com
35. What is ER diagram and draw the symbols .
ER diagrams and Naming Conventions
Entity Relationship diagram is the pictorial representation
of entities ,attributes and relationships
It helps db designers to design the database easily
www.edulearninghub.com
39. Write a note about Naming Conventions and Design
Guidelines of ER design
When designing a database schema , the choice of names
for entity, attribute and relationship type is not always
straight forward.
The names must reflect the nature of the schema
Try to use singular names for entity
Use entity uppercase letters for entity, and lowercase
letters for attributes
While naming entities, attributes try to avoid use of special
characters, digits except underscore
www.edulearninghub.com
40. Difference between File System and DBMS
File System :
File system is basically a way of arranging the files in a storage
medium like hard disk. File system organizes the files and helps
in retrieval of files when they are required.
DBMS(Database Management System) :
Database Management System is basically a software that
manages the collection of related data. It is used for storing data
and retrieving the data effectively when it is needed.
www.edulearninghub.com
43. Categories of Database model
A database model is a type of data model that determines
the logical structure of a database and fundamentally
determines in which manner data can be stored, organized
and manipulated.
• Hierarchical database model.
• Relational model.
• Network model.
• Object-oriented database model.
• Entity-relationship model.
• Document model.
• Entity-attribute-value model.
• Star schema.
www.edulearninghub.com
44. What is Domain of an Attribute
• The set of all possible vales of an attribute is called domain set
of an attribute
• Example: age of a person
domain contains only numbers from 1, 2,…….up to
maximum age limit
What is Key Attribute
• An attribute whose value is used to uniquely identify an entity
from an entity set
www.edulearninghub.com
46. Primary Key
• It is the value that is uniquely identify each records in the
table
• Example: roll_number, emp_id, reg_number
Foreign Key
• A foreign key is generally a primary key from one table
that appears as a field in another table
• It is used to point primary key in another table
• Example: detp_id may appear in the employee table as
well as in the department table
www.edulearninghub.com
47. Super Key
• A Super key is any combination of fields within a table
that uniquely identifies each record within that table.
Example:
• Employee (emp_id, name, job, detp_id)
Super Keys are
1. Emp_id, name
2. Emp_id, name, job
3. Emp_id, name, job, dept_id
www.edulearninghub.com
48. Candidate Key
• A candidate is a subset of a super key.
• A candidate key is a single field or the least combination
of fields that uniquely identifies each record in the
table.
• The minimal super key is the candidate key
Example:
• Employee (emp_id, name, job, detp_id)
www.edulearninghub.com
49. Alternate key/ secondary keys
• A table may have one or more choices for the primary
key.
• One is selected as the primary key.
• Those not selected are known as secondary keys or
alternative keys.
Example:
• Student( s_name, reg_no, adm_no, class)
• Part of candidate key which is not a primary key
www.edulearninghub.com