Section 1
Preview this deck
Entity Relationship Diagram (ER) (newer version EER - enhanced entity-relationship diagram)
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (71)
Section 1
(50 cards)
Entity Relationship Diagram (ER) (newer version EER - enhanced entity-relationship diagram)
can be used to show how the tables in a database are defined and related
cell
the intersection of a row and a column
individual systems and LANs can be connected and share data over larger private networks, such as ______________
WAN (wide area network)
columns (fields)
represents some attribute of the entity, such as the amount of an invoice or a vendor's address
The type of operation that retrieves data from two or more tables is called a __________________.
join
web browser
running on a client sends a request tot a web server over the internet. then the web server processes the request and passes any request for data on to the database server
Which of the following types of statements does not modify the data in a table?
SELECT
application software
does the work that the user wants to do. purchased or developed
many-to-many relationship
usually implemented by using an intermediate table that has a one-to-many relationship
Data Manipulation Language (DML)
statement that let your work with the data in a database - used more by MySQL programmers (application programmers use the most)
To relate one table to another, a/an _______________________ in one table is used to point to the primary key in another table.
foreign key
The most common type of relationship between two tables is a/an _______________________ relationship.
one-to-many
A database driver is software that lets the
data access model communicate with the database
in a simple client/server system, the server is typically a high-powered PC that communicates with the clients over a ___________
LAN (local area network)
server
is a computer that has enough processor speed, internal memory (RAM), and disk storage to store the files and databases of the system and provide services to the clients of the system
Which of the following types of SQL statements is not a DML statement?
CREATE TABLE
one-to-many relationship
the tables in a database can be related to other tables by values in specific columns - each row in the Vendors table is related to one or more rows in the invoices table
tables
consists of rows and columns - typically modeled after a real-world entity, such as an invoice or a vendor
business components
these are used to process database requests from the user interface running on the client
the database server is referred to as the
back end
data types
assigned to a column determines the type of information that can be stored in the column
web services
like business components, except that they are designed to run on a web server
A relational database consists of one or more __________________.
tables
application server (web server)
used to store business components that do part of the processing of the application
non-primary keys (unique keys)
uniquely identifies each row in the table
value
what is stored in a cell - stored AT the intersection
network
the cabling, communication lines, network interface cards, hubs, routers, and other components that connect the clients and the servers of the system
data access API (application programming interface)
provides the interface between the application program and the DBMS.
open-source database
any developer can view and improve its source code - runs on all major operating systems and is commonly used for web applications
indexes
provides an efficient way to access data from a table based on the values in specific columns - automatically created for a table's primary and non-primary keys
web application
are designed to run on a web server
the client is typically referred to as the
front end
rows (records)
contains a set of values for a single instance of the entity, such as one invoice or one vendor
null (null value)
represents a value that's unknown, unavailable, or not applicable.
enterprise system
When a system consists of networks, midrange systems, and mainframe systems, often spread throughout the country or world
default value
that value is assigned to the column if another value isn't provided
foreign key
one or more columns in a table that refer to a primary key in another table - identifies a related row in the vendors table
Referential Integrity
when you define a foreign key for a table in MySQL, you can have that foreign key enforce ____________. then, MySQL makes sure that any changes to the data in the database don't create invalid relationships between tables
SQL statements that define the tables in a database are referred to as _____________________ statements.
ddl
composite primary key
if a primary key uses two or more columns
If you define a column with a default value, that value is used whenever a row
that doesn't include a value for that column is added to the table
relational database
consists of tables - eliminated some of the problems that were associated with standard files and other database designs - rude data redundancy, which saves disk storage and leads to efficient data retrieval - you can also view and manipulate data in a way that is both intuitive and efficient
clients
usually the PCs , Macs, or workstations of the system that are already available on the desktops throughout a company - can also be mobile devices like laptops, tablets, and smartphones
DBMS (Database Management System)
store and manage the databases of the client/server system (MySQL)
The processing that's done by the DBMS is typically referred to as
back-end processing
one-to-one relationship
the data in the two tables could be stored in a single table
The result of a SELECT statement is
a result set
auto increment column
A numeric column whose value is generated automatically when a row is added to the table.
the processing that's done by the client software is typically referred to as
front-end processing
primary key
uniquely identifies each row in the table - usually a single column, can also consist of two or more columns
Section 2
(21 cards)