RDBMS- Alevel

This type of database uses a single table. This is a _________ database

Characteristics of a flat file database

• Records stored in one place

• High possibility for redundancy

• Performs complex queries

• Easy to update

• Better for small amount of data

This DBMS uses multiple tables linked together to store data. This is a ______________ database.

Features of a RDBMS

• Allows restriction for specific tables

• Data redundancy

• Allows complex queries

• Updates are made across tables

• Removes data redundancy

A _____________ provides metadata. It describes the internal structure about the database

A _______ is language built inside a DBMS that allows operation on the data.

The design and view of the entire database that describes how data is organized and linked

• DDL

• DML

• Schema

• Data Dictionary

Language that allows the creation of the database from scratch using schema

The Schema of the database may also be referred to as the:

This schema level (architecture) refers to a model of how the information in a database is stored and related

• Physical Schema

• Conceptual Schema

• External Schema

• DDL Schema