IT-203: Database Development

293 Words2 Pages
IT -203-Database Development Week 2 homework Review Questions # 1-4, page 27 1. What is an entity? Give some examples. An entity is a person, place, or thing that is being model. Some examples are employees and work locations are both entities. Entities are represented by a rectangle(s). 2. What is a relationship? Give some examples. A relationship is a logical connection b/t records form two or more tables. All relationships can be categorized as one-to-one, one-to-many, or many-to-many. (e.g., a customer places orders; an employee has dependents; and e.t.c) 3. What is an attribute? Give some examples. An attribute is a property of an entity or a relationship. For example, employee id is attributing of the employee entity. 4.…show more content…
What symbols are used in an ER diagram for entities, relationships, and attribute? Review Questions #3-7, page 61 3. What is an associative table? An associative table is an abstract data type composed of a collection of unique keys and a collection of values, where each key is associated with one value (or set of values). 4. Define one-to-many relationship. One-to-many relationship means that a row in one table is matched to multiple rows in the second table, and row in the second table is matched back to one row in the first table. 5. How is a one-to-one relationship modeled in an ER

More about IT-203: Database Development

Open Document