EECS 1520 Chapter Notes - Chapter 12: Pattern Matching, Cardinality, Database Schema

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: Paul Kashiyama

Document Summary

Specialized database languages allow the user to: specify the structure of data, add, modify, and delete data, query the database to retrieve specific stored data. Database schema provides the logical view of the data in the database. The relational model: a database model in which data and relationships among them are organized into tables. A table is a collection of records. A record (or object/entity) is a collection of related fields that make up a single database entry rows. Each field (or attribute) contains a single data value. Columns: key one or more fields of a database record that uniquely identifies it among all other records in the table. Relationships: records represent individual database objects, fields of a record are attributes of these objects. Shows example of customer and movie relationship in a new table. Certain info is omitted b. c you can find it in the original table.