INFS1603 Lecture Notes - Lecture 6: Functional Dependency, Relational Model, Data Dictionary

• School: UNSW, UNSW Sydney
• Department: Information Systems
• Course: INFS1603
• Professor: All

Document Summary

Tuples: are the rows of a relation and represent a single entity instance. The name of a relation (table) and its set of attribute headers (column headers) are called a schema. Each table must have an attribute or combination of attributes that uniquely identifies each row (pk) Each column has a specific range of values known as the attribute domain. The order of the rows and columns is irrelevant to the dbms for the relation: a set of schemas for all relations in a design is called a database schema (metadata) A key consists of one or more attributes that determine the values of other attributes. They are important in a relational model because: They are used to ensure that each row in a table is uniquely identifiable. They establish relationships among tables and ensures the integrity of the data.