Relational Database Design

Which of the following 2 options should be included in a conceptual data model?

• Table names

• Entity names

• Entity Relationships

• Attributes

The logical model is developed from a practical database implementation perspective. It acts as a blueprint for the actual relational database.

• True

• False

Which of the following options would NOT be included in a physical data model?

• Entity names

• Column Names

• Primary Keys

• Column Data Types

What is the following data model an example of?

• Conceptual Data Model

• Logical Data Model

• Physical Data Model

• Complete Data Model

In relational algebra, what does this symbol ≤ mean?

• Greater than

• Less than

• Greater than or equal too

• Less than or equal too

What will the following relational algebra statement do?

σrelease_year>1997 AND genre=’sci-fi'(Movies)

• Select tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.

• Join tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.

• Select tuples from the release year table where the genre is sci-fi.

• Join tuples from the release year table where the genre is sci-fi.

What will the following relational algebra statement do?

EMPLOYEE ⋈Employee.deptID = Department.ID DEPARTMENT

• Selects Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.

• Intersects Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.

• Unions Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.

• Joins Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.

Microsoft Access and MySQL are two popular relational database management systems.

Which of the following factors would lead you to choose Microsoft Access over MySQL?

• Usability

• Scalability

• Cost

• Security

Complete the sentence below.

Microsoft Access is not known for being highly compatible as it only works on the ________ operating system.

• Linux

• Office

• Windows

• Mac OS

What term do we commonly use to refer to the user interface of a database application?

• Back-End

• Front-End

• Rear-End

• User-End