Database Management Systems Concepts

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

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

<p>Data (D)</p> 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.

<p>RIGHT JOIN (B)</p> Signup and view all the answers

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

<p>PRIMARY KEY (B)</p> Signup and view all the answers

Other term for row in Relational Database

<p>record (C)</p> Signup and view all the answers

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

<p>column (A)</p> Signup and view all the answers

set of valid atomic values for given attribute

<p>Domain (A)</p> Signup and view all the answers

SQL can't do

<p>control operation (C)</p> Signup and view all the answers

high-level conceptual data modeling approach to db

<p>ERM (D)</p> Signup and view all the answers

support the basic data manipulation

<p>DML (B)</p> Signup and view all the answers

column cant have a NULL

<p>NOT NULL (C)</p> Signup and view all the answers

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

<p>FULL JOIN (B)</p> Signup and view all the answers

to specify multiple values in a WHERE clause

<p>IN (A)</p> Signup and view all the answers

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

<p>CROSS JOIN (C)</p> Signup and view all the answers

to select data from a database

<p>SELECT (D)</p> Signup and view all the answers

describe and name the entities, attributes, and relationships required

<p>DDL (D)</p> Signup and view all the answers

Facilities DBMS doesn't provide

<p>Users manipulate data through DDL (A)</p> Signup and view all the answers

people whose tasks require access to the db

<p>End User (C)</p> Signup and view all the answers

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

<p>Defining (C)</p> Signup and view all the answers

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

<p>set of software programs (B)</p> Signup and view all the answers

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

<p>manipulating (A)</p> 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

<p>LEFT JOIN (D)</p> Signup and view all the answers

Ensures that all values in a column satisfies a specific condition

<p>CHECK (A)</p> Signup and view all the answers

returns the smallest value of the selected column

<p>MIN() (D)</p> Signup and view all the answers

displays a record if either is true

<p>OR (C)</p> Signup and view all the answers

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

<p>LIKE (B)</p> Signup and view all the answers

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

<p>Wildcard character (C)</p> Signup and view all the answers

SQL Command: extracts data from a database

<p>SELECT (D)</p> Signup and view all the answers

SQL means

<p>Structured Query Language (C)</p> Signup and view all the answers

over-all design of a db

<p>Schema (B)</p> Signup and view all the answers

support the basic data manipulation

<p>data manipulation language (C)</p> Signup and view all the answers

deletes a table

<p>DROP TABLE (B)</p> Signup and view all the answers

interface layer bet. users and physical db.

<p>Software (D)</p> Signup and view all the answers

collection of logically related data

<p>Database (B)</p> Signup and view all the answers

instruction and rules govern the design and use of db

<p>Procedures (D)</p> Signup and view all the answers

SQL Command: deletes data from a database

<p>DELETE (C)</p> Signup and view all the answers

who publish ERM

<p>Peter Chen (B)</p> Signup and view all the answers

SQL Commands: inserts new data into a database Choices

<p>INSERT INTO (C)</p> Signup and view all the answers

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

<p>DEFAULT (C)</p> Signup and view all the answers

returns the total sum of a numeric column

<p>SUM() (A)</p> Signup and view all the answers

returns the largest value of the selected column.

<p>MAX() (D)</p> Signup and view all the answers

to filter records

<p>WHERE (C)</p> Signup and view all the answers

to return only distinct (different) values

<p>DISTINCT (C)</p> Signup and view all the answers

Uniquely identifies a row/record in another table

<p>FOREIGN KEY (B)</p> Signup and view all the answers

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

<p>JOIN (C)</p> Signup and view all the answers

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

<p>Database System (B)</p> Signup and view all the answers

Flashcards

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.

ERM - Entity-Relationship Model

A high-level conceptual data modeling approach to databases.

Signup and view all the flashcards

JOIN

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

Signup and view all the flashcards

Database System

An automated system that enables users to define, create, maintain, and control access to a database.

Signup and view all the flashcards

Relational Database

A database that is divided into logical units called tables. Each table is composed of rows and columns of data.

Signup and view all the flashcards

PRIMARY KEY

An attribute or field that serves as a unique identifier for a particular record (row) within a relation (table).

Signup and view all the flashcards

FOREIGN KEY

An attribute that uniquely identifies a row/record in another table.

Signup and view all the flashcards

Record

Another term for a row in a relational database.

Signup and view all the flashcards

Column

A column in a relational database which contains a particular characteristic of the real-world entity being described by the row.

Signup and view all the flashcards

Domain

A set of valid atomic values for a given attribute.

Signup and view all the flashcards

DBMS Software

A set of computer programs used in a database management system (DBMS).

Signup and view all the flashcards

Data

A bridge between the machine components and the human components.

Signup and view all the flashcards

DDL - Data Definition Language

Describes and names the entities, attributes, and relationships required.

Signup and view all the flashcards

DML - Data Manipulation Language

Supports the basic data manipulation.

Signup and view all the flashcards

SQL

SQL stands for:

Signup and view all the flashcards

Schema

The overall design of a database.

Signup and view all the flashcards

SELECT

Extracts data from a database.

Signup and view all the flashcards

INSERT

Inserts new data into a database.

Signup and view all the flashcards

DELETE

Deletes data from a database.

Signup and view all the flashcards

FULL JOIN

Creates the result-set by combining the results of both LEFT JOIN and RIGHT JOIN.

Signup and view all the flashcards

LEFT JOIN

Returns all the rows of the table on the left side and matching rows for the table on the right side of the join. Rows with no matching rows on the right will contain null.

Signup and view all the flashcards

RIGHT JOIN

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

Signup and view all the flashcards

INNER JOIN

Combines two tables with a common column, which is the primary key.

Signup and view all the flashcards

CROSS JOIN

Returns all possible combinations of rows from two tables. This is called a cross product.

Signup and view all the flashcards

IN

To specify multiple values in a WHERE clause.

Signup and view all the flashcards

Wildcard Character - %

A wildcard character.

Signup and view all the flashcards

LIKE

To filter records based on a specified pattern within a column.

Signup and view all the flashcards

LIKE Operator

Used in a WHERE clause to search for a specified pattern in a column.

Signup and view all the flashcards

NOT NULL

Column can't have a NULL value.

Signup and view all the flashcards

CHECK

Ensures that all values in a column satisfy a specific condition.

Signup and view all the flashcards

DISTINCT

To return only distinct (different) values.

Signup and view all the flashcards

End User

People whose tasks require access to the database.

Signup and view all the flashcards

Users manipulate data through DDL

A data manipulation facility that DBMS doesn't provide.

Signup and view all the flashcards

Procedures

Instructions and rules that govern the design and use of the database.

Signup and view all the flashcards

Manipulating

A database includes functions; querying the database to retrieve specific data.

Signup and view all the flashcards

Defining

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

Signup and view all the flashcards

More Like This

Use Quizgecko on...
Open
Browser
Browser