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

22 views1 pages
Published on 21 Apr 2013
School
York University
Department
Electrical Engineering and Computer Science
Course
EECS 1520
Part E [10 points]
A) attribute
B) cardinality constraint
C) database engine
D) database model
E) Entity-relationship modelling
F) Join
G) physical database
H) Project
I) relation
J) schema
K) Select
L) Structured Query Language
M) subchema
N) tuple
Select one of the terms above to complete each of the following statements.
Place the appropriate LETTER in the blank.
1. Relational databases are examples of a(n) ____. D
2. A table is also called a(n) ____. I
3. A field is also called a(n) ____. A
4. ____ is a database operation to create a relationship. F
5. ____ is software that supports access to and modification of the database contents. C
6. A(n) ____ restricts the number of members in a relationship in Access. B
7. A description of only that part of the database that is particular to a user’s needs is a(n)
____. M
8. ____ is a popular technique for designing relational databases. E
9. ____ is a database operation to extract tuples from a relation. K
10. ____ is a collection of files that contain the data. G
dbterms2
Unlock document

This preview shows half of the first page of the document.
Unlock all 1 pages and 3 million more documents.

Already have an account? Log in

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.

Get OneClass Grade+

Unlimited access to all notes and study guides.

YearlyMost Popular
75% OFF
$9.98/m
Monthly
$39.98/m
Single doc
$39.98

or

You will be charged $119.76 upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.