COMP 1010 Lecture Notes - Lecture 50: Relational Database Management System, Database, Social Insurance Number
Document Summary
Relational database: database that uses relationships to connect records. Related records: records that are connected by having the same value for a common field. Primary key field: field whose value is guaranteed unique (different for every record) Foreign key: field is common field in relationship, but it is not a primary key. One-to-many relationship: relationship when one is primary key and one is a foreign key: example: a company can have many addresses, but each address record can only belong to one company. Single table may be involved in relationships with many other tables a relational database: made up of related tables, where each table is a list of records. Fields can be related to common fields in other tables. Primary key relates to a foreign key, it is a one-to-many relationship relational database management software. Database management system (dbms): software that works with databases.