Access over 20 million homework & study documents

Database Management Questions

Content type
User Generated
Subject
Computer Science
Type
Homework
Rating
Showing Page:
1/5
Database Management System Questions
Name of Student
Name of Institution
Course
Date of Submission

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
Database Management Questions
Chapter 6:
1. Name and describe the three major capabilities of DBMS
a) Data Definition primarily specifies the structure or model of the content of the database. It is
used in creating tables and defining the features of the fields in each table.
b) Data Dictionary refers to an automated or manual file whose main aim or purpose is to store
definitions of data elements and their features or characteristics.
c) Data Manipulation Language is used to access and manipulate information in databases
through the use of SQL (Sequential Query Language) which retrieves, add, changes, and deletes
the data in the database.
2. List and describe the components of a contemporary business intelligence
infrastructure
a) Data Warehouses and Data Marts. A data warehouse refers to a database whose purpose is to
store historical and current data of potential interest so as to aid in the decision-making process
for an organization. Conversely, a data mart is a subset of a data warehouse where it essentially
focuses on the particular part of the organization’s data. Well, a data warehouse makes stored
data available to anyone or everyone; however, it cannot be altered.
b) Hadoop refers to open source software which handles structured, unstructured and semi-
structured data which enables or enhances distributed parallel processing of huge amounts of
data.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
Database Management System Questions Name of Student Name of Institution Course Date of Submission Database Management Questions Chapter 6: 1. Name and describe the three major capabilities of DBMS a) Data Definition primarily specifies the structure or model of the content of the database. It is used in creating tables and defining the features of the fields in each table. b) Data Dictionary refers to an automated or manual file whose main aim or purpose is to store definitions of data elements and their features or characteristics. c) Data Manipulation Language is used to access and manipulate information in databases through the use of SQL (Sequential Query Language) which retrieves, add , changes, and deletes the data in the database. 2. List and describe the components of a contemporary business intelligence infrastructure a) Data Warehouses and Data Marts. A data warehouse refers to a database whose purpose is to store historical and current data of potential interest so as to aid in the decision-making process for an organization. Conversely, a data mart is a subset of a data warehouse where it essentially focuses on the particular part of the organization’s data. Well, a data warehouse makes stored data available to anyone or everyone; however, it cannot be altered. b) Hadoop refers to open source software which handles structured, unstructured and semistructured data which enables or enhances distributed parallel processing of huge amounts of data. c) In-me ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents