15 Sep 2022

161

Relational Database Management System

Format: APA

Academic level: College

Paper type: Essay (Any Type)

Words: 364

Pages: 1

Downloads: 0

General Structure 

In the Relational Database Management System (RDMS), data is stored through the use of rows and columns. These rows and columns form a table – every value in the table is related. Tables are, at times, also related to one another – which makes it easy to run a query across many tables at once.

Leading Commercial Relational Database Vendors 

Gartner one of the leading Information Technology analyst firms reports that Oracle was the leading commercial RDMS vendor in 2011, with a global market share of 48.8% (as cited in Mullins, 2011). This is more than all the next five on the list combined. IBM came in second with a market share of 20.2%, and Microsoft a distant third with a market share of 17.0% (Accion Labs, 2016).

It’s time to jumpstart your paper!

Delegate your assignment to our experts and they will do the rest.

Get custom essay

Microsoft Access 

Microsoft Access is a system used in database management. It incorporates the use of relational type database management into a graphical user interface. It is typically included in the Microsoft Office Suite, though not all MS Office packages include MS Access.

Types of Object that can be Created using MS Access 

There are six types of object that can be created using an MS Access database. Principle among them tables. Tables store data regarding a specific entity. They are comprised of records which are in turn made up of fields. A query offers a unique view of data on one or multiple tables. Forms facilitate a convenient method of data input and display. Reports summarize, calculate, format, and print selected data sets. Macros automate the performance of repetitive tasks. Modules contain custom procedures that have a greater ability to automate specific instances than macros.

Steps Involved in Importing Excel Worksheets into an MS Access DB 

Click on the “External Data” tab. When the Excel button (EXTERNAL DATA tab | Import & Link group) is clicked the Get External Data – Excel Spreadsheet dialog box is displayed. Click the “Browse” button. Navigate to and click the desired Excel file. Once the file is opened, follow the simple instructions on the import wizard and choose where the data should be imported and the name of the new table (where applicable).

Steps in Backing up an MS Access Database 

Open the database. On the “File” dropdown menu, open the backstage view and select “Save As.” With “Save Database As” already selected in the area marked File Types, click ‘Back Up Database’ found in the “Save Database As” region, and then click the Save As button. Select the desired location and filename. Click “Save.”

References

Accion Labs. (2016).  Embracing open source databases . [online] Available at: https://www.accionlabs.com/articles/2018/4/18/embracing-open-source-databases [Accessed 4 Mar. 2019].

Mullins, C. (2011). The database report July 2011 . [online] The Data Administration Newsletter. Available at: http://tdan.com/the-database-report-july-2011/15299 [Accessed 4 Mar. 2019].

Illustration
Cite this page

Select style:

Reference

StudyBounty. (2023, September 15). Relational Database Management System.
https://studybounty.com/relational-database-management-system-essay

illustration

Related essays

We post free essay examples for college on a regular basis. Stay in the know!

Security Implication of the Internet of Things

The Internet of Things (IoT) can be described as s system of interconnected devices that have the ability to transfer information over a computer network without the need of human-to-computer or human-to-human...

Words: 892

Pages: 3

Views: 96

Modern Day Attacks Against Firewalls and VPNs

Introduction The need to have an enhanced security of the computer connectivity happens to be one of the reasons that attract companies and organizations towards wide usage of VPNs. Several simple techniques...

Words: 2025

Pages: 7

Views: 134

How to Deploy and Administer Windows Server 2012

Securing a reliable, and expandable configuration for a company is important to build a strong network. The new and enhanced features of the Windows Server 2012 can be used to implement the network. In this...

Words: 1673

Pages: 6

Views: 87

Deployment Model in Cloud Computing

Deployment model is a representation of a cloud environment primarily distinguished by parameters such as accessibility, proprietorship, and storage size. The National Institute of Standards and Technology gives the...

Words: 254

Pages: 1

Views: 82

How to Use Web Search Engines for Business Research

The advancement of technology has made it possible for many people around the world to have easy access to information whenever they want. The development of the Wide World Web-enabled different kinds of information...

Words: 773

Pages: 3

Views: 86

Distributed Database Management System (DDBMS)

Introduction Data management has been a headache to many technology enthusiasts for quite a long period of time. They have successfully managed to logically collect interrelated data and share it. If the data is...

Words: 799

Pages: 3

Views: 127

illustration

Running out of time?

Entrust your assignment to proficient writers and receive TOP-quality paper before the deadline is over.

Illustration