logo

DBMS Principles and Applications

8 Pages1379 Words60 Views
   

Added on  2020-12-10

About This Document

Data stored in a relational DBMS by applying SQL to create database tables, extract, present and modify data, and implement integrity that reflect business logic 5 4) Apply principles of normalisation and functional dependencies 7 5) Explain concept of transaction management, query processing, physical storage and database indexing 7 6) Explain societal issues around information privacy 7 REFERENCES 8 2 3 1) Components of DBMS and data modelling approaches In the business scenario, It can be used the relational modelling approach that help for creating and designing a

DBMS Principles and Applications

   Added on 2020-12-10

ShareRelated Documents
DBMS
DBMS Principles and Applications_1
Table of Contents1) Components of DBMS and data modelling approaches.........................................................32) Explain principles of relational DBMS...................................................................................33. Data stored in a relational DBMS by applying SQL to create database tables, extract,present and modify data, and implement integrity that reflect business logic.............................54) Apply principles of normalisation and functional dependencies............................................75) Explain concept of transaction management, query processing, physical storage anddatabase indexing.........................................................................................................................76) Explain societal issues around information privacy................................................................7REFERENCES................................................................................................................................8
DBMS Principles and Applications_2
1) Components of DBMS and data modelling approachesIn the business scenario, It can be used the relational modelling approach that help forcreating and designing a dynamic database system in appropriate manner. There are different components of database which is described as below :- Software- they are set of programs that help in managing and controlling of database. Itincludes operating system, data applications, etc. (Components of database, 2016).Hardware- They are physical devices which act as interface between user andcomputers. It contains CPU, server, I/O devices, etc. Data- It is the raw data that is processed, stored, collected, etc. in a database. Procedure – They are instruction and guidelines that how to use, manage and operatedatabase.Data manager- It helps in managing of data in database and providing recovery of datain case of failure of system (Mahajan & et.al., 2018). Data dictionary – It contains information about database itself. It ensures that data flowsthrough defined process. 2) Explain principles of relational DBMSIn RDBMS, usually Codd’s principles are followed that are as follows :- Information is represented in table form with primary key, columns, etc. The database schema can be changed by end user without recreating it.Any single operation should be able to update, delete, retrieve, etc.The metadata must be stored as regular data.The row processing done must follow same rules as in set processing operations.
DBMS Principles and Applications_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Components of DBMS - Doc
|6
|730
|205

ER Diagram and Normalization for Hotel Booking Management System
|9
|833
|461

Entity Relationship Diagram in Library Management System
|25
|2195
|76

Introduction To Database
|21
|808
|193

Database Management System : Doc
|22
|1217
|96

Database and Analytics (Database and Analytics) for the Auto Sale's
|33
|5085
|217