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
Narrative description of the "medical practice" database assignment: Design a database for a small medical practice with several physicians. The purpose of the database is t
What is it about a 200 MB video or audio file which makes it so much more of database management challenge than relational database the same size?
You must design the network requirements for the XYZ company. As the network consultant you will be required to develop a plan for the company network, including all costs.
What is "Dimensional Modeling"? What are the "fact tables" and dimensional table: in relation to the dimensional modeling? Explain "star schema" and "extended star schema".
You need to develop new user named ASSOCDBA1 and new ROLE named JRDBA1 which can be used for assistant DBA. You wish the new role to contain DBA role that the SYSTEM user ha
Kitchen Gadgets sells a line of high-quality kitchen utensils and gadgets. When customers place orders on the company's Web site or through electronic data interchange (EDI)
To create a collection called "msgs" under dbs named "IASP565DB". You need to create a schema that can accommodate the following information. As you know, when you in the ch
Discuss k-nearest Neighbor (KNN) learning algorithm. What is the significance of the value of k in k-NN. Discuss the two estimation methods of classification-type data mining