Converting from an erd to a table design

Assignment Help Database Management System

Reference no: EM13774617

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.

Reference no: EM13774617

Questions Cloud

Obtain the molecular formulas of both compounds : What is the percentage of each element in this substance - Obtain the molecular formulas of both compounds.

Content analysis and statistical analysis : Describe your plans for analyzing your data (e.g., content analysis, statistical analysis, etc.) and your plans for how you will present your results.

Question regarding the merchandise inventory items : A company just starting in business purchased three merchandise inventory items at the following prices. First purchase $80; Second purchase $95; Third purchase $85. If the company sold two units for a total of $240 and used FIFO costing, the gros..

What is meant by the term due process of the law : What is meant by the term due process of the law? What does the term multiculturalism and how does it affect criminal justice

Converting from an erd to a table design : 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.

Write your function so that it returns an array of dice : Write your function so that it returns an array of Dice structs. Each element in the array should be set to indicate one of the possible ways of rolling the sum. The last element in the array should be the special "sentinel" value where both die1 and..

Describe the interrelatedness of criminal justice system : Describe the interrelatedness of the 3 components of the criminal justice system

Project management process groups : Explain how the project management process groups are similar to, yet different from, the project life cycle structure.

Major steps of the process maria will have to oversee : Which documents should Maria read before her class? Based on what you know about ISO 27000 program certification, what are the major steps of the process Maria will have to oversee?

User Account

All Pages