What type of relationship exists between this pair of related entities?
BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many
Storing the same data in more than one place is called ____. Correct Answ
...
What type of relationship exists between this pair of related entities?
BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many
Storing the same data in more than one place is called ____. Correct Answer: redundancy
Customers, cars, and parts are examples of: Correct Answer: entities
An association between entities is known as a ____. Correct Answer: relationship
A visual way to represent a database is with a ____. Correct Answer: entry-relationship diagram
Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Correct Answer: DBMSs (Data Base Management Systems)
A person's name, birthday, and social security number are all examples of: Correct Answer: attributes
________ are established between entities in a well-structured database so that the desired information can be retrieved. Correct Answer: Relationships
____ are screen objects used to maintain, view, and print data from a database. Correct Answer: Forms
An integrity constraint is a rule that ____. Correct Answer: data must follow in the database
____ is the prevention of unauthorized access to the database. Correct Answer: Security
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a: Correct Answer: Entity
A ____ is a characteristic or property of an entity. Correct Answer: Attribute
The ____ of an entity become the columns in the database table. Correct Answer: attributes
A database has ____ if the data in it satisfies all established integrity constraints. Correct Answer: Integrity
________ is a property that lets you change the structure of the database without requiring you to change the programs that access the database Correct Answer: Data independence
When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____. Correct Answer: write both the table name and the column name, separated by a period
[Show More]