IT163_Unit2.docx Family Reunion Database Purdue University Global IT163 Family Re

Document Content and Description Below

IT163_Unit2.docx Family Reunion Database Purdue University Global IT163 Family Reunion Database A conceptual model database includes important entities and attributes and the relationships be... tween the two. As the name suggests, a conceptual model is simply a concept for the physical database being created andis used in the planning phase. When designing a conceptual database for a family reunion, the data is modeled in the form of an entity relationship. The entity in this example would be the people attending. Attributes are characteristics of an entity. For example, when collecting data for what kind of shirt someone would need, the person attending the reunion would be the entity and their shirt size or color would be the attribute. While working on a conceptual model, understanding the relationships between entities and attributes is crucial.If these relationships are not clear, then the data will not report correctly when queried. Relationships in a table are either one-to-one, one-to-many and many-to-many (Harrington, 2016). A primary key-foreign key relationship describes a one-to-many relationship between two tables in a relational database (Primary Key-Foreign Key Relationships, 2004). A primary key is the most important thing in a conceptual model. A primary key must be unique and carefully chosen because it can never be duplicated. The table below was created in Microsoft Word, though it may not be pretty, it shows the primary key being the family identification nu. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages