INF 2603: Chapter 2 Q&A

INF 2603: Chapter 2 Q&A Data modelling - answer-the process of determining the users' information needs and identifying relationships among the data Data model - answer-A representation, usually graphic, of a complex "real-world" data structure. Data models are used in the database design phase of the Database Life Cycle. Entity - answer-A person, place, thing, transaction, or event about which information is stored Attribute - answer-a characteristic of an entity. It has a name and data type Relationship - answer-An association between entities. one-to-many relationship (1:M) - answer-A relationship between two tables in a database in which one record in the primary table can match many (zero, one, or many) records in the related table. many-to-many relationship (M:N) - answer-A relationship in which one record in a particular record type can be related to more than one record in another record type, and vice versa one-to-one relationship (1:1) - answer-a relationship between two entities in which an instance of one entity can be related to only one instance of a related entity constraint - answer-A restriction placed on data, usually expressed in the form of rules. For example, "A student's GPA must be between 0.00 and 4.00." They are important because they help to ensure data integrity...