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

Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
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
Let us assume that a program takes 400 seconds of elapsed time to execute. Out of these 400 seconds, 320 seconds is the CPU time and the rest is I/O time. What percentage of
What are the ten functions of a DBMS? Define the term "referential integrity constraint" and give an example. What is the difference between a database, a DBMS, and a database
A patron can reserve a book or journal that has been lent out or is in the process of purchase. The reservation should be canceled when the patron checks out the book or jou
Use mysql community server and workbench to create a relation database that maintains users in the internet social media by following a standard process: schema -> tables ->
Develop an understanding of strengths and limitations of various data storage, retrieval methods and models. The assessment requires students to conduct a survey and report
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 are tasked to design Windows 2008 servers to host a database and the company's Web application that will be used heavily by 1,000 employees. The goals are to minimize th
Create this form to search for the title of a video. Create the necessary Video table (with about 5 or 6 records in the interest of time) with the fields shown. Use any imag