Objectives of Normalization

free the collection of tables from undesirable insertion, update, and deletion dependencies

reduce the need for restructuring the collection of relations, as new types of data are introduced, and thus increase the lifespan of application programs

make the relational model more informative to users

make the collection of tables neutral to the query statistics, where these statistics are liable to change as time goes by

ensure the consistency of the data that is stored as records

Advantages of a Relational Database

easier to maintain security of data

easier to insert and delete data

easier to modify data and data format

make the relational model more informative to users

allocates logical space for all data in the database

ensure the consistency of the data that is stored as records

a small binary file associated with only one database

used to represent the data requirements of a business, regardless of the type of database that is used, and even in the absence of one.

the smallest logical storage unit of a database

a logical unit of database storage space allocation made up of contiguous data blocks

level of logical database storage above an extent

protects the database in case of an instance failure

a logical unit of database storage space allocation made up of contiguous data blocks

the smallest logical storage unit of a database

level of logical database storage above an extent

protects the database in case of an instance failure

level of logical database storage above an extent

protects the database in case of an instance failure

a logical unit of database storage space allocation made up of contiguous data blocks

the smallest logical storage unit of a database

ITE014 MOD 1.2 (PART 1)

Authored by XiaAlexia XiaAlexia

Information Technology (IT)

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

25 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 2 pts

collected facts about a topic or an item

Information

Database

Data

Normalization

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

the result of combining, comparing and performing calculations on data

Database

Information

Data

Normalization

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

a centralized and structured set of data stored on a computer system

Normalization

Information

Data

Database

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

a software that controls storage, organization, and retrieval of data

Database Management System (DBMS)

Oracle

Control Panel

File manager

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Desktop Computing

1980s

1970-72

Early 1980s

1960s

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Mainframe Computing

1970-72

1960s

1970s

1980s

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the database model shown in the picture?

Flat File Model

Hierarchical Model

Relational Model

Network Model

Object-Oriented Model

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

PPL 223 ( QUIZ 2) Syntax and Semantics

Quiz

•

University

20 questions

TIK KELAS 9

Quiz

•

9th Grade - University

20 questions

DSA (Quiz 4) - Trees

Quiz

•

University

20 questions

Computer Basics Quiz

Quiz

•

7th Grade - University

20 questions

Orientasi Dasar PPLG

Quiz

•

10th Grade - University

20 questions

QUIZ 1 - SỬ DỤNG BẢNG TÍNH CƠ BẢN -ICC

Quiz

•

University

20 questions

FDBS Lesson 1 Quiz (Quiz #1)

Quiz

•

University

20 questions

Quiz KTI

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Information Technology (IT)

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

20 questions

Endocrine System

Quiz

•

University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

30 questions

W25: PSYCH 250 - Exam 2 Practice

Quiz

•

University

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

38 questions

Unit 8 Review - Absolutism & Revolution

Quiz

•

10th Grade - University