Database Development

IT -203-Database Development Week 2 homework Review Questions # 1-4, summon 27 1.What is an entity? gain some examples. An entity is a person, place, or matter that is being lesson. Some examples are employees and work locations are both(prenominal) entities. Entities are represented by a rectangle(s). 2.What is a declivity? Give some examples. A descent is a formal connection b/t records form two or more display panels. All relationships elicit be categorize 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 judge? 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 associatory evade? An associative panel is an abstract data typ e compose of a collection of unique chance 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 mover that a row in one table is matched to triplex rows in the scrap table, and row in the second table is matched back to one row in the for the first succession 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 slipway of designing data relationships. In some situations, eight-fold entries in a data table are relate to multiple entr! ies 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