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
Analyze how the data breach could have been prevented with better adherence to and compliance with regulatory requirements and guidelines, including management controls; inc
Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropri
List the SKU which was purchased the most. List the two SKUs that were purchased most frequently together. List the three SKUs that were purchased most frequently together.
You are going to design a database system for a small university. The database will be used for scheduling classes. The university consists of multiple schools, which ea
You are asked to create a GIS database of information about Vietnam at scale of 1:100,000. Database will include the following: Which of these features are best represented by
Describe some possible interpretations of the data related to the patient fall rate on the telemetry unit and Discuss the quality management process you would follow to improv
Create a 2-3 page (350 words per page) examining the use of databases in organization. Explain what database applications are utilized (Microsoft Access, DB2, Oracle, etc.).
This assignment uses a database with data about a university; the database resides in our Oracle servers. The schema of the database is provided below. Keys are in bold face