Download Database Concepts: Definitions and Explanations and more Exams Accounting in PDF only on Docsity!
BUS 340 Exam 2 with answers
data redundancy - ....🔰VERIFIED ANSWERS.... ✔✔presence of duplicate data in multiple data files (wastes storage) data inconsistency - ....🔰VERIFIED ANSWERS.... ✔✔same attribute may have different values database - ....🔰VERIFIED ANSWERS.... ✔✔a collection of related files containing records on people, places, or things. A group of related files makes up a database bit - ....🔰VERIFIED ANSWERS.... ✔✔the smallest unit of data that a computer can handle field - ....🔰VERIFIED ANSWERS.... ✔✔a grouping or characters into a word, a group of words, or a complete number (such as a person's name or age) byte - ....🔰VERIFIED ANSWERS.... ✔✔a group of bits, represents a single character (a letter or number) entity - ....🔰VERIFIED ANSWERS.... ✔✔a person, place, or event on which we store and maintain information attribute - ....🔰VERIFIED ANSWERS.... ✔✔specific characteristics of each entity
database management systems - ....🔰VERIFIED ANSWERS.... ✔✔specific type of software for creating, storing, organizing, and accessing data from a database. separates the logical and physical views of the data logical view - ....🔰VERIFIED ANSWERS.... ✔✔how end users view data physical view - ....🔰VERIFIED ANSWERS.... ✔✔how data are actually structured and organized (Microsoft Access, DB2, Oracle Database) relational database - ....🔰VERIFIED ANSWERS.... ✔✔stores data in tables, two-dimensional (relations) with columns and rows. each table contains data about an entity and its attributes fields - ....🔰VERIFIED ANSWERS.... ✔✔(columns) store data representing an attribute file - ....🔰VERIFIED ANSWERS.... ✔✔a group of records record - ....🔰VERIFIED ANSWERS.... ✔✔(tuples) groups of related fields (like a student's ID, the course taken, the data, and the grade) rows - ....🔰VERIFIED ANSWERS.... ✔✔store data for separate records
three basic functions of a DBMS - ....🔰VERIFIED ANSWERS.... ✔✔select join project select function - ....🔰VERIFIED ANSWERS.... ✔✔creates a subset of all records meeting stated criteria join function - ....🔰VERIFIED ANSWERS.... ✔✔combines relational tables to present the server with more information than is available from individual tables project - ....🔰VERIFIED ANSWERS.... ✔✔creates a subset consisting of columns in a table. permits user to create containing only desired information data definition capability - ....🔰VERIFIED ANSWERS.... ✔✔specify structure of content of database data dictionary - ....🔰VERIFIED ANSWERS.... ✔✔automated or manual file storing definitions of data elements and their characteristics data manipulation language - ....🔰VERIFIED ANSWERS.... ✔✔used to add, change, delete, and retrieve the data in the database
report generation - ....🔰VERIFIED ANSWERS.... ✔✔the data of interest can be displayed in a more structured and polished format than would be possible just by querying non-relational DBMS - ....🔰VERIFIED ANSWERS.... ✔✔uses more flexible data model and are designed for managing large data sets across many distributed machines and for easily scaling up or down cloud databases - ....🔰VERIFIED ANSWERS.... ✔✔relational database engines provided by cloud computing services big data - ....🔰VERIFIED ANSWERS.... ✔✔data sets with volumes so huge that they are beyond the ability of a typical DBMS to capture, store, and analyze business intelligence infrastructure - ....🔰VERIFIED ANSWERS.... ✔✔array of tools for obtaining useful information from internal and external systems and big data data warehouses - ....🔰VERIFIED ANSWERS.... ✔✔a database that stores current and historical data of potential interest to decision makers throughout the company. cannot be altered. data marts - ....🔰VERIFIED ANSWERS.... ✔✔a subset of a data warehouse, in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users
clustering - ....🔰VERIFIED ANSWERS.... ✔✔discovering as yet unclassified groupings forecasting - ....🔰VERIFIED ANSWERS.... ✔✔uses series of values to forecast future values overengineering - ....🔰VERIFIED ANSWERS.... ✔✔building a model with so many variables that the solution arrived at might only work on the subset of data used to create it text mining - ....🔰VERIFIED ANSWERS.... ✔✔can extract key elements from unstructured big data sets, discover patterns and relationships, and summarize the information sentiment analysis - ....🔰VERIFIED ANSWERS.... ✔✔used by companies to find out how their customers feel - favorable or unfavorable web mining - ....🔰VERIFIED ANSWERS.... ✔✔discovery and analysis of useful patterns and information from the web content mining - ....🔰VERIFIED ANSWERS.... ✔✔mines content of web sites structure mining - ....🔰VERIFIED ANSWERS.... ✔✔mines website structural elements, such as links
usage mining - ....🔰VERIFIED ANSWERS.... ✔✔mines user interaction data gathered by web servers artificial intelligence - ....🔰VERIFIED ANSWERS.... ✔✔computer software that seeks to reproduce or mimic human thought, decision making, or brain functions neural network - ....🔰VERIFIED ANSWERS.... ✔✔examines data and hunts down and exposes patterns, in order to build models and exploit findings expert systems - ....🔰VERIFIED ANSWERS.... ✔✔leverages rules or examples to perform a task in a way that mimics applied human expertise genetic algorithms - ....🔰VERIFIED ANSWERS.... ✔✔model building techniques where computers examine many potential solutions to a problem information policy - ....🔰VERIFIED ANSWERS.... ✔✔states an organization's rules for organizing, managing, storing, and sharing information data administration - ....🔰VERIFIED ANSWERS.... ✔✔responsible for specific policies and procedures through which data can be managed as a resource database administration - ....🔰VERIFIED ANSWERS.... ✔✔database design and management group responsible for
criminal records and combines this with private data such as from credit cards convergence - ....🔰VERIFIED ANSWERS.... ✔✔telephone networks and computer networks converging into single digital network using Internet standards computer network - ....🔰VERIFIED ANSWERS.... ✔✔in simplest form, consists of two or more connected computers major components in a simple network - ....🔰VERIFIED ANSWERS.... ✔✔client computer server computer network interfaces connection medium network operating system (NOS) hub or switch routers server computer - ....🔰VERIFIED ANSWERS.... ✔✔a computer on a network that performs important network functions for client computers network operating system (NOS) - ....🔰VERIFIED ANSWERS.... ✔✔routes and manages communications on the network and coordinates network resources
hub - ....🔰VERIFIED ANSWERS.... ✔✔simple devices that connect network components, sending a packet of data to all other connected devices switch - ....🔰VERIFIED ANSWERS.... ✔✔has more intelligence than a hub and can filter and forwards data to a specified destination on the network routers - ....🔰VERIFIED ANSWERS.... ✔✔a communications processor that routes packets of data through different networks, ensuring that the data sent gets to the correct address software defined networking (SDN) - ....🔰VERIFIED ANSWERS.... ✔✔allows network administrators more manageability of loads, more flexible and efficient (good for cloud computing) packet switching - ....🔰VERIFIED ANSWERS.... ✔✔method of slicing digital messages into parcels (packets), sending packets along different communication paths as they become available, and then reassembling packets at destination protocols - ....🔰VERIFIED ANSWERS.... ✔✔rules that govern transmission of information between two points transmission control protocol - ....🔰VERIFIED ANSWERS.... ✔✔handles the movement of data between the computers. establishes a connection between the computers, sequences the transfer of packets, and acknowledges the packets sent
analog signal - ....🔰VERIFIED ANSWERS.... ✔✔represented by a continuous waveform that passes through a communications medium and has been used for voice comunication digital signal - ....🔰VERIFIED ANSWERS.... ✔✔a discrete, binary waveform rather than a continuous waveform local-area networks (LANs) - ....🔰VERIFIED ANSWERS.... ✔✔ethernet is standard for physical medium, workgroup network model (peer-to-peer architecture), Windows domain network model wide-area network (WAN) - ....🔰VERIFIED ANSWERS.... ✔✔spans broad geographical distances - entire regions, states, continents, or the entire globe metropolitan area network (MAN) - ....🔰VERIFIED ANSWERS.... ✔✔a network that spans a metropolitan area, usually a city and its major suburbs hertz - ....🔰VERIFIED ANSWERS.... ✔✔number of cycles per second bandwidth - ....🔰VERIFIED ANSWERS.... ✔✔difference between highest and lowest frequencies on a single channel
T1, T3 lines - ....🔰VERIFIED ANSWERS.... ✔✔leased, dedicated lines suitable for businesses, government agencies requiring high-speed guaranteed service levels domain name - ....🔰VERIFIED ANSWERS.... ✔✔the English-like name that corresponds to the unique 32 bit numeric IP address for each computer connected to the Internet coaxial cable - ....🔰VERIFIED ANSWERS.... ✔✔insulated copper cable used by television providers digital subscriber line (DSL) - ....🔰VERIFIED ANSWERS.... ✔✔operate existing telephone lines to carry voice, data, and voice at transmission rates ranging from 385 Kbps all the way up to 40 Mbps, depending on usage patterns and distance cable internet connections - ....🔰VERIFIED ANSWERS.... ✔✔provided by cable television vendors use digital cable coaxial lines to deliver high-speed internet access to homes and businesses terrestrial wireless - ....🔰VERIFIED ANSWERS.... ✔✔provided by earth-bound base stations like cell phone towers HTML (hypertext markup language) - ....🔰VERIFIED ANSWERS.... ✔✔formats documents and incorporates dynamic links to other documents and pictures stored in the same or remote computers
ICANN (internet corporation for assigning names and numbers) - ....🔰VERIFIED ANSWERS.... ✔✔nonprofit organization responsible for managing the internet's domain and numbering cybersquatting - ....🔰VERIFIED ANSWERS.... ✔✔acquiring a domain name that refers to a firm, individual, product, or trademark, with the goal of exploiting it for financial gain second-generation web services four defining features - ....🔰 VERIFIED ANSWERS.... ✔✔interactivity real-time user control social participation user generated content RSS (really simple syndication) - ....🔰VERIFIED ANSWERS.... ✔✔syndicates web content so aggregator software can pull content for use in another setting or viewing later wikis - ....🔰VERIFIED ANSWERS.... ✔✔collaborative web sites where visitors can add, delete, or modify content on the site voice over IP (VoIP) - ....🔰VERIFIED ANSWERS.... ✔✔delivers voice information in digital form using packet switching, avoiding the tolls charged by local and long-distance telephone networks radio frequency identification (RFID) - ....🔰VERIFIED ANSWERS.... ✔✔use tiny tags with embedded microchips containing data about an item and location
wireless sensor networks (WSNs) - ....🔰VERIFIED ANSWERS.... ✔✔networks of hundreds or thousands of interconnected wireless devices embedded into physical environment to provide measurements of many points over large spaces virtual private network (VPN) - ....🔰VERIFIED ANSWERS.... ✔✔a scure, encrypted, private network that has been configured within a public network to take advantage of the economies of scale and management facilities of large networks traceroute - ....🔰VERIFIED ANSWERS.... ✔✔repeatedly sends a cluster of three packets starting at the first router connected to a computer last mile - ....🔰VERIFIED ANSWERS.... ✔✔refers to technologies that connect end users to the internet internet backbone - ....🔰VERIFIED ANSWERS.... ✔✔high-speed data lines that interconnect and collectively form the core of the internet amdahl's law - ....🔰VERIFIED ANSWERS.... ✔✔system's speed is determined by its slowest component broadband - ....🔰VERIFIED ANSWERS.... ✔✔high-speed internet connections
long tail - ....🔰VERIFIED ANSWERS.... ✔✔large selection of content beneficial for internet retialers collaborative filtering - ....🔰VERIFIED ANSWERS.... ✔✔classification of software that monitors trends among customers and uses this data to personalize an individual customer' experiences first saw doctrine - ....🔰VERIFIED ANSWERS.... ✔✔ruling that states that a firm can distribute physical copies of legally acquired copyright-protected products windowing - ....🔰VERIFIED ANSWERS.... ✔✔content is available to a given distribution channel for a specified time window disintermediation - ....🔰VERIFIED ANSWERS.... ✔✔removing and organizing from a firm's distribution channel eight unique factors of e-commerce - ....🔰VERIFIED ANSWERS.... ✔✔ubiquity global reach universal standards interactivity information density personalization/customization social technology digital market effects
ubiquity - ....🔰VERIFIED ANSWERS.... ✔✔internet/web technology available everywhere: work, home, and so on, anytime global reach - ....🔰VERIFIED ANSWERS.... ✔✔technology reaches across national boundaries universal standards - ....🔰VERIFIED ANSWERS.... ✔✔the use of the internet and the web to conduct business, transactions across the internet or web interactivity - ....🔰VERIFIED ANSWERS.... ✔✔the technology works through interaction with the user information density - ....🔰VERIFIED ANSWERS.... ✔✔total amount and quality of information available to all market participants personalization/customization - ....🔰VERIFIED ANSWERS.... ✔✔technology permits modification of messages/goods social technology - ....🔰VERIFIED ANSWERS.... ✔✔the technology promotes user content generation and social networking digital goods - ....🔰VERIFIED ANSWERS.... ✔✔goods that can be delivered over a digital network
