INSS CH 6, 7, 10.3
record
A ________ generally describes an entity.
MAN
A network stretching across New York City would be a ________.
LAN
A network that is restricted to a single building is a ________.
What is B2B commerce?
B2B electronic commerce involves the sales of goods and services among businesses.
bits
Bandwidth is stated in ________ per second.
What is C2C?
C2C is electronic commerce involved in consumers selling directly to consumers. Examples are eBay, Auction sites, and Craigslist.
minimize
Databases ________ redundancy
attribute
Each characteristic or quality of a particular entity is called a(n) ________.
rows; columns
Each relational database table contains records (listed in _______) and attributes (listed in ______) .
To look-up data in a database
In a DBMS, the foreign key helps to do what?
Access
Microsoft ________ is a popular example of a relational database.
What is disintermediation?
The removal of organizations or business process layers responsible for intermediary steps in a value chain.
Identify and describe the three basic operations used to extract useful data from a relational database?
The select operation creates a subset consisting of all records (rows) in the table that meet stated criteria. The join operation combines relational tables to provide the user with more information than is available in individual tables. The project operation creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required.
Primary key
This key field is the unique identifier for all the information in any row of the table, and cannot be duplicated.
Cloud-based data management services are ideal for smaller to medium-sized businesses looking to establish database capabilities without paying for expensive in-house database products. Companies can use public cloud-based services or they can use a private cloud to share hardware and software between users, reducing the number of servers, DBMS, and storage devices required. ITS MORE AFFORDABLE IDEAL FOR SMALLER BUSINESS
What are some of the benefits of using the cloud as a platform?
Corresponds to the unique numeric IP address for each computer connected to the Internet
What is a domain name?
There are three types of relationships: one-to-one, one-to-many, and many-to-many. A one-to-one relationship occurs when each record in one table has only one related record in a second table. An example might be a table of salespeople and a separate table of company cars. Each salesperson can only have one car, or be related to the one car in the database. A one-to-many relationship occurs when a record in one table has many related records in a second table. An example might be a table of salespeople and clients. Each salesperson may have several clients. A many-to-many relationship occurs when records in one table have many related records in a second table, and the records in the second table have many related records in the first table. An example might be a clients table and a products table. Clients may buy more than one product, and products are sold to more than one client.
What types of relationships are possible in a relational database? Describe and give an example of each.
bit, byte, field, record, file, database
Which is an accurate representation of the data hierarchy from smallest to largest?
product customization
With ________, customers use the internet to self-configure products or services.
e-commerce
You are a musician. You only sell your songs on iTunes. This is an example of a _________ business.
Attribute
Your name in your university's database is a(n) ________.
network interface device
______________in each computer on the network allows devices to link to the computer network.
WANs (wide area networks)
_________s cover large geographical areas.