Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

Entity (database Object)

Front

1 / 9

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (9)

Section 1

(9 cards)

Entity (database Object)

Front

the smallest unit that can contain a meaningful set of data (Table Entity, Horizontal Entity, Vertical Entity)

Back

Entity Instance

Front

entity instance is a single occurrence of an entity. Instance means: In a database model, a row where the Primary Key identifies a single instance

Back

CREATE (statement)

Front

Creates an object such as a table or database eg: CREATE sales ( purchase_number INT); This creates a table named sales with purchase_number as its only field(column)

Back

Field

Front

Column containing specific information about every record in the table.

Back

Data Definition Language (DDL)

Front

A syntax A set of statements that allow the user to define or modify data structures and objects such as tables

Back

Record

Front

A row of a table made up of different data values

Back

ALTER (statement)

Front

Used when altering existing objects eg ALTER table sales ADD COLUMN date_of_purchase DATE;

Back

Relational Database

Front

A database with related tables

Back

SQL Syntax

Front

a set of several types of statements that allow you to perform various commands and operations

Back