Plug_in_T5 - P L U G - I N T5 Designing Database...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
T5-2 * Plug-In T5 Designing Database Applications Introduction Businesses rely on their database systems for accurate, up-to-date information. Without those databases of mission critical information, most businesses would be unable to perform their normal daily transactions, much less create summary reports that help management make strategic decisions. To be useful, the infor- mation must be accurate, complete, and organized in such a way that it can be retrieved when needed and in the format required. The core units introduced the database, which maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses). A database management system (DBMS) is software through which users and application programs interact with a database. The relational database model is a type of database that stores its information in the form of logi- cally related two-dimensional tables. This plug-in will build on the core units by providing specific details about how to design a relational database application. Entities and Data Relationships There are numerous elements in a business environment that need to store infor- mation, and those elements are related to one another in a variety of ways. Thus Designing Database Applications PLUG-IN T5 LEARNING OUTCOMES 1. Describe the purpose of the relational database model in a database management system. 2. List the relational database model’s basic components. 3. Describe why entities and attributes are organized into tables. 4. Describe how data redundancy is handled in the relational database model. 5. Explain the need for an entity-relationship diagram in a database management system. 6. Describe the Chen model symbols used in entity-relationship modeling. 7. Explain the purpose of normalization. 8. Describe the first three normal forms typically used in normalization.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
* Plug-In T5 Designing Database Applications * T5-3 a database must contain not only the information but also information about the relationships among the information. The idea behind a database is that the user, either a person working interactively or an application program, has no need to worry about the way in which infor- mation is physically stored on disk. A database management system translates between the user’s request for information and the physical storage. A data model is a formal way to express data relationships to a database man- agement system (DBMS). The underlying relationships in a database environment are independent of the data model and therefore independent of the DBMS that is being used. Before designing a database for any data model, data relationships need to be defined. An entity relationship diagram (ERD) is a technique for docu- menting the relationships between entities in a database environment.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/03/2011 for the course BUS 391 at Cal Poly.

Page1 / 20

Plug_in_T5 - P L U G - I N T5 Designing Database...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online