Exam (elaborations)
Database Systems A Practical Approach To Design Implementation And Management, Global Edition, 6Th Edition By Thomas Connolly -Test Bank
- Course
- Institution
Complete Test Bank (with Questions Answers)
[Show more]
Seller
Follow
premiumbiz379
Reviews received
Content preview
, SOLUTIONS TO REVIEW QUESTIONSAND EXERCISES
FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)
,Database Systems: Instructor’s Guide - Part III
Solutions to Review Questions and Exercises
Chapter 1 Introduction to Databases............................................................................................................3
Chapter 2 Database Environment................................................................................................................7
Chapter 3 Database Architectures and the Web.........................................................................................11
2
, Database Systems: Instructor’s Guide - Part III
Chapter 1 Introduction to Databases
Review Questions
1.1 List four government sectors in your country that use database systems.
Some examples could be:
The Health sector, to keep records about health services, staffing, disease and medical
histories;
The Education sector, to keep records about schools, students, teachers, and academic
performance;
Immigration, to keep records about citizens, passports, and other national IDs;
Police to keep records about staff, crimes and criminals.
1.2 Discuss each of the following terms:
Data For end users, this constitutes all the different values connected with the
various objects/entities that are of concern to them. See also Section 1.3.4.
Database See Section 1.3.1
Database Management System See Section 1.3.2
Database Application Program See Section 1.3.3
Data Independence This is essentially the separation of underlying file structures from the
programs that operate on them, also called program-data independence. See
also Sections 1.2.2 and 1.3.1.
Security The protection of the database from unauthorized users, which may involve
passwords and access restrictions. See also Section 1.6.
Integrity The maintenance of the validity and consistency of the database by use of
particular constraints that are applied to the data. See also Section 1.6.
Views These present only a subset of the database that is of particular interest to a
user. Views can be customized, for example, field names may change, and
they also provide a level of security preventing users from seeing certain
data. See also Section 1.3.3.
1.3 Describe the role of database management systems (DBMS) in the database approach. Discuss
why knowledge of DBMS is important for database administrators.
Section 1.3.2 describes the vital role that DBMS plays in the database approach. Surfice to say it,
controls all actions performed against data and the database.
As described in section 1.4.1, DBAs are responsible for physical realization of the database
including the physical database design and implementation of security controls, and other aspects
of database management and administration. It is therefore crucial for the DBA to understand the
key aspects of the specified DBMS they have to work with.
3
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller premiumbiz379. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $28.79. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73314 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
Recently viewed by you
