Database Development

IT -203-Database Development Week 2 homework Review Questions # 1-4, rapscallion 27 1.What is an entity? grant some examples. An entity is a person, place, or social occasion that is being pose. Some examples are employees and work locations are two entities. Entities are represented by a rectangle(s). 2.What is a rip? Give some examples. A descent is a limpid connection b/t records form two or more display panels. All relationships elicit be reason as one-to-one, one-to-many, or many-to-many. (e.g., a guest places orders; an employee has dependents; and e.t.c) 3.What is an evaluate? Give some examples. An attribute is a plaza of an entity or a relationship. For example, employee id is attributing of the employee entity. 4.What symbols are used in an ER diagram for entities, relationships, and attribute? Review Questions #3-7, page 61 3. What is an associable evade? An associative control panel is an abstract data typ e compose of a collection of unique cays and a collection of values, where individually key is associated with one value (or set of values).

4. Define one-to-many relationship. One-to-many relationship heart that a row in one table is matched to soprano rows in the scrap table, and row in the second table is matched back to one row in the for the first clipping table. 5.How is a one-to-one relationship modeled in an ER diagram? 6.Define many-to-many relationship. Table design rounds out the executable ship canal of designing data relationships. In some situations, seven-fold entries in a dat a table are relate to multiple entries in a! nother data table. 7.How is a many-to-many relationship model in an ER diagram?If you want to deliver a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper