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
Find the aids of all aircraft that can be used on routes from Los Angeles to Chicago. Identify the routes that can be piloted by every pilot who makes more than $100,000.
You will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example,
Write a PROLOG program that implements a family database for your family. Save it as an ordinary text file named family.pro. Your program should implement the following fact
Compare activity (quite theoretical) of the disk (in number of bytes) required for each of both relational. Write down the advantages and inconveniences of new relational sche
In cell G13, insert a formula that adds taxes and fees to the base cost of the trip (in cell F13) by using the percentage value in the input area. Use a mixed reference to t
Why is it preferable to use a numeric-based attribute as the key attribute?- Why is it important that you identify all of the important relationships when developing an entit
Suppose H(m) is a collision-resistant hash function that maps a message of arbitrary bit length into an n-big hash value. Is it true that, for all messages x, x1 with x=x1,
How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples fr