Database design application development administration 3rd edition

The fundamental database technologies of each processing environment are presented; as well as relating these technologies to the advances Brand: Michael V. Our database design and development software tools automate tasks to increase productivity, optimize database performance and reduce costs. Reduce time spent on SQL Server application development and database administration. Download Free Trial Buy Online. Every textbook comes with a day "Any Reason" guarantee.

Published by Chicago Business Press. Need help ASAP. Digital Notes and Study Tools. Important: Access provides design experiences that let you create database applications for the design considerations are different when you design for the Web. This article doesn't discuss Web database application design. For more information, see the article Build a. Database Design and Application Development. In every case, our design and development process begins with a client coming to us to discuss a business problem or opportunity.

Mannino's "Database Design, Application Development, and Administration" provides the information you need to learn relational databases. The next book in my journey to understand database design is Database design, application development, and administration by Michael Mannino. This is an university text-book. My main concern is to learn about logical database modelling.

Fortunately, this book has a. I prefer the following books over others: 1. Last edited by Akinozahn. What statements belong in a procedural language but not in a nonprocedural language? Ans: A nonprocedural language allows users with limited computing skills to submit queries instead of coding complex procedures. Nonprocedural languages specify what parts of a database to retrieve, not the detail of how retrieval occurs as compared to procedural language.

Statements that belong in a procedural language but not in a nonprocedural language are looping statements for, while, and so on. Why is non-procedural access an important feature of DBMS? Ans: Non-procedural access can reduce the number of lines of code by a factor of as compared to procedural access.

Because a large part of business software involves data access, non-procedural access can provide a dramatic improvement in software productivity.

What is the connection between nonprocedural access and application form or report development? Can nonprocedural access be used in application development? Ans: The connection between nonprocedural access and application form or report development is that non-procedural access is used in application development to indicate data requirements.

Non-procedural access makes form and report creation possible without extensive coding. As part of creating a form or report, the user indicates the data requirements using a nonprocedural language SQL or graphical tool.

What is difference between a form and a report? Ans: Data entry forms provide a convenient way to enter and edit data, while reports enhance the appearance of data that is displayed or printed. What is a procedural language interface? Ans: A procedural language interface adds the full capabilities of a computer programming language. Non-procedural access and application development tools, though convenient and powerful, are sometimes not efficient enough or do not provide the level of control necessary for application development.

When these tools are not adequate, DBMSs provide the full capabilities of a programming language. What is a transaction? Ans: A transaction is a unit of work that should be processed reliably without interference from other users and without loss of data due to failures.

Examples of transactions are withdrawing cash at an ATM, making an airline reservation, and registering for a course. What features does a DBMS provide to support transaction processing? Ans: A DBMS ensures that transactions are free of interference from other users, parts of a transaction are not lost due to a failure, and transactions do not make the database inconsistent.

The user does not know the details about transaction processing other than the assurances about reliability.

For the database in question 1, describe a transaction that uses the database. How often do you think the transaction is submitted to the database? How many users submit transactions at the same time? Make guesses for the last two parts if you are unsure.

Ans: The example of transaction that uses the University Database is registering for a course. The University Database ensures that the registering for a course is free of interference from other students or users. Parts of course registration are not lost due to a failure, and the registering for a course does not make the university database inconsistent. The transaction is often submitted to the database. Hundreds of students can submit transactions at the same time.

What is an enterprise DBMS? Ans: An enterprise DBMS supports databases that are often critical to the functioning of an organization. Enterprise DBMSs usually run on powerful servers and have a high cost. What is a desktop DBMS? It supports limited transaction processing features but has a much lower cost than an enterprise DBMS. Desktop DBMSs support databases used by work teams and small businesses.

What is an embedded DBMS? As the name implies, an embedded DBMS resides in a larger system, either an application or a device such as a Personal Digital Assistant or smart card.

Embedded DBMSs provide limited transaction processing features but have low memory, processing, and storage requirements. What were the prominent features of first generation DBMSs? Ans: File structures and proprietary program interfaces were the prominent features of first generation database software. What were the prominent features of second generation DBMSs?

Ans: Networks and hierarchies of related records along with standard program interfaces were the prominent features of second generation database software. What were the prominent features of third generation DBMSs? Ans: Non-procedural languages, optimization, and transaction processing were the prominent features of third generation database software.

What are the prominent features of fourth generation DBMSs? Ans: Support for multi-media data, active databases, data warehouses, and distributed processing are the prominent features of fourth generation database software. For the database you described in question 1, make a table to depict differences among schema levels.

Ans: Schema level. The registration form View, the report of grade View, the faculty assignment form View, and the report of faculty workload View. What is the purpose of the mappings in the Three Schema Architecture?

Is the user or the DBMS responsible for using the mappings? Ans: The purpose of the mappings in the Three Schema Architecture is to describe how a schema at a higher level is derived from a schema at a lower level. The DBMS, not the user, is responsible for using the mappings.

Explain how the Three Schema Architecture supports data independence? Ans: The Three Schema Architecture is a standard that serves as a guideline about how data independence can be achieved. Typically, applications access a database using a view. The DBMS then transforms the conceptual schema request into a request using the internal schema.

Most changes to the conceptual or internal schema do not affect applications because applications do not use the lower schema levels. In other words, why not have the server do all the processing? Ans: To improve performance and availability of data, distributed processing allows geographically dispersed computers to cooperate when providing data access. Work can be balanced between a server and a client to efficiently process data access requests.

Ans: Because data can be stored in different locations for management and security, data are sometimes stored on several computers rather than on a single computer.

For the database in question 1, describe how functional users may interact with the database. Try to identify indirect, parametric, and power uses of the database. Ans: In the university database, a student can be an indirect user when student requests and receives the transcript. A student can be a parametric user when student registers for a course.

Explain the differences in responsibilities between an active functional user of a database and an analyst. What schema level is used by both kinds of users? Ans: A functional user may participate in designing and using databases, while an analyst is responsible for collecting requirements, designing applications, and implementing information system. External level is used by both kinds of users.

Which role, database administrator or data administrator, is more appealing to you as a long-term career goal? Briefly explain your preference. However, an example response might be: Data administrator is more appealing to me as a long-term career goal because the Data administrator has broader responsibilities than the database administrator.

Data administrator is primarily a planning role, while database administrator is a more technical role focused on individual databases and DBMS.

Data administrators also view the information resource in a broader context and consider all kinds of data, both computerized and noncomputerized. What market niche is occupied by open source DBMS products.? Ans: Many organizations have reported cost savings using open source DBMS products, mostly for non mission critical systems.

What is the relationship between a system and an information system? Ans: A system is a set of related components that work together to accomplish some objectives. An information system is a system; however, an information system manipulates data rather than a physical object. Provide an example of a system that is not an information system.

An example might be: An ecology system. For an information system of which you are aware, describe some of the components input data, output data, people, software, hardware, and procedures.

However, the question is looking for the following type of response: Input data is used in the processes of the system. Output data is produced by the system. People interact with the system. Software implements and supports the processes. Hardware is the equipment used in the system. Procedures are steps in the process. An example system is a hospital billing system. Important inputs to the system are patient admittances, patient resources consumed during a hospital stay, third party insurance and government policies, patient checkouts, and payments.

Important outputs are bills to consumers and third party payers. The initial prototype incorporates all requirements B. Prototypes provide for clarification of requirements C. Prototypes provide meaningful feedback to developers D. Prototypes are implemented rapidly. The waterfall model characterizes the following systems development model: A. Prototyping B. Spiral Development D.

Data model development. Select the most appropriate statement about information systems development. The data model is usually produced first B. The process model is usually produced first C. The environment interaction model is usually produced first D. The choice of the first of these three models is purely arbitrary. When designing a database, which of the following is not a required feature? Support of organizational policies B. Provide high quality data C. Limit data access to very few users D.

Allow efficient access to data. If an information system consistently reports outdated inventory levels that causes delays in re-stocking orders, this would be an example of a lack of what characteristic of data quality? Completeness B. Ambiguity C. Reliability D. Which one of the following indicates poor data quality?

Ambiguity B. Consistency C. Completeness D. A supplier shown with two different addresses in two parts of the database would violate: A. Timeliness C.

Consistency D. The non-enforcement of a business rule in a database would be a lack of which characteristic of data quality? Reliability C. Timeliness D. Physical Database Design B.

Conceptual Data Modeling C. Logical Database Design D. Distributed Database Design. Data Requirements are input to the following phase of Database Development: A. Which of the following decisions would be part of Distributed Database Design?

Student data and enrollment data will be stored in two different tables B. An index file will be created on the last name of students in the Student table C.