Data Modelling, Database Design, and UI Best Practices

A comprehensive set of fill-in-the-blank practice questions covering database modelling, UI/UX input and output standards, layout principles, and project tactical reviews based on the lecture notes.

An object or concept that stores information in a database is known as an __________.

Entity

A specific characteristic or property of an entity is called an __________.

Attribute

A __________ is an association or connection between two entities.

Relationship

__________ defines the numerical relationship metrics between collaborating entities.

Cardinality

A unique attribute that explicitly identifies each individual record within a database table is called a __________.

Primary key

A __________ connects two tables together by referring directly to the primary key of another table.

Foreign key

In the SQL code provided, the StudentiD is defined as __________.

INT PRIMARY KEY

__________ is a high-level database architecture focused on identifying business entities and relationships using abstract modeling tools like ERDs.

Conceptual Database Design

Conceptual Database Design is __________ of database software.

independent

The phase where the conceptual ERD is mapped into actual structures, tables, data types, and PK/FK definitions is called __________.

Physical Database Design

To keep an input form clean and avoid asking for non-essential data, designers should use a __________.

Simple layout

Logical, clear __________ should be provided so users understand exactly what data format is required.

labels

__________ entails implementing prompt verification constraints to verify input correctness before the user commits.

Data validation

Standardizing button positions and form styling across the application environment is part of maintaining __________.

Consistency

To minimize typing mistakes, widgets like __________ and checkboxes should be applied.

dropdown selectors

Output best practice includes __________, which means filtering out noise and displaying only critical, context-aligned data.

Relevance

Utilizing professional typography, suitable padding, and readable alignment is part of __________.

Readable Formating

Highlighting paramount metrics or status flags using distinct weight variations is a technique used in __________.

Visual Hierarchy

Effective layout design relies on an intuitive visual structure, proper element padding, uniform design rhythm, and straightforward __________ paradigms.

navigation

Navigation menus should be universally docked across the __________ region or along the left side canvas bar.

Top header

Standard navigation placement coordinates align with standard __________.

scanning habits

The web layout standard font size for Headings is between __________ and __________.

$20\,px$ and $32\,px$

The web layout standard font size for Body text is between __________ and __________.

$14\,px$ and $16\,px$

A quality pass evaluating project documents to verify clarity and ensures criteria are testable is a __________.

Requirement Review

__________ involves evaluating system blueprints, architectural models, and sequence schemas.

Design Review

__________ is a peer engineering review focused on identifying optimizations and checking style.

Code review

A systematic process loop verifying executable compliance is known as __________.

Testing

The tactical approach of creating clean, discoverable system guides to simplify asset maintenance cycles is __________.

Documentation