Lecture 2: Database Concepts

is responsible for managing the enterprise's databases: security, access control, backup, and disaster recovery

DBA: Database Administrator

Which of the following is NOT considered a database element? a) Table b) Folder c) Field d) Record

b) Folder

A relationship between the STUDENT and COURSES table is an example of a a) One-to-many relationship b) One-to-one relationship c) Many-to-many relationship d) None of the above

c) Many-to-many relationship

A ________ is a collection of related database tables. a) Field b) Primary Key c) Record d) Database

d) Database

The data dictionary in a database management system (DBMS) is a repository of a) Thesaurus b) None of the other answers c) DBMS terms (e.g. DML, DDL) and their corresponding meaning d) Information about the database (i.e. metadata)

d) Information about the database (i.e. metadata)

In database design terminology, a CUSTOMER is a/an a) occurrence b) attribute c) record d) entity

d) entity

The difference between a database management system (DBMS) and a database is a) the DBMS refers to a complete accounting information system and the database refers to a subset of that. b) nothing - these terms are synonyms. c) the DBMS is hardware and the database is software. d) the DBMS is software and the database is data and related files.

d) the DBMS is software and the database is data and related files.

Of the following, select the attribute that would be the best primary key in an inventory table. a) Item supplier b) Item location c) Item cost d) Item name e) Item number

e) Item number

RDBMS

Relational Database Management System

Non-Procedural language designed to define and manipulate relational database

Structured Query Language

What is the full form of SQL? 1) Structured Query Language 2) Standard Query Language 3) Simple Query Language 4) Structured Query List

1) Structured Query Language

How do we deal with Many-to-Many relationships in a relational database?

Must create an intersection table, with a composite key (aka two primary keys put together)

centralize, document, control and coordinate the use of data within an organization

Database Dictionaries

DBMS

Database Managing System

______________________ store data that is analyzed for business intelligence to enhance tactical and strategic decision making. a) Data warehouses b) Database forms c) Data models d) Data networks

a) Data warehouses

Fields associated with other fields in a logical grouping are known as: a) records b) elements c) attributes d) data items

a) records