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
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
Lossless Compression
*Eliminates redundancy but retains all the original data
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
Windows 7 lets you change the appearance of your folders. Place the following steps in order if you wanted to open your folder options to modify the look of a folder. - click organize (on the command bar) - click folder and search options - click the folder
- 2 - 3 - 1
Place the following steps in order if you wish to view all your files' extensions. - View the file extensions for the various files in File Explorer. - Open File Explorer (if you do not have an icon for this in the taskbar, click Start, select Windows System, and then select File Explorer). - In File Explorer, click the View tab. - In the View tab, click the check box next to File name extensions to see file extensions.
- 4 - 1 - 2 - 3
Place the following steps in order to store a file on Google Drive (first step on top). - Browse to the file and click Open. - Open your Google Drive account (sign in if necessary). - Click on New to open the drop-down menu. - Select File upload.
- 4 - 1 - 2 - 3
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
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
company database
Created for use by organizations. Users access the database via computers linked to local or wide area networks.
Common DBMSs
Microsoft access, oracle database, and Microsoft SQL server
RAID
Redundant Array of Independent Disks
The smallest unit of data storage is a ________.
a bit
Foreign Key
a common field between tables that is not the primary key
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
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
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
electronic storage
found on MicroSD(secure digital) cards, universal serial bus (USB) (Thumb) drives, solid state drives
Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.
integrity
The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view. - integrity - logical - physical - dynamic
logical
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
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
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
A link between tables in a relational database that defines how the data is related is called a ________. - join - partnership - relationship - link
relationship
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
An easy way to create a new folder in Windows is to ________ on any area in the Contents pane, and then click New and Folder. -right click -double click -swipe -click
right click
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
To change the size of your folder's icon, just right-click on a blank area of the Contents pane and click ________. - view - properties - resize - enlarge
view
Select two optical drives. *USB drive *DVD Drive *Hard drive *blu-ray player
*DVD drive *Blu-ray player
common primary keys
- student id numbers - social security numbers - customer id numbers
You've started a report and want to save it to your Desktop. Place the following steps in order, with the first step on the top. -Name the file and click Save. -select computer -select desktop -select save as -click the file tab
-5 -3 -4 -2 -1
Select the common image file formats. - .jpg - .png - .xls - .avi
.jpg .png
Select the common video file formats. -.mov -.avi .xls .MPEG
.mov .avi .MPEG
Select the common word processing file extensions. -.odf -.docx -.avi -.xls
.odf .docx
Gigabyte
1 billion bytes
Megabyte (MB)
1 million bytes 1,000 kilobytes
Terabyte
1 trillion bytes
Kilobytes
1,000 bytes
Petabytes
1024 terabytes
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
Directory
The organization of files and folders on a hard drive or other storage device
Bytes
a unit of digital information that commonly consists of 8 bits. it is the smallest addressable unit of memory in many computer architectures
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 type of database that uses common fields to create links between tables is called a ________ database. - linkage - multidimensional -object-oriented -relational
relational
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
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
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.
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
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
There are several ways to rename a folder in Windows. Which of these would work? - On the command bar, click Organize and then click Rename. - Click the folder icon and press F2 to activate the edit mode. - Right-click a folder and click Rename - Double-click on the title bar. Click New and then click Folder.
- On the command bar, click Organize and then click Rename. - Click the folder icon and press F2 to activate the edit mode. - Right-click a folder and click Rename
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
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
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
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
renaming folders
1.file explorer 2. right click on the folder you want to rename 3. select rename from the dropdown menu
Change file display
1.right click on the folder 2. select properties from the drop-down menu 3. the customize option allows you to change a folder's icon OR 1.click the view tab at the top of file explorer? OR 1. right click a blank area of contents pane and click view
A typical laptop has a storage capacity of approximately ________.
500 GB-1 TB
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
