CPET401-DBMS-Assessment1

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