{"panels":[{"content":{"params":{"text":"

A gallery that you use to insert predefined templates consisting of objects like tables, forms, and reports into a pre-existing database.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"061d2ddc-f9b6-4777-aad6-09b08d0543a1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Application Parts"},{"content":{"params":{"text":"

A DBMS is a system for managing data that allows the user to store, retrieve, and analyze infromation.<\/p>\n\n

A database is a tool for collecting and organizing information. <\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"c19a1362-bf64-4d22-97f3-c5d7bf5a3ce2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Database Management System (DBMS) and Database"},{"content":{"params":{"text":"

A visual representation of the data contained in a table or of the results returned by a query.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"2be8751f-e308-4311-86af-1b59cc77cb89","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Datasheet"},{"content":{"params":{"text":"

The kind of information a filed contains--whether text, number, date\/time, or some other type.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"a986234c-5fca-49e6-ba4b-56b59c768262","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Data Type"},{"content":{"params":{"text":"

A small arrow in the lower-right corner of a group that you click to launch a dialog box.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"c2ef361d-e57e-40a8-bf28-40b3bd226d03","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Dialog Box Launcher"},{"content":{"params":{"text":"

A column in a database table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"63f7170d-46d9-4c46-9821-24e70e2a3d4f","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Field"},{"content":{"params":{"text":"

A database object that simplifies the process of entering, editing, and displaying data.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"b5ab1036-c1d6-46dd-ab81-590fd75539b0","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Form"},{"content":{"params":{"text":"

A collection of records separated visually and dsplayed with its introductory or summary information.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"ff2ae099-75b7-4823-b5a3-425a429344d9","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Groups"},{"content":{"params":{"text":"

A set of placeholder characters that forces user to enter data in a specific format.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"aeaa6d0f-e0d7-43e3-8305-8679c899a080","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Input Mask"},{"content":{"params":{"text":"

Normal form refers to the standards and guidelines of database design that can be used to determine if a database is structured correctly.<\/p>\n\n

Normalization is the process of applying rules to a database design to ensure that information is divided into the appropriate tables.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"e9aea9e6-6cc2-4503-aadc-69ad9f248921","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Normal Form and Normalization"},{"content":{"params":{"text":"

Database elements, such as tables, queries, forms, and reports.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"ea954a2e-dbb6-4a3e-8139-13932de485c3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Objects"},{"content":{"params":{"text":"

A primary key is the column in a database that uniquely identifies each row.<\/p>\n\n

A foreign key is a primary key from one table that is used in another table.<\/p>\n\n

A composite key is two or ore primary keys used in a table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"02e669b2-bd5f-4bf4-980e-5eac3f5b1c3b","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Primary Key, Foreign Key, Composite Key"},{"content":{"params":{"text":"

A database object that enables stored data to be searched and retrieved.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"509d5e2c-827c-4b79-bdb7-e1ebf93f03b9","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Query"},{"content":{"params":{"text":"

A collection of predefined objects that you can add to your database, arranged by parts for tracking things such as comments, contacts, and issues.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"dd5e2932-a074-42c5-9910-c56b645b0cfb","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Quick Start"},{"content":{"params":{"text":"

A row in a database table.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"5c1be639-d919-4a39-8c93-31a52974d1be","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Record"},{"content":{"params":{"text":"

Duplicate information in a database.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"8c3f420e-3af6-46d7-bdb8-9de96eeab46d","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Redundant Data"},{"content":{"params":{"text":"

A rule that prevents orphaned records.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"d849b8fe-fd0e-44bf-bc98-917484e044dd","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Referential Integrity"},{"content":{"params":{"text":"

A group of database tables that is connected or linked by a defined relationship that ties the information together.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"2e8f3280-fa82-4629-aced-47bc28811a28","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Relational Database"},{"content":{"params":{"text":"

A database object that presents informatikon in a format that is easy to read and print.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"2ebc5210-45d8-4b13-a2ea-825e9335bee0","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Report"},{"content":{"params":{"text":"

A validation rule is an expression that limits the values that can be entered in the field.<\/p>\n\n

The validation text is the text in the error message that appears when users violat a validation rule.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"3a6ff2a0-e4ab-48c0-948b-84494ce392f2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Validation Rule and Validation Text"},{"content":{"params":{"text":"

A string that contains no characters and is used to indicate that you know no values exists for a field.<\/p>\n"},"library":"H5P.AdvancedText 1.1","subContentId":"70010566-3d73-49f7-8a21-5ea4f524661a","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"title":"Zero-length String"}],"hTag":"h3"}

COMP126 Week 10 Key Terms

Kerri Shields