EECS 1520 Study Guide - Midterm Guide: Sql, Database Engine, Database Model

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: Heather Jenkins

Document Summary

Part e [10 points: attribute, cardinality constraint, database engine, database model, entity-relationship modelling, join, physical database, project. I) relation: schema, select, structured query language, subchema, tuple. Select one of the terms above to complete each of the following statements. Place the appropriate letter in the blank: relational databases are examples of a(n) ____. D: a table is also called a(n) ____. I: a field is also called a(n) ____. A: ____ is a database operation to create a relationship. F: ____ is software that supports access to and modification of the database contents. C: a(n) ____ restricts the number of members in a relationship in access. B: a description of only that part of the database that is particular to a user s needs is a(n) M: ____ is a popular technique for designing relational databases. E: ____ is a database operation to extract tuples from a relation. K: ____ is a collection of files that contain the data.