FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When a database is created, what is defined when names and data types are assigned to all data fields in a table?
A
Structure
B
Definition
C
Design
D
Theme
Explanation: 

Detailed explanation-1: -A database schema defines how data is organized within a relational database; this is inclusive of logical constraints such as, table names, fields, data types, and the relationships between these entities.

Detailed explanation-2: -A relational database organizes data into rows and columns, which collectively form a table. Data is typically structured across multiple tables, which can be joined together via a primary key or a foreign key.

Detailed explanation-3: -The term “field” is usually used interchangeably with “column, ” but database purists prefer to use the word “field” to denote a particular value or single item of a column. Thus, a field is the intersection of a row and a column.

Detailed explanation-4: -Explanation. The correct answer is schema. The schema describes the structure of the database.

Detailed explanation-5: -A database schema defines the name, data type, and length of each field in the database. It tells how the data is stored within the database.

There is 1 question to complete.