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