CSE 511 Week 1 Questions And Answers With Verified
Solutions
What is the role of a relationship in a database? ANS It connects two entities.
Which of the following can be an entity name in a database?
- Gender
- Student
- First Name
- Age ANS Student can be an entity name because it is an object with multiple characteristics, such as
name, address, phone number, etc.
What is required in order to use the cartesian product operator on two relations? ANS It can be applied to
any two relations without a requirement.
Consider two relations A and B in a database. Relation A has 5 rows and relation B has 3 rows. How many
rows are produced if we apply the cartesian product operation to A and B? ANS 15 b/c The number of
rows created by the cartesian product is found by multiplying the number of rows in each relation. The new
table should have the columns of BOTH previous tables
Which mathematical operator must be used in order to display information about students who are majoring in
Computer Science but not in Electrical Engineering? ANS Difference
Which statement about the selection operator is true? ANS It filters certain tuples in a relation based on
given criteria.
Which mathematical operator must be used in order to display information about students who are majoring in
both Computer Science and Electrical Engineering? ANS Intersection
Which mathematical operation must be completed before the ϴ-Join operation? ANS Cartesian Product
For which of the following functions require database management software because typical spreadsheet
software cannot implement it? ANS Create multiple user types
Solutions
What is the role of a relationship in a database? ANS It connects two entities.
Which of the following can be an entity name in a database?
- Gender
- Student
- First Name
- Age ANS Student can be an entity name because it is an object with multiple characteristics, such as
name, address, phone number, etc.
What is required in order to use the cartesian product operator on two relations? ANS It can be applied to
any two relations without a requirement.
Consider two relations A and B in a database. Relation A has 5 rows and relation B has 3 rows. How many
rows are produced if we apply the cartesian product operation to A and B? ANS 15 b/c The number of
rows created by the cartesian product is found by multiplying the number of rows in each relation. The new
table should have the columns of BOTH previous tables
Which mathematical operator must be used in order to display information about students who are majoring in
Computer Science but not in Electrical Engineering? ANS Difference
Which statement about the selection operator is true? ANS It filters certain tuples in a relation based on
given criteria.
Which mathematical operator must be used in order to display information about students who are majoring in
both Computer Science and Electrical Engineering? ANS Intersection
Which mathematical operation must be completed before the ϴ-Join operation? ANS Cartesian Product
For which of the following functions require database management software because typical spreadsheet
software cannot implement it? ANS Create multiple user types
