What is entity another name for? What uniquely represents a record or row? What is used to link the supplier and part tables by entering SupplierID in the part table? Describe characteristics about relational databases: What is an entity-relationship diagram? What is a data dictionary? What does this describe: "an automated or manual tool for storing and organizing information about the data maintained in a database" What is data definition? What is a specific software for creating, storing, organizing, and accessing data from a database? What is an example of DBMS desktop system geared toward smaller business data needs?

1. What is entity another name for?

An entity is another name for a table in a relational database.

2. What uniquely represents a record or row?

A primary key uniquely represents a record or row. This key field is the unique identifies for all the information in any row of the table, and a primary key cannot be duplicated.

3. What is used to link the supplier and part tables by entering SupplierID in the part table?

A foreign key is used to link tables. In the supplier table, supplier number is the primary key. When the field supplier number appears in the part table, it is called a foreign key.

4. Describe characteristics about relational databases:

A customer's name would not make a good primary key. A primary key cannot be duplicated. A foreign key can be duplicated. The entity-relationship diagram depicts the relationships among tables in a database. Tables can have one-to-many relationships or one-to-one relationships.

5. What is an entity-relationship diagram?

An entity-relationship diagram is a methodology for documenting a database illustrating the relationship between various entities in the database.

6. What is a data dictionary?

As part of a DBMS, a data dictionary documents information about a database. The data dictionary describes the details about the database.

7. What does this describe: "an automated or manual tool for storing and organizing information about the data maintained in a database"

A data dictionary

8. What is data definition?

Data definition is a DBMS capability that specifies the structure and content of the database.

9. What is a specific software for creating, storing, organizing, and accessing data from a database?

DBMS; the DBMS relieves the user of having to understand where and how the data are stored by separating the logical and physical views of the data.

10. What is an example of DBMS desktop system geared toward smaller business data needs?

Access; Microsoft Access is a DBMS for desktop systems, whereas DB2, Oracle Database, and Microsoft SQL Server are DBMS for large mainframes and midrange computers. MySQL is a popular open-source DBMS. All of these products are relational DBMSs that support a relational database.