Scenario: You are going to be in charge of your family reunion this year, and yo

Question

Scenario: You are going to be in charge of your family reunion this year, and you have decided to set up a database to hold all your family information.

Design your family reunion database based on some of the needs and requirements you determined. You will define specific entities and attributes that you want to include, and you will use these to create a conceptual model.

Using your favorite drawing program, create a conceptual model of your family database using at least two tables.

- Identify the entities and attributes for your conceptual model.

- Identify the relationships between the entities.

Explanation / Answer

Entity1

Family:

attributes(Family id,Family name,Headof the family,wife name, childcount)

Entity2:

individual

(personid,name,familyid, date of birth, gender, role)

entity 3:works

(company name, location,personid, designation)

entity4:studyin

(schoolid,schoolname, location,personid,courseid,coursename,enroldate)

relationships:

individual belongs to a family

Individual may work in a company,

individual may study in some university.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.