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 record is also called a(n) ____. N: ____ is a database operation to create a relationship. F: ____ is a comprehensive database language for managing relational databases. L: ____ 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: ____ is a description of the entire database structure used by the database software to maintain the database. J: ____ is a collection of files that contain the data. G: ____ is a database operation to extract attributes from a relation.