Database Design Final Review Essay

2011 Words Oct 12th, 2014 9 Pages
Database Final Exam review 1. What is data? Data are values of qualitative or quantitative variables, belonging to a set of items 2. What is information? Data becomes information after it has been processed to add context, relevance and purpose. 3. Role of data and information – Data and information allow users to make better decisions based on good information and data 4. Field – a column in a table which is a property of an entity (attribute) 5. Record – A row or tuple in a table 6. Tuple – A record or row in a table 7. ACID - ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity means if one part of the transaction fails, all of the transaction fails, leaving the database unchanged.
…show more content…
They are important in data modeling because they set the stage for the proper identification of entities, attributes, relationships and constraints. You translate business rules into data model components by following the basic principles: a noun in a business rule will translate into an entity in the model. a verb (active or passive) associating nouns will translate into a relationship among the entities. 12. Describe the basic features of the relational data model and discuss their importance to the end user and the designer. The importance of the relational data model was essentially that its simplicity set the stage for genuine database revolution. In this model, each table is related to another table by a key, which allows the user to see the data displayed in multiple ways which help to show the relationships. 13. Explain how the entity relationship (ER) model helped produce a more structured relational database design environment. The ER model helped produce a more structured relational database design environment because it allowed designers to visually see entities and their relationships. 14. What is the difference between a database and a table? A table is an object inside a database. A database has tables of data, views, indexes and programs 15. What does it mean to say that a database displays both entity integrity and referential integrity? Entity integrity describes a condition

Related Documents