Converting from an erd to a table design- Database Management System
Part A:
Match the following words with their definitions. (Note that there are more words listed than definitions.) Use each word only once. (1/2 point each)
1. Database
2. DBMS
3. Table
4. SQL
5. Non-procedural database language
6. Procedural language interface
7. Transaction processing
8. Data independence
9. Schema
10. Three schema architecture
11. Client-server architecture
12. Database administrator
13. Data administrator
14. Persistence
____ A database should have an identity separate from the applications (computer programs, forms, and reports) that use it. The separate identity allows the database definition to be changed without affecting related applications.
____ A language, such as SQL, that allows you to specify the parts of a database to access rather than to code a complex procedure.
____ A named, 2-dimensional arrangement of data consisting of a heading part and a body part.
____ An industry standard database language that includes statements for database definition, database manipulation, and database control.
____ A collection of components that support data acquisition, dissemination, maintenance, retrieval, and formatting.
____ Reliable and efficient processing of large volumes of repetitive work. DBMSs ensure that simultaneous users do not interfere with each other and that failures do not cause lost work.
____ An arrangement of components (clients and servers) and data among computers connected by a network. It supports efficient processing of messages between clients and servers.
____ A support position that specializes in managing individuals databases and DBMSs.
____ A management position that performs planning and policy setting for the information resources of an entire organization.
____ A database description.
Part B:
1. What are the 3characteristics of a database? (1 point)
2. List 6common features of most DBMSs. (2 points)
3. List the 3levels of database description in the Three Schema Architecture. (1 point)
4. What is the goal of information resource management? (1 point)
Chapter 2 Homework
Part A:
Match the following words with their definitions. (Note that there are more words listed than definitions.) Use each word only once. (1/2 point each)
1. System
2. Information system
3. Prototype
4. Data model
5. Process model
6. Environment interaction model
7. Entity Relationship Model
8. CASE tools
9. Soft skills
10. Hard skills
11. Forward Engineering
12. Reverse Engineering
13. Conversion
14. Normalization
____ Converting from an ERD to a table design.
____ Computer-aided software engineering applications that help improve the productivity of information systems professional working on large projects.
____ Model that describes kinds of data and relationships among data.
____ A set of related components that work together to accomplish some objective.
____ A graphical representation that depicts things of interest (entities) and relationships among entities.
____ A scaled down version of a system, usually implemented quickly and used to clarify requirements.
____ Quantitative, objective and data intensive skills.
____ Activity that produces a table design from an ERD.
____ Activity that removes redundancy in a table design.
____ Model that describes relationships between events and processes.
