Database Reference
In-Depth Information
4b.
Figure
26-5
is an excerpt from the database design proposal
for a college administrative management system:
Figure 26-5.
Excerpt from College Database Proposal
Study the figure and answer the following questions:
Identify all foreign keys.
{02}
Describe verbally how you could obtain a list of course
names and chapterr names, lecturing these courses at
specific times.
{02}
Explain verbally how you could obtain a list of program
names and course names in appropriate order for the
college bulletin.
{02}
26.11 Sample Interim Examination B
Instruction: Answer all five questions.
1a.
What is a database?
{02}
1b.
State four primary objectives and four secondary objectives of
a database system.
{08}
1c.
What is data independence? Explain its importance in the
design of a database.
{06}
1d.
State four advantages that a DBS has over traditional file
processing systems.
{04}
2a.
Briefly describe the three levels of architecture in a
database system. You may use diagram(s) in your
explanation.
{10}
2b.
With the use of diagram(s) where necessary, explain how
communication is achieved among end users, the database,
application programs, DBMS and the hardware.
{10}
3a.
State four functions of the DBMS.
{04}
