CH 3(2)-Database Design

What is the embedded approach for DBMS programming languages?

• JDBC for Java

• Embedded SQL for C, C++

• PL/SQL for Oracle

• ODBC for all languages

Which of the following is a user-friendly DBMS interface?

• Command-line interface

• Forms-based interface

• Database query language

• Text-based interface

What is the purpose of requirements modeling in building a DBMS application?

• To write application programs

• To define the database schema

• To decide on entities and their relationships

• To populate the database

Based on this ERD, identify the primary key.

• product

• price

• category

• Product_ID

What does a primary key in an Entity/Relationship Diagram represent?

• A type of database constraint

• An attribute of an entity

• A relationship between two entities

• A unique identifier for an entity set

In a relation, what does the notation A x B represent?

• A type of relationship

• A Cartesian product of sets

• A set of tuples

• A database schema

What type of relationship is represented by 'many-to-many'?

• Multiple entities relate to one entity

• Multiple entities relate to multiple entities

• One entity relates to multiple entities

• One entity relates to one entity

What does the arrow in a multi-way relationship indicate?

• A relationship between entities

• A unique identifier for an entity

• A dependency between attributes

• A direction of data flow

This diagram represents _____ in ERD.

• entity

• integrity

• relationship

• attribute

Relation sets in the diagram refers to _____.

• one-to-three

• one-to-one

• many-to-one

• one-to-two