Manipulating Data Using DBMS GUI Flashcards
It can be one, stand-alone table that can contain many fields of information.
Database
The simplest, yet least powerful type of database and is often referred to as a “flat” database.
Database
Many tables that are linked through common fields and can ensure greater accuracy and less input of data.
Relational Databases
Increase flexibility of data and allow ease of collecting and maintaining historical data.
Relational Databases
These are one-to-one and one-to-many relationships.
Relationships
This relationship ensures that one record in one table has a (and only one) matching record in another table.
One-to-one Relationship
This relationships allow one record in one table and many records in another table.
One-to-many Relationship
These objects generally are tables, queries, forms, and reports.
Database Objects
These objects provide functionality and power to your database information.
Database Objects
It contains or holds the data.
Table (Entity)
It can limit the types of data in fields and can assist in the integrity and accuracy of data.
Table
It is a collection of fields for an item you are tracking.
Record
It is a single row that consists of multiple fields.
Record
These are the different characteristics (attributes) within a Table.
Fields
It is the lowest level of data in a database.
Field
It consists of information about the item you are tracking.
Field
General guidelines in naming any data project
Relate to business, not technical characteristics. Be meaningful, must be to the point Readable Be Unique Follow rules in naming a variable
It is an attribute that cannot be divided into smaller independent attributes. For example, the age (attribute) of a student (entity) cannot further be divided.
Atomic Attribute
It is an attribute that can be divided into smaller independent attribute. The address (attribute) of student (entity) can be further be divided into House no, city and so on.
Composite Attribute
It is an attribute that has only single value for an entity. The age (attribute) of a student (entity) can have only one value.
Single-valued Attribute
It is an attribute that can have multiple values for an entity. The Phone no (attribute) of a student (entity) can have multiple values because a student may have many phone numbers.
Multiple-valued Attribute
It is an attribute that cannot be derived from another attribute. For example, birth date cannot derive from age of student.
Stored Attribute
It is an attribute that can be derived from another attribute. For example, age can be derived from the birth date of the student.
Derived Attribute
It is an attribute that has no value for an entity. For example, there may be a chance when a student has no phone no.
Null-valued Attribute
An attribute that has a unique value for each entity. For example, every student has a unique student no.
Key Attribute
