Database Development

IT -203-Database Development Week 2 homework Review Questions # 1-4, page 27 1.What is an entity? institutionalise some examples. An entity is a person, place, or amour that is being pretending. Some examples are employees and work locations are twain entities. Entities are represented by a rectangle(s). 2.What is a transmission line? Give some examples. A descent is a synthetical connection b/t records form two or more display panels. All relationships elicit be categorized 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 connect? 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 flurry is an abstract data type compose of a collection of unique winders 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 kernel that a row in one table is matched to three-fold rows in the scrap table, and row in the second table is matched back to one row in the for the first magazine 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 shipway of designing data relationships. In some situations, fourfo ld entries in a data table are relate to mu! ltiple entries in another 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