We have one integrated database system for the operations of a company. In a lar

Question

We have one integrated database system for the operations of a company. In a large company with 500 employees, there are different user groups among these 500 employees. Say, all the receptionists in this company form the user group Receptionist Group. The portion of this database that this user group is authorized to access is called the Receptionist Group's "________" of this database.

(a) "Overall Structure"

(b) "Physical Schema"

(c) "Internal Schema"

(d) "External Schema"

(e) None of (a) to (d) is the correct answer.

(a) "Overall Structure"

(b) "Physical Schema"

(c) "Internal Schema"

(d) "External Schema"

(e) None of (a) to (d) is the correct answer.

Explanation / Answer

Option A

Database is a place/container where all the data is stored.But what is data? In a database even a smallest piece of information becomes data.For example,Student is a data,course is a data and Color is a data height weight food everything is data.In short all the living and non-living objects in this world is a data.

In a database we would be grouping only related data together and storing them under one group name called table.This helps in identifying which data is stored where and under what name.It reduces the time to search for a particular data in a whole database.For example, Student, Teacher, Class, Subject, Employee, Department etc form individual tables.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.