Database Design Quiz

An entity with atomic attributes that has no partial functional dependencies is in … form

 

• 1NF

• UNF

• 3NF

• 2NF

A primary key for an entity is

• A tuple

• A unique attribute

• A relationship

• Anyattribute

Choose the right order of the database design phases

• Conceptual Design, Logical Design, Physical Design, Queries Implementation

• Subject area analysis, Logical Design, Conceptual Design, Physical Design

• Subject area analysis, Conceptual Design, Logical Design, Physical Design

• Conceptual Design, Logical Design, Physical Design, DBMS Selection

Database is a collection of…

• Modules

• Programs

• None of the given

• Data

In an ER diagram an entity is represent by a

• Rectangle

• Rhombus

• Triangle

• Ellipse

In which ways two tables may be related

• One-to-one

• All of the given

• One-to-many

• Many-to-many

Entity Relationship model consists of a collection of basic objects called … and relationships among these objects.

• Entities

• Models

• None of the given

• Functions

. Determine the primary key by the description of the table: Students (stud_id, Name, fname, bdate, group_id)

 

• fname

• study_id

• group_id

• lname

In an ER diagram by Chen's notation attributes are represented by

• Rectangle

• Rectangle

• Triangle

• Ellipse

In ER Diagram by Chen's notation a relationship type is represented by

 

• Rhombus

• Ellipse

• Rectangle

• Triangle