Similar Collections


.

questions

Title
The term _______ is used to refer to a row
The term attribute refers to a ___________ of a table
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time
Course(course_id,sec_id,semester)
Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
A domain is atomic if elements of the domain are considered to be ____________ units
The tuples of the relations can be of ________ order
The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation
Using which language can a user request information from a database
Student(ID, name, dept name, tot_cred)
Which one of the following is a procedural language
The_____ operation allows the combining of two relations by merging pairs o tuples, one from each relation, into a single tuple
The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match
The _______operation performs a set union of two “similarly structured” tables
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
The _______ operator takes the results of two queries and returns only rows that appear in both result sets
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys
The _________ provides a set of operations that take one or more relations as input and return a relation as an output
total questions: 79

Questions

79

Views

786

Best Answers

299

Points

5