Font size
WorksheetsCPET401-DBMS-Assessment1
Total questions: 15
Worksheet time: 3mins
It allows you to store information in a structured way, so it can be retrieved and manipulated efficiently.
File System
Database
Storage
Data Mart
is an organized collection of data that can be easily accessed, managed, and updated.
(a)
is basically software that manages the collection of related data
Relational Database Management Systems
Object Database Management System
Database Systems
Database Management Systems
A description of a specific collection of data, using a given data model
Entity
Table
Schema
Metadata
On this step of Normalization Ensure that each column holds atomic
3BNF
1st Normal Form
3rd Normal Form
2nd Normal Form
An independent entity with its own primary key
Strong Entity
Composite
Multivalued
Weak Entity
Uniquely identifies each record in an entity.
Foreign Key
Candidate Key
Primary Key
Composite Key
SQL stands for
(a)
On this database normalization, it removes partial dependency: no non-key attribute should depend on part of a composite primary key.
1st Normal Form
2nd Normal Form
3rd Normal Form
3BNF
A ___________ describes the association between entities.
driver
attributes
relationship
entity
is a visual representation of a database structure that illustrates how data entities are related
Data Flow Diagram
Context Diagram
Data Schema
Entity Relationship Diagram
On this database normalization Every determinant is a candidate key.
3BNF
3rd Normal Form
2nd Normal Form
1st Normal Form
A field in one entity that references the Primary Key of another entity to create relationships.
Candidate Key
Foreign Key
Multivalued Key
Atomic Key
is a fundamental process in designing a well-structured relational database
(a)
An SQL Command that show active databases
(a)
