ITM 102 Study Guide - Quiz Guide: Foreign Key, Unique Key, Database

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 102
• Professor: Catherine Middleton

Document Summary

Chapter 1- work with databases and create tables. A database is a structured collection of related information about people, events, and things. A security warning may display so that you can verify that the database file came from a trusted source. In the navigation pane, several database objects are listed. The navigation pane can display the objects by type. Database objects---or objects---are the basic parts of a database that you work with. Database objects work together to provide a database management system (dbms)---software used to manage and interact with the database. The purpose of each database object is summarized as follows: Form-enter new records, delete records, or update existing records. Query-display a subset of the data in response to a specific question. Report-display table data or query results on the screen or in printed form. Macro-store a sequence of commands that can be performed as one task. Databases store information in tables by organizing data into rows and columns.