COMPUTER Flashcards
PASSSSSSSSSSSSSSSSSSSSS
Is a type of database that stores data in separate tables rather than putting all the data in one big storeroom
Relational Database
Is a popular open source relational database management system that is developed, distributed, and supported by MySQLAB
MySQL
MySQL DATA TYPES (3)
String, Numeric, Date and time
fixed length string
char
MySQL SRING DATA TYPES (3)
Char, Varchar, Enum
not fixed length string
varchar
is used when we want to restrict the values to a set of allowed values
ENUM
MySQL NUMERIC DATA TYPE (4)
Integer, Float, Decimal, Boolean
used to store whole numbersor numbers without decimals
Integer
used to store numbers that have a decimal part such as salary and price
FLOAT and DECIMAL
used if the field can have only two possible values: true or false
BOOLEAN
MySQL DATE AND TIME DATATYPES
Date, datetime, timestamp, time, year
YYYY-MM-DD
DATE
HH:MM:SS
Timestamp
YYYY-MM-DD HH:MM:SS
Datetime
RDBMS
Relational Database Management System
an organized collection of logically related data
Database
A data base is composed of ___
tables
each table is composed of ___
records
each record is composed of ___
fields
corresponds to a row in a table
record
each field is composed of ___
characters or bytes
corresponds to a column name in a table
field
contains related records, it has rows and columns
table
corresponds to a cell in a table
field value
DBMS
Database Management System
is a software program that can manage program that is in electronic format
Database Management System