Review Questions: Chapter 1

2505 words 11 pages
Review Questions: Chapter 1

1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application.

• Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain a database • Database system – not only contains the database itself bit also a complete definition or description of the database structure and constrains. • Database catalog – the information about the database
…show more content…

1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems.

Databases store electronic representations of data, but traditional file systems generally store paper with data written on it. In a traditional file system a file folder is the the way records are grouped, but in a database records are indexed in many ways, both by "file folder" and by record or data field. With relational database approaches relationships can be established between data in records and new records can be created from crossing files and even databases.

1.4. What are the responsibilities of the DBA and the database designers?

The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.

1.5. What are the different types of database end users? Discuss the main activities of each.

• End User • Database Admin • Database Designer • System Analysts and Programmers • System Administrator

1.6. Discuss the capabilities that should be provided by a DBMS.

• Controlling redundancy • Restricting unauthorized access • Providing persistent storage for program objects • Providing storage structures

Related

  • Chapter 1 Review Questions Business Communications
    1176 words | 5 pages
  • Information Systems Chapter 1 Review Questions 1-17
    1279 words | 6 pages
  • Guide to Unix Using Linux Fourth Edition Chapter 1 Review Question Solutions
    2614 words | 11 pages
  • Irp Manual
    8333 words | 34 pages
  • Strayer Pad 520 Entire Course
    4283 words | 18 pages
  • Bus 250 Week 1 Case Study a Brawl in Mickey Backyard
    1316 words | 6 pages
  • 132 Final
    2641 words | 11 pages
  • DMD Case Analysis
    3586 words | 15 pages
  • History: World War I and Bold Experiments
    7626 words | 31 pages
  • Human Resources Management Team
    1234 words | 5 pages