Ask a question from expert

Ask now

Components of DBMS - Doc

6 Pages730 Words205 Views
   

Added on  2020-12-09

Components of DBMS - Doc

   Added on 2020-12-09

BookmarkShareRelated Documents
DBMS
Components of DBMS - Doc_1
Table of contentQUESTION 1...........................................................................................................1QUESTION 2...........................................................................................................2QUESTION 3...........................................................................................................2REFERENCES........................................................................................................3
Components of DBMS - Doc_2
QUESTION 1a) Explain difference between logical and physical data independenceLogicalPhysicalIn this conceptual schema can be changedwithout changing its structure.In this conceptual schema can not be changedwithout changing its structure.It only provides protection to applicationprogram.It provides independence and protection toconceptual and external schema.Modification are done to change structure. The modifications are done to improveperformance.b) Describe key components of DBMS and their interactionsSoftware- They are set of programs that help in managing and controlling of database. Itincludes operating system, data applications, etc. Hardware- They are physical devices which act as interface between user and computers. Itcontains CPU, server, I/O devices, etc. (Cuomo and Moore, 2018)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 operate database.Data manager- It helps in managing of data in database and providing recovery of data in caseof failure of system. Data dictionary – It contains information about database itself. It ensures that data flowsthrough defined process. c) Explain what is domain, attribute, tuple and relation in relational model?Domain – It is set of values which is used to model data. Attribute – The columns in a table represents attribute. Tuple – It is a single row in table that contain single record is called a tuple. Relation – It describe the relation of specific attribute with another in database. d) What solutions can be applied?Yes, there are certain issues in this. So, in order to solve it first of all primary key has toremove from middle name.1
Components of DBMS - Doc_3

End of preview

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

Related Documents
Collection of Logically Related Data - Desklib
|6
|563
|99

Logical Database Design Database Design
|21
|2174
|22

Course Title and Code:.
|5
|645
|1

Assessment | Database Modelling (KC7013)
|18
|2655
|30

DBMS Principles and Applications
|8
|1379
|60

Entity Relationship Diagram for Database INTRODUCTION 3 TASKS
|20
|1532
|227