Data Modeling Exam Questions and All Correct Answers

Data Modeling Exam Questions and All Correct Answers What are the four phases of database design? - ANSWER requirements collection and analysis conceptual design logical design physical design What are entities? - ANSWER specific objects or things in the mini-world that are represented in the database. What is an attribute and how are they related to entities? - ANSWER attributes are properties used to describe an entity. a specific entity will have a value for each of its attributes. For example: Name = John Pong SSN = Address = His house Sex = Yes please birth = 09 Jan 2055 What are the three types of attributes? - ANSWER simple (atomic) or composite: gender is a simple attribute composition may form a hierarchy where some components are themselves composite. single/multi-valued: previous degrees of a student denoted as {PreviousDegrees} Stored or derived