Data Management - Foundations - D426 WGU

Data Management - Foundations - D426 WGU Leave the first rating Students also studied Terms in this set (183) Science Computer Science Save

EIWS BOOK 1 (116)

26 terms omar_a_poole_mil Preview

AP Computer Science Principles: Un...

• terms

eharichandPreview AVL Trees 10 terms maddyross560 Preview Javascr

• terms

Tea Practice questions for this set Learn1 / 7Study using Learn What normal form am I?All non-key columns depend on the whole primary key.DataNumeric, textual, visual, or audio information that describes real-world systems. It is collected and processed to aid in a variety of tasks.Analog DataMost common before computers. Audio was recorded as vibrations impressed on vinyl disks.Choose an answer 1Data2Second Normal Form (2NF) 3Transaction4Table Clusters/Multi-Tables Don't know?

Digital DataMost common today. Encoded as 0s and 1s on electronic magnetic data.DatabaseA collection of data in structured format. In principle, can be stored on paper or even clay tablets.Database System (DBMS)Software that reads and writes in a database.QueryA request to retrieve or change data in a database. Typically inserts new data, retrieves data, updates, data, or deletes data from a database.Query LanguageSpecialized programming language designed specifically for database systems.Reads and writes data efficiently.Database ApplicationSoftware that HELPS business users interact with database systems.Database AdministratorWhat role am I?Responsible for securing the database system against unauthorized users. They enforce procedures for user access and database system availability.Database DesignerWhat role am I?Determines the format of each data element AND the overall database STRUCTURE. Must balance priorities like including storage, response time, and support for rules that govern the data.Database ProgrammerWhat role am I?Develop programs that utilize a database and write applications that combine query languages and general purpose programming language.Database UserWhat role am I?A consumer of data in a database. They request, update, or use stored data to generate reports or information.TransactionA group of queries that MUST be completed or rejected as a whole.ArchitectureDescribes the internal components AND the relationships between components.Query ProcessorInterprets queries, creates a plan to modify the database or retrieve the data, and returns query results to the application. Performs query optimization.Query OptimizationEnsures efficient instructions are executed on the data from the Query Processor.Storage ManagerTranslates the query processor instructions into low-level file-system commands that modify OR retrieve data. Uses indexes to quickly locate data.

Transaction ManagerEnsures transactions are properly executed. Prevents conflicts between concurrent transactions. Also restores the database to a consistent state in the event of a failure.LogA file containing a complete record of ALL inserts, updates, and deletes processed by the database. The records can be used to restore a database.Catalog/Data Dictionary/RepositoryA directory of tables, columns, indexes, and other database objects.Relational DatabaseStores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also supports SQL. Made up of relations.NoSQLA new generation of DBMS that is NOT based on the traditional relational database model.CRUDAcronym for actions that can be performed by a query.SQL StatementA database command such as a query that inserts, retrieves, updates, or deletes data. Composed of one or more clauses.INSERTInserts rows into a table.SELECTRetrieves data from a table.UPDATEModifies data in a table.DELETEDeletes rows from a table.CREATE TABLECreates a new table by specifying the table and column names.Data TypeIndicates the TYPE of data that can be stored in a field of a column.Data IndependenceAllows database administrators to improve query performance by changing the organization of data on storage devices, without affecting query results or changes to programs.Database DesignA specification of database objects such as tables, columns data types, and indexes. Also refers to the process used to develop the specifications.MetadataData ABOUT the database, such as column names and the number of rows in each table.Database Design - AnalysisThis phase specifies database requirements without regard to a specific database system. May also be referred to as conceptual design, entity-relationship modeling, and requirements definition.Database Design - Logical DesignThis phase implements database requirements in a specific database system.Depicted in a table diagram.

Database Design - Physical DesignThis phase adds indexes and specifies HOW tables are organized on storage media. Specified with SQL statements.KeyA column used to identify individual rows of a table. Used to refer to only one specific row or record.Application Programming Language (API)A library of procedures or classes that links a host programming language to a database.SchemaThe structure of tables in the database.Foreign KeyWhat a primary key from one table is called when it is referenced in another table.Important when starting to build relationships between tables. Refers to a primary key.One-to-ManyThis is the most common relationship. Associates ONE record in ONE table with MULTIPLE records in another table.One-to-OneAssociates only ONE record on one table with ONE record on another table.Data Manipulation Language (DML)What language am I?Allows users to access and modify the data to MAKE queries, and GENERATE reports. Interacting with the data.Data Definition Language (DDL)What language am I?Allows a database administrator to DEFINE the database structure, schema, and subschema.Data Control Language (DCL)What language am I?Commands that CONTROL a database. Includes administering privileges and committing data.MySQL Community/MySQL ServerIs a FREE EDITION. Includes a complete set of database services and tools, and is suitable for non-commercial applications such as education.MySQL EnterprisePAID EDITION for managing commercial databases. Includes MySQL Server AND additional administrative applications.MySQL Command-Line ClientA text interface included in the MySQL Server download. Allows developers to connect to the database server, perform administrative functions, and execute SQL statements.MySQL WorkbenchInstalled with MySQL Server AND allows developers to EXECUTE SQL commands using an editor.