MISY 5300 Questions with complete solution 2023/2024

MISY 5300 Questions with complete solution 2023/2024Steps in information level design - correct answer Describing the attributes needed for each entity as well as the relationships between the entities based on business rules. This process typically involves creating an entity-relationship (E-R) diagram to visually represent the database design User views - correct answer The specific data needed by a person or process for a particular task One-to-Many Relationship - correct answer Means one record in the table on the "one side of the relationship can be linked or related to many records in the table on the "many" side of the relationship Alternate Key (AK) - correct answer Is a field that contains unique data for each record in the table but is not used as the primary key field for security or other reasons Secondary Key - correct answer Represents a field or combination of fields that may not me unique, but is commonly used for retrieval and this should be indexed Cardinality - correct answer The uniqueness of data values contained in a single field Cartesian Join - correct answer When two tables in a query have no instructions about how to connect their records, each record in one table connects with each record in the other table Composite Entity -