COMP 1010 Lecture Notes - Lecture 51: Unique Key, Associative Entity, Foreign Key
Document Summary
And the save as option should almost never be used: the reason why, databases may be too big to fit into computer"s. Once created new empty database, take part in two very different activities: definition stage: decide what kind of data your database will store, putting data into the database. Most database users will edit and retrieve data through the views that have been created for the database: view: organized way of looking at data, where the information is sorted, selected, collected, and processed. Three types of views in a database that available to a user: Query: is an answer to a specific question or request. Form: generally shows a single record at a time. Report: view that shows data with common properties grouped together in some fashion, for output only. Create a many-to-many relationship between these tables: need to add another table to the database, this table is transaction table or join table.