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

Quiz Diagram Kelas

Quiz

•

11th Grade - University

20 questions

MS2024 Pre-Quiz #5

Quiz

•

University

20 questions

Sejarah dan Perkembangan Komputer_S1B

Quiz

•

University

20 questions

F10E Chapter 7: Information Systems and Management Quiz

Quiz

•

University

22 questions

Internet and App script

Quiz

•

5th Grade - University

20 questions

ICC_Module_7

Quiz

•

University

20 questions

Pengantar Teknologi Informasi

Quiz

•

University

20 questions

LogoNOVA (FYIT Logo Quiz)

Quiz

•

University

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Information Technology (IT)

20 questions

Disney Trivia

Quiz

•

University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

14 questions

Ch.3_TEACHER-led

Quiz

•

University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University