Database Development

IT -203-Database Development Week 2 homework canvass Questions # 1-4, page 27 1.What is an entity? riposte well-nigh examples. An entity is a person, place, or social function that is being model. Some examples atomic number 18 employees and work locations atomic number 18 almost(prenominal) entities. Entities are represented by a rectangle(s). 2.What is a neckcloth? Give some examples. A descent is a uniform connection b/t records form two or more display panels. all told relationships elicit be reason as unity-to- maven, 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 allot? 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 associative evade? An associative skirt is an abstract data shell compose of a accruement of unique keys and a appealingness of values, where individually key is associated with one value (or set of values).

4. destine one-to-many relationship. One-to-many relationship means that a row in one table is matched to triplex rows in the scrap table, and row in the second table is matched binding to one row in the for the first time table. 5.How is a one-to-one relationship sculptured in an ER diagram? 6.Define many-to-many relationship. Table design rounds pop the executable ways of intention data relationships. In some situations, multiple entries in a data table are relate to multiple entries in another data table. 7.How is a many-to-many relationship model in an ER diagram?If you unavoidableness to deliver a lavish essay, order it on our website: Ordercustompaper.com

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