Crowdly

A collection of related data

A collection of images

A collection of videos

Purpose of Conceptual Schema:

Describes

the physical storage of

database

Shows

relevant info particular to user, hides rest of the info

Describes

structure of whole

database

Describes

entities, their relationships and constraints

The Database Management System (DBMS) is defined as a software system that allows the user ...

to provide a unique interface for any format of data

to store data in a cloud storage

to define, manipulate, and manage data in a database

to create database objects

to provide control of access to the data

Choose the appropriate terms

Represented

using a tree-diagram

Data

elements are stored in different tables

made up of rows and columns

Can

represent one-to-one and many-to-many as

well

Which of the following is not a data model?

Linear data model

Relational data model

Hierarchical data model

Network data model

What is a relational database?

A database that stores data in tables consisting of rows and columns

A database that stores data in a single table

A database that stores data in a network structure

A database that stores data in a hierarchical structure

Select the most appropriate SQL data type to store the specified values

'SQL comes in different dialects, and each dialect shares common data types, as well as including some that are unique.'

'28/04/2023'

0.234e+02

358.67

What is SQL?

Sequential Query Language

Standard Query Language

Simple Query Language

Structured Query Language

What is normalization?

The process of removing duplicate data from a database

The process of manipulating with data to a database

The process of archiving data in a database

The process of organizing data in a database

What is true about a foreign key in a relational database?

A field in a table that refers to the primary key of another table.

A field that cannot contain null values.

A field that can store multiple values.

A field that can store duplicate values.