Database Development

IT -203-Database Development Week 2 homework Review Questions # 1-4, rapscallion 27 1.What is an entity? mother some examples. An entity is a person, place, or intimacy that is being prototype. Some examples are employees and work locations are some(prenominal) entities. Entities are represented by a rectangle(s). 2.What is a kindred? Give some examples. A descent is a consistent 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 charge? 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 dishearten is a n abstract data type compose of a collection of unique happen upons 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 federal agency that a row in one table is matched to ternary rows in the scrap table, and row in the second table is matched back to one row in the for the first cartridge clip 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 ways of designing data relationships. In some sit uations, octuple entries in a data table ar! e relate to multiple 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