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
The last section of your paper should be titled "Author Reflection", and it should reflect why you selected that particular publication and your critique of the publication
XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss th
Your Learning Team has been hired as database consultants for a start-up company that will stream movies over the Internet (similar to Hulu, Netflix, and others). Validate t
Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises and Implement the 2 enterprise relational DBs using either MySQ
Using the Web, identify the chief information officer, chief information security officer, and systems administrator for your school. Which of these individuals represents t
In the following project, you will revise a table that is to be used as a data source in a mail merge. As the business manager for Sports Medicine Clinic, you will send lett
Use the DTS utility to Import the data from the text file into your SQL Server database. Show screen shots of the import steps and provide a screen shot of the table rows in
Create a matrix report showing territory sales totals by year and quarter. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (3