Database Design
Studied by 0 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/9
Earn XP
Description and Tags
These flashcards cover key concepts, definitions, and processes involved in database design and development.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
10 Terms
In the Database development process, a Database designer must first __.
Define Database design Objectives.
Database designers collect user database requirements through __.
elicitation.
The logical design of the database includes defining __ and DB constraints.
tables
To minimize data redundancy, database designers __ the database.
Refine & Normalize
A __ is an assertion that must be true at all times in a database.
constraint
In cardinality, a One-to-Many relationship means that an entity on one side can have __ related entities.
many
A __ shows entities and the relationships among them in database design.
Entity-Relationship Diagram (ERD)
In Crow's Foot notation, the symbol 'O+' represents __.
Mandatory-Many.
The term __ refers to a detailed logical representation of data for an organization.
Entity-Relationship (E-R) model.
Attributes in an Entity-Relationship model are represented as __.
oval.
Note 
Flashcards (24)