+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
A database
|
is a collection of related files containing records on people, places, or things.
|
|
Entity
|
Each of these generalized categories representing a person, place, or thing on which we store and maintain information is called an
|
|
Attributes
|
Each entity has specific characteristics
|
|
Relational database
|
A type of logical database model that treats data as if they were stored in two- dimensional tables called relations. It can relate data stored in one table to data in another as long as the two tables share a common data element.The most common type.
|
|
Field
|
A grouping of characters into a word, a group of words, or a complete number, such as a person's name or age.
|
|
Rows
|
are commonly referred to as records, or, in very technical terms, as tuples.
|
|
Key field
|
A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted.
|
|
Primary key
|
Unique identifier for all the information in any row of a database table.
|
|
Foreign key
|
Field in a database table that enables users to find related information in another database table.
|
|
Entity- relationship diagram
|
A methodology for documenting databases illustrating the relationship between various entities in the database.The most important piece of information provided by an entity- relationship diagram is the manner in which two tables are related to each other. Tables in a relational database may have one- to- one, one- to- many, and many- to- many relationships.
|
|
Normalization.
|
The process of streamlining complex groups of data to minimize redundant data elements and awkward many- to- many relationships, and increase stability and flexibility.
|
|
Referential integrity
|
Rules to ensure that relationships between coupled database tables remain consistent.
|
|
What is important for any business, large or small, is to have a good data model that includes all of its entities and the relationships among them, one that is organized to minimize redundancy, maximize accuracy, and make data easily accessible for reporting and analysis.
|
True
|
|
It cannot be emphasized enough: If the business does not get its data model right, the system will not be able to serve the business properly. The company’s systems will not be as effective as they could be because they will have to work with data that may be inaccurate, incomplete, or difficult to retrieve.
|
True
|
|
Understanding the organization’s data and how they should be represented in a database is perhaps the most important lesson you can learn from this course.
|
True
|
