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
Write a query that returns the number of customers in each job title. Write a query that returns customer name, company, job title, phone, city and state for customers in Minn
To analyse and comprehend a given ER diagram and Database schema.  To implement a database based on the given ER diagram and Database scheme. To write required SQL statements
How did you store the data for this homework? Think about how you store the information helps you to answer the question. How many tables, and which ones, were ?ipp
Determine the data requirements of Birchwood Lane Schools. What data from the scenario is needed for the database and why? To what extent is additional information needed to d
Create a spreadsheet that your instructor could use to calculate final averages and letter grades for this class (INFS 3100). Use the point values from the syllabus for dis
An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein method
At the end of the program, compare the total electricity usage accumulated in the program with the value provided in the header record, and print an appropriate message if t
Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to m