Podcast
Questions and Answers
set of computer programs use in DBMS
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.
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
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
bridge bet machine components and human components
returns all the rows of table on the right side of join and matching rows for the table on the left side of join.
returns all the rows of table on the right side of join and matching rows for the table on the left side of join.
attribute or field serves as unique identifier for particular record within a relation.
attribute or field serves as unique identifier for particular record within a relation.
Other term for row in Relational Database
Other term for row in Relational Database
contain particular characteristic of real-world entity being describes by row in Relational database
contain particular characteristic of real-world entity being describes by row in Relational database
set of valid atomic values for given attribute
set of valid atomic values for given attribute
SQL can't do
SQL can't do
high-level conceptual data modeling approach to db
high-level conceptual data modeling approach to db
support the basic data manipulation
support the basic data manipulation
column cant have a NULL
column cant have a NULL
creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN
creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN
to specify multiple values in a WHERE clause
to specify multiple values in a WHERE clause
returns all possible combinations of rows from two tables. called a cross product.
returns all possible combinations of rows from two tables. called a cross product.
to select data from a database
to select data from a database
describe and name the entities, attributes, and relationships required
describe and name the entities, attributes, and relationships required
Facilities DBMS doesn't provide
Facilities DBMS doesn't provide
people whose tasks require access to the db
people whose tasks require access to the db
db involves specifying data types, structures, and constraints of data to be stored in the db.
db involves specifying data types, structures, and constraints of data to be stored in the db.
controls organization, storage, management, & retrieval of data in db
controls organization, storage, management, & retrieval of data in db
db includes functions; querying the db to retrieve specific data.
db includes functions; querying the db to retrieve specific data.
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
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
Ensures that all values in a column satisfies a specific condition
Ensures that all values in a column satisfies a specific condition
returns the smallest value of the selected column
returns the smallest value of the selected column
displays a record if either is true
displays a record if either is true
used in a WHERE to search for a specified pattern in a column.
used in a WHERE to search for a specified pattern in a column.
to substitute for any other character(s) in a string
to substitute for any other character(s) in a string
SQL Command: extracts data from a database
SQL Command: extracts data from a database
SQL means
SQL means
over-all design of a db
over-all design of a db
support the basic data manipulation
support the basic data manipulation
deletes a table
deletes a table
interface layer bet. users and physical db.
interface layer bet. users and physical db.
collection of logically related data
collection of logically related data
instruction and rules govern the design and use of db
instruction and rules govern the design and use of db
SQL Command: deletes data from a database
SQL Command: deletes data from a database
who publish ERM
who publish ERM
SQL Commands: inserts new data into a database
Choices
SQL Commands: inserts new data into a database Choices
Sets a default value for a column when no value is specified
Sets a default value for a column when no value is specified
returns the total sum of a numeric column
returns the total sum of a numeric column
returns the largest value of the selected column.
returns the largest value of the selected column.
to filter records
to filter records
to return only distinct (different) values
to return only distinct (different) values
Uniquely identifies a row/record in another table
Uniquely identifies a row/record in another table
collection of data from multiple tables. combines two or more tables to retrieve data from multiple tables.
collection of data from multiple tables. combines two or more tables to retrieve data from multiple tables.
automated system enables users define, create, maintain and control access db
automated system enables users define, create, maintain and control access db
Flashcards
Database
Database
A collection of logically related data.
Database System
Database System
A system used to define, create, maintain, control access to a database.
DBMS - Database Management System
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
ERM - Entity-Relationship Model
Signup and view all the flashcards
JOIN
JOIN
Signup and view all the flashcards
Database System
Database System
Signup and view all the flashcards
Relational Database
Relational Database
Signup and view all the flashcards
PRIMARY KEY
PRIMARY KEY
Signup and view all the flashcards
FOREIGN KEY
FOREIGN KEY
Signup and view all the flashcards
Record
Record
Signup and view all the flashcards
Column
Column
Signup and view all the flashcards
Domain
Domain
Signup and view all the flashcards
DBMS Software
DBMS Software
Signup and view all the flashcards
Data
Data
Signup and view all the flashcards
DDL - Data Definition Language
DDL - Data Definition Language
Signup and view all the flashcards
DML - Data Manipulation Language
DML - Data Manipulation Language
Signup and view all the flashcards
SQL
SQL
Signup and view all the flashcards
Schema
Schema
Signup and view all the flashcards
SELECT
SELECT
Signup and view all the flashcards
INSERT
INSERT
Signup and view all the flashcards
DELETE
DELETE
Signup and view all the flashcards
FULL JOIN
FULL JOIN
Signup and view all the flashcards
LEFT JOIN
LEFT JOIN
Signup and view all the flashcards
RIGHT JOIN
RIGHT JOIN
Signup and view all the flashcards
INNER JOIN
INNER JOIN
Signup and view all the flashcards
CROSS JOIN
CROSS JOIN
Signup and view all the flashcards
IN
IN
Signup and view all the flashcards
Wildcard Character - %
Wildcard Character - %
Signup and view all the flashcards
LIKE
LIKE
Signup and view all the flashcards
LIKE Operator
LIKE Operator
Signup and view all the flashcards
NOT NULL
NOT NULL
Signup and view all the flashcards
CHECK
CHECK
Signup and view all the flashcards
DISTINCT
DISTINCT
Signup and view all the flashcards
End User
End User
Signup and view all the flashcards
Users manipulate data through DDL
Users manipulate data through DDL
Signup and view all the flashcards
Procedures
Procedures
Signup and view all the flashcards
Manipulating
Manipulating
Signup and view all the flashcards
Defining
Defining
Signup and view all the flashcards