chatgpt exam 2 quizzy
Many-to-One (N:1)
Each entity in one entity set can be associated with only one entity in another entity set, but each entity in the second set can be associated with multiple entities in the first set.
SaaS
a cloud computing model in which software applications are hosted and provided to users over the internet on a subscription basis, eliminating the need for users to install, maintain, or manage the software locally.
PaaS
a cloud computing service that provides a platform and environment for developers to build, deploy, and manage applications without worrying about underlying infrastructure, such as servers and operating systems.
private key
a confidential, cryptographic key used in public-key encryption systems to digitally sign, decrypt, or authenticate data. It must be kept secret by the key's owner to maintain the security of the system.
the Transmission Control Protocol (TCP)
a core communication protocol in computer networks that ensures reliable and ordered data transfer between devices by establishing and maintaining connections and managing data transmission.
Normalization
a database design process that organizes data in a relational database to eliminate redundancy and improve data integrity by ensuring that data is stored efficiently and consistently in separate tables.
SQL
a domain-specific programming language used for managing and querying relational databases.
the Internet Protocol (IP)
a set of rules and conventions that govern how data is transmitted and routed over the internet, ensuring data packets reach their intended destinations.
Database
a structured collection of organized data that is stored electronically and can be easily accessed, managed, and queried for various purposes, such as storing and retrieving information.
Firmware
a type of software that is embedded in hardware devices and is responsible for controlling and managing the device's operations and functionality.
closed source programs
also known as proprietary software, are software applications for which the source code is not made available to the public.
IaaS
cloud computing service model that provides virtualized computing resources over the internet, including servers, storage, and networking, allowing users to deploy and manage their own software applications and services on this infrastructure.
foreign key
database field that establishes a link between two tables, ensuring referential integrity by requiring that values in one table correspond to values in another table's primary key. It is used to create relationships between tables in a relational database.
an Entity
distinct, identifiable object, concept, or thing that exists and can be described or recognized as a separate unit within a context or system.
One-to-Many (1:N)
each entity in one entity set can be associated with multiple entities in another entity set, but each entity in the second set is associated with only one entity in the first set.
One-to-One (1:1)
each entity in one entity set is associated with exactly one entity in another entity set, and vice versa.
Many-to-Many (N:N)
entities in both sets can have multiple associations with entities in the other set. This typically requires a junction table to represent the relationships.
an E-R diagram
graphical representation that illustrates the entities (objects or concepts), their attributes, and the relationships between them in a database or information system.
the Internet of Things (IoT)
network of interconnected physical devices, objects, or "things" that are embedded with sensors, software, and connectivity, allowing them to collect and exchange data over the internet.
DBMS Functions
refer to the core operations and capabilities provided by a database management system. These functions include data storage, retrieval, organization, and management, as well as the enforcement of data integrity, security, and support for concurrent access by multiple users.
Metadata
refers to data that provides information about other data
Maximum cardinality
represents the maximum number of occurrences of an entity that can be associated with another entity in a relationship
Minimum cardinality
represents the minimum number of occurrences of an entity that must be associated with another entity in a relationship.
open source programs
software applications whose source code is made freely available to the public, enabling users to use, modify, and distribute the software with minimal restrictions.
the characteristics of native applications
software programs developed specifically for a particular operating system (OS) or platform, utilizing the native tools, libraries, and APIs of that OS.
the characteristics of web applications
software programs that operate over the internet, typically accessible through web browsers, and provide interactive services or functionality to users.
Database application
software that allows users to interact with and manage data stored in a database, facilitating tasks such as data entry, retrieval, manipulation, and reporting
data model
structured representation of data and its relationships within a system, used to define how data is organized, stored, and accessed in a database or information system.
Virtualization
the process of creating a virtual, or software-based, representation of physical resources, such as computer hardware, operating systems, or storage, to enable multiple virtual instances to run independently on a single physical system.
