CGS Final

Traditional hard drive

*A desktop computer's primary storage device . *A hard drive uses spinning magnetized platters to store data and information *Relatively inexpensive compared to solid state drives

Hard Drive Data Storage

*Traditional, magnetic hard drives store data on spinning metal platters with a magnetized coating. *hard disk drives have longer access times and require more electricity than solid- state hard drives

Blu-ray disc

*Type of optical media in optical drives *They can store up to 50 GB of data

Select the advantages of using a USB drive instead of a DVD. *USB drive has a shorter access time. *USB drive is less expensive. *USB drive is more durable. *USB drive is more accurate

*USB drive has shorter access time. *USB drive is more durable.

Holographic storage

*Uses a split laser beam to write data onto photoreceptive substrates *Many bits of storage can be stored in the same physical location

memristor storage

*Uses an advanced circuit element called a memristor, which has variable resistance based on the history of current that has passed through the element

Select two characteristics of a traditional hard drive. *Uses magnetically charged plates to store data *Reads data with lasers *Uses solid-state electronic circuitry to store data *Often found in desktop computers

*Uses magnetically charged plates to store data *Often found in desktop computers

Solid state drives store data using ________. *electronic circuits *laser markings *magnetically charged particles *reflective coatings

*electronic circuits

Because a metal platter is physically spinning, hard drives have ________ access times than solid state hard drives *faster *wider *longer *shorter

*longer

In general, the ________ the access time, the faster the hard drive. *longer *slower *wider *shorter

*shorter

Select what's true about database fields. - A group of related characters in a database. - Represents a characteristic of someone or something. - Primary key is a field designation. - A field is a row in a table.

- A group of related characters in a database. - Represents a characteristic of someone or something. - primary key is a field designation

relationship

- a link between tables that defines how the data are related - a common field between the two tables is used to create the link

relational databases

- organize data into tables based on structured data groupings - use links called relationships between tables - information in tables is stored in rows, called records, and columns, called fields - a common field that is included in both tables is used to create the relationship

common primary keys

- student id numbers - social security numbers - customer id numbers

The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data? - What field name will the data fall under - What data type will be included - What database manufacturer is used - When was the database created

-What field name will the data fall under -What data type will be included

Commercial database

-large database that covers specific subjects -also referred to as information utilities or data banks

Helium hard drives

-use of helium instead of air inside the hard drive -helium is less dense. this allows more platters within the same space -platters stay cooler and can spin faster -20-30% more efficient than air-filled hard drives

Gigabyte

1 billion bytes

Megabyte (MB)

1 million bytes 1,000 kilobytes

Terabyte

1 trillion bytes

Kilobytes

1,000 bytes

To create folder...

1. open file explorer 2. right click on the drive or folder in the folders list and select new folder from the drop-down menu. type the new folder's name in the box that appears OR. right click any blank area in the contents pane. click new and then click folder

Petabytes

1024 terabytes

A typical laptop has a storage capacity of approximately ________.

500 GB-1 TB

individual database

A combined set of data files intended to be used by one person.

DMBS

A database management system, maximizes the usefulness *allows the user to create, modify, and access a database

Central Processing Unit (CPU)

Brain of the computer that performs instructions defined by software

company database

Created for use by organizations. Users access the database via computers linked to local or wide area networks.

Processor Manufacturers

Intel, NVIDIA, AMD

Common DBMSs

Microsoft access, oracle database, and Microsoft SQL server

Arithmetic Logic Unit (ALU)

Performs all arithmetic operations (for example, addition and subtraction) and all logic operations (such as sorting and comparing numbers)

RTOS

Real-time Operating System

RAID

Redundant Array of Independent Disks

Directory

The organization of files and folders on a hard drive or other storage device

The smallest unit of data storage is a ________.

a bit

Foreign Key

a common field between tables that is not the primary key

Server

a computer system in a network that is shared by multiple users. (also referred to as host computers). COMMON TYPES: network, web, and file servers

fields

a field is a group of related characters in a database table. a field is a column in a table that represents a characteristic of someone or something

SQL (Structured Query Language)

a popular language to run operations on databases

Bytes

a unit of digital information that commonly consists of 8 bits. it is the smallest addressable unit of memory in many computer architectures

storage

allows computers to retain data when the device is turned off.

Large databases, often called data banks, that cover particular subjects are referred to as ________ databases.

commercial

data centralization

critical in increasing data integrity when data is centralized, it means it is stored in only one place

What element of a database field specifies the data in a field such as text, numeric, or date/time? - data type -data mart -data configuration - data specificity

data type

The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS ________.

engine

In a database a ________ is a group of related characters in a database table that represents a characteristic of someone or something. - form - field - relationship - report

field

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ________ key.

foreign

When you need to link two tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in the other table. - supplemental -foreign key - false key - secondary

foreign key

To control how information is entered into a database, programmers and database administrators create ________ to help ensure data integrity. - records -tables -relationships -forms

forms

Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.

integrity

Control Unit (CU)

locates, analyzes, and executes each program instruction residing in memory. Tells everything in the computer how to respond.

The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view. - integrity - logical - physical - dynamic

logical

data mining

methods used to search large data stores and use the data to uncover patterns and trends

JPG

most popular lossy image compression format

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ________ database. - time-based - object oriented -multidimensional -relational

multidimensional

You own a pet care center. What fields might you enter when you create a table for dogs that you care for? - owner's last name - pet's name -owner's driver's license number - owner's address

owner's last name pets name owner's address

System Unit

part of the computer that houses the motherboard, which is the circuit board that holds the computer's main microprocessor

In a relational database, an important field that contains a unique value that identifies each record as individual is the ________ key.

primary

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ________.

query

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ________.

record

The type of database that uses common fields to create links between tables is called a ________ database. - linkage - multidimensional -object-oriented -relational

relational

A link between tables in a relational database that defines how the data is related is called a ________. - join - partnership - relationship - link

relationship

gif

some still use this, even though it has largely been replaced by png.

Your college has a database with a Students table. Which of the following could be a primary key in the table? - student number - social security number - street address - last name

student number social security number

A collection of related records in a database is referred to as a ________. - field -primary key -table -report

table

Bit

the basic unit of digital data storage, the smallest unit of data a computer can process

distributed database

the data in a database are stored in different physical locations and accessed via client/ server networks

data integrity

the database is reliable, accurate, and aligned with the goals of the organization

root folder or root directory

the highest level of any directory (represented by C:\

path

the location of the file storage location

wav

the most popular lossless compression format

PNG

the most popular lossless image compression format

Optical Storage

*A storage device that writes and reads data using lasers They work by rotating a disk with a reflective coating *The coating is read with a laser beam within the optical drives read/write head *used with compact discs (CD's) DVDs, and Blu-ray discs.

Select the video file compression formats. *AVI *MP4 *QuickTime *MP3

*AVI *MP4 QuickTime

Select two optical drives. *USB drive *DVD Drive *Hard drive *blu-ray player

*DVD drive *Blu-ray player

Select two characteristics of solid-state drive storage devices. *Durable, no moving mechanical parts *Uses a laser to read data * Uses electronic circuits to store data *Uses magnetic charges to store data

*Durable, no moving mechanical parts * Uses electronic circuits to store data

Lossless Compression

*Eliminates redundancy but retains all the original data

DNA storage

*Has the potential to store extremely large amounts of data for thousands of years *distant solution

Solid-State Drives

*Have no moving parts, making them faster, more durable, and more energy efficient than traditional hard drives *more expensive than traditional hard drives. *Data are accessible when device is not online.

Lossy Compression

*Removes less valuable data

Compact discs(CD's)

*Store data on a plastic disc with a reflective coating. *Coating has pits, which absorb laser beam light, and lands, which reflect laser beam light

DVD(Digital Versatile Disc)

*Stores information with a reflective coating on a plastic disc *The reflective coating has pits, which absorb laser beam light, and lands, which reflect laser beam light *It's pits and lands are far more tightly packed than those of a CD.

Select three characteristics of SSD storage *Uses magnetically charged particles to store data *Uses the same technology that is found in USB drives *Has no mechanically moving parts *Uses flash technology

*Uses the same technology that is found in USB drives *Has no mechanically moving parts *Uses flash technology

query

- a request for information from a table in a database - allows you to find specific data quickly by filtering based on a specific criterion, to calculate/ summarize data, and to automate data management tasks.

Primary Key

- a special relational database field designed to uniquely identify all records in a table - must contain a unique value

Forms

- forms are used to control how data are entered into a database - they structure data input to ensure data integrity

Reports

- offer a way to view, format, and summarize the information in a database - they can be used to display or distribute a summary of data and archive snapshots of the data - they can also be used to provide details about individual records and to create labels

table

a table in a database is a collection of associated records. databases often have more than one table

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ________. - informant -database - spreadsheet -file cabinet

database

electronic storage

found on MicroSD(secure digital) cards, universal serial bus (USB) (Thumb) drives, solid state drives

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem - output - manipulation - definition - dictionary

manipulation

To display or distribute information from a database, programmers or database administrators create ________. - forms - records - reports - tables

reports

To display or distribute information from a database, programmers or database administrators create ________. - table - records - forms - reports

reports

All-in-one computers

the motherboard is housed within the monitor, many have touchscreen interfaces, and come with full operating systems

Hardware

the physical elements f the device including the processor, memory, storage, ports, and peripheral devices.

Software

the virtual elements including the OS and a variety of software applications.