What is a person place thing transaction or event about which information is stored?
Relational Database Fundamentals: Database – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Database models include:
Entities and Attributes: Entity – a person, place, thing, transaction, or event about which information is stored
Attributes (fields, columns) – characteristics or properties of an entity class
Keys and Relationships: Primary keys and foreign keys identify the various entity classes (tables) in the database
Relational Database Advantages: Database advantages from a business perspective include
2. Increased scalability and performance A database must scale to meet increased demand while maintaining acceptable performance levels
3. Reduced information redundancy Databases reduce information redundancy
Inconsistency is one of the primary problems with redundant information 4. Increased information integrity (quality) Information integrity measures the quality of information. Integrity constraint rules that help ensure the quality of information Relational integrity constraint – is used to ensure accuracy and consistency of data in a relational database.
Business-critical integrity constraint –In database management, business-critical integrity constraints enforce a company’s rules. 5. Increased information security Information is an organizational asset and must be protected and Databases offer several security features including:
Data-driven Web sites – an interactive Web site kept constantly updated and relevant to the needs of its customers through the use of a database. A data-driven Web site invites visitors to select and view what they are interested in by inserting a query, which the Website then analyzes and custom builds a Web page in real-time that satisfies the query. Data-Driven Web Site Business Advantages
Data-Driven Business Intelligence (BI) BI in a data-driven Web site – Web site can offer insight into the business, such as items browsed, frequent requests, items bought together, etc. Integrating Information among Multiple Databases
That’s all for chapter 7. Thanks for reading! 🙂 Integrating Information among When data is stored in one place it means it is ________?Normalization is the process of reorganizing data in a database so that it meets two basic requirements: There is no redundancy of data, all data is stored in only one place.
What is a person place or thing for which data is collected stored and maintained?An entity is a person, place, thing, or event on which we store and maintain information. An order is a typical entity in a sales order file, which maintains information on a firm's sales orders. Each characteristic or quality describing a particular entity is called an attribute.
Which database term is a person place object event or idea?An entity is a person, place, object, event, or idea for which you want to store the process data.
What is the duplication of data or the storage of the same data in multiple places?Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many businesses.
|