Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / 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?
An entity is another name for a table in a relational database.
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.
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.
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.
An entity-relationship diagram is a methodology for documenting a database illustrating the relationship between various entities in the database.
As part of a DBMS, a data dictionary documents information about a database. The data dictionary describes the details about the database.
A data dictionary
Data definition is a DBMS capability that specifies the structure and content of the 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.
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.
