Database Management Systems Concepts

Play an AI-generated podcast conversation about this lesson

set of computer programs use in DBMS

creation, maintenance, use of db (correct)
controls organization, storage, management, & retrieval of data in db
creation, storage, control, maintainance,

combines two tables with common column which is primary key.

left outer join
cross join
inner join (correct)

divided into logical units called table composed of rows and columns of data

Attribute
Relational Database (correct)
Domain

bridge bet machine components and human components

Data (D) Signup and view all the answers

returns all the rows of table on the right side of join and matching rows for the table on the left side of join.

RIGHT JOIN (B) Signup and view all the answers

attribute or field serves as unique identifier for particular record within a relation.

PRIMARY KEY (B) Signup and view all the answers

Other term for row in Relational Database

record (C) Signup and view all the answers

contain particular characteristic of real-world entity being describes by row in Relational database

column (A) Signup and view all the answers

set of valid atomic values for given attribute

Domain (A) Signup and view all the answers

SQL can't do

control operation (C) Signup and view all the answers

high-level conceptual data modeling approach to db

ERM (D) Signup and view all the answers

support the basic data manipulation

DML (B) Signup and view all the answers

column cant have a NULL

NOT NULL (C) Signup and view all the answers

creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN

FULL JOIN (B) Signup and view all the answers

to specify multiple values in a WHERE clause

IN (A) Signup and view all the answers

returns all possible combinations of rows from two tables. called a cross product.

CROSS JOIN (C) Signup and view all the answers

to select data from a database

SELECT (D) Signup and view all the answers

describe and name the entities, attributes, and relationships required

DDL (D) Signup and view all the answers

Facilities DBMS doesn't provide

Users manipulate data through DDL (A) Signup and view all the answers

people whose tasks require access to the db

End User (C) Signup and view all the answers

db involves specifying data types, structures, and constraints of data to be stored in the db.

Defining (C) Signup and view all the answers

controls organization, storage, management, & retrieval of data in db

set of software programs (B) Signup and view all the answers

db includes functions; querying the db to retrieve specific data.

manipulating (A) Signup and view all the answers

returns all the rows of the table on left side and matching rows for table on the right side of join. rows no matching row on right, will contain null

LEFT JOIN (D) Signup and view all the answers

Ensures that all values in a column satisfies a specific condition

CHECK (A) Signup and view all the answers

returns the smallest value of the selected column

MIN() (D) Signup and view all the answers

displays a record if either is true

OR (C) Signup and view all the answers

used in a WHERE to search for a specified pattern in a column.

LIKE (B) Signup and view all the answers

to substitute for any other character(s) in a string

Wildcard character (C) Signup and view all the answers

SQL Command: extracts data from a database

SELECT (D) Signup and view all the answers

SQL means

Structured Query Language (C) Signup and view all the answers

over-all design of a db

Schema (B) Signup and view all the answers

support the basic data manipulation

data manipulation language (C) Signup and view all the answers

deletes a table

DROP TABLE (B) Signup and view all the answers

interface layer bet. users and physical db.

Software (D) Signup and view all the answers

collection of logically related data

Database (B) Signup and view all the answers

instruction and rules govern the design and use of db

Procedures (D) Signup and view all the answers

SQL Command: deletes data from a database

DELETE (C) Signup and view all the answers

who publish ERM

Peter Chen (B) Signup and view all the answers

SQL Commands: inserts new data into a database Choices

INSERT INTO (C) Signup and view all the answers

Sets a default value for a column when no value is specified

DEFAULT (C) Signup and view all the answers

returns the total sum of a numeric column

SUM() (A) Signup and view all the answers

returns the largest value of the selected column.

MAX() (D) Signup and view all the answers

to filter records

WHERE (C) Signup and view all the answers

to return only distinct (different) values

DISTINCT (C) Signup and view all the answers

Uniquely identifies a row/record in another table

FOREIGN KEY (B) Signup and view all the answers

collection of data from multiple tables. combines two or more tables to retrieve data from multiple tables.

JOIN (C) Signup and view all the answers

automated system enables users define, create, maintain and control access db

Database System (B) Signup and view all the answers

Database

A collection of logically related data.

Database System

A system used to define, create, maintain, control access to a database.

DBMS - Database Management System

A set of software programs that controls the organization, storage, management & retrieval of data in a database.