Describe the components of a dbms
Course:- Database Management System
Reference No.:- EM13760293

Assignment Help >> Database Management System

Questions: 1. What is a DBMS? Briefly describe the components of a DBMS.

2. Describe a primary key, candidate key, secondary key, foreign key, and a combination key. Use your imagination to provide an example of each key that is not in the textbook.

3. What are entity-relationship diagrams and how are they used? What symbol is used for a relationship? What is an associative entity? Provide an example.


Verified Expert

Preview Container content

? Database Management System(DBMS) is a collection of interrelated data (database) and set of programs to access and modify those data.
? DBMS has several components. Each component has some specific task to perform. The Major components DBMS are as follows,

• Hardware
Without hardware it is not possible to implement DBMS. The main hardware is the computer used for storing and accessing the data in database. Other hardware components used in DBMS are Storage devices, I/O devices, and electromechanical devices which makes interface between user and the database.

• Software
This is main component of the DBMS. Software is the set of programs to access and control the data in the database. DBMS itself is the main software to manage overall database system. Application programs written in different programming language are used to access and modify the data in the database by the users.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
Course: data mining. Require a 7 page essay on subjects: Warehouse Architectures: the paper requires to contain information about centralized, federated, and tiered data wareh
You have been asked to design database design for BoingX Aircraft Company (BAC), that has two products: TRX-5A and TRX-5B HUD (heads-up display) units.
Its a lead a project that will implement a new learning management system for your university. You have two key tasks: Task 1: Investigate learning management software package
In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments 2. Build the table using direct sourcing from the appropriate ta
Demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of info
The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Examine the
What errors prevent the table displayed above from being first normal form compliant? Bring the table(s) into first normal form compliance without loss of any data. Identify
Consider the ER diagram that you designed for the Prescriptions-R-X chain of pharmacies in Exercise 2.7. De?ne relations corresponding to the entity sets and relationship sets