B ITM 215 Information Lecture Notes - Lecture 3: Social Security Number, Camel Case

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 215 Information
• Professor: Ethan Sprissler

Document Summary

Itm 215 - lecture 3 - database concepts pt2. Types of relationships: your ssn (social security number), driver"s license, birth certificate. One-to-many relationship: one bank with many customers; one university with many students; one student with many classes keys. Many-to-many relationship: artificially constructed table, junction table, that joins tables using foreign, field names should be meaningful. Creating fields in tables: rules for naming fields, length can be up to 64 characters, can include letters, numbers, should not include spaces, access uses camelcase notation, produces a value from an expression or function. Add calculated fields to a table: references one or more existing fields, calculated fields are stored in a table, enables adding data to, queries, forms, reports. Wildcards are special characters that can represent one or more characters in a text value, which are entered in the criteria row of a query. Wildcards: the question mark (?) stands for a single character in the same position as the question mark.