Computer Science 4.10

an ______ is a category of object, person, event or thing of interest about which data needs to be recorded

each entity in a database has _________

an _________ is used to represent a property, a quality or a characteristic that describes an entity

an attribute is used to represent a property, a quality or a characteristic that describes an _______

a _______ key is a field in a database that acts as a unique identifier

a __________ _______ key is used when two or more attributes are needed t uniquely define a record

a _______ key is an attribute that creates a join between two tables

how can entities be related?

• one-to-one

• one-to-many

• one-to-several

• many-to-many

a _____ is a graphical way of representing the relationships between entities

• entity relationship table

• entity matrix

• entity relationship diagram

• entity table

__________ is a process used to come up with the best possible design for a database